Recent posts

Combine multiple rows using SQL Server 2008

I am using SQL Server 2008. I have provided an image of the output that I intended to make. I want to combine multiple rows and make a single ID, while bringing the Non-Null columns into whole or consolidate them. Please look at the rows and columns below:

ID  ...



Read more
jasmine collins Written on 10/21/2011 in Question

VB Code that can change the color of my sub query

I am using SQL sub query and I have a list of email addresses on it. These are the list of the customer’s software that will expire in 45 days or less. With just a single click, an email will be sent to the customers address. What I want...



Read more
hugh jackson Written on 10/21/2011 in Question

Activate out-of-office notifications in Outlook Express

I am running Windows XP with Outlook Express as my email client. I will be away for a week and could not reply to any incoming messages.  How can I set up my Outlook Express to automatically reply to any incoming messages and inform them that I am away...



Read more
harry1980 Written on 10/21/2011 in Question

Stop sending duplicate copy of my emails

A good friend deceived me. I entrusted him my account in email including the password and all the details for some help in my account. But later on, I realized that he changed some settings in my account that gives him access to interlink his email to another address...



Read more
gwyneth69 Written on 10/21/2011 in Question

Reverting font color in MS-Outlook to its default

I’ve been using Outlook 2000 for a long time. And I can’t seem to change it now for something that has the same functionality. My problem is, when I am trying to forward a message with my username, and then I typed on something, all the text is in...



Read more
floyd Written on 10/21/2011 in Question

Safelist option in Office Outlook is not working

I enabled the “Safelist Only” option in Office Outlook by clicking on Tools>Options>E-mail>Junk E-mail and then checked the Safelist Only.  This is to filter those incoming spam and junk mails that is not on my safe senders list.  But the amount and nature of SPAM did not change. Is...



Read more
erin111 Written on 10/21/2011 in Question

Get rid of SPAM emails in MS-Outlook

I am using MS-Outlook 2007 on sending and receiving mails. But all of a sudden, I started getting a lot of SPAM emails on my inbox that comes from different people using different email addresses.  How can I get rid of that?  



Read more
erika83 Written on 10/21/2011 in Question

Activating Excel Read Spreadsheets Feature

Excel 2002 has the capability to read a range of data back to you. In this way, it can help you compare what you have typed to its original values. This feature can help you verify the accuracy of the data’s you typed. If you are working in English...



Read more
coby_campbell Written on 10/21/2011 in Question

Converting amounts using Excel 2003 and 2007

 

I need help on converting an amount in Euro in Excel 2003. This is to be used for a German supplier that itemized bills for parts in German mark bills. How can I convert it to euro? Please state in your answer on how to do it using Excel...



Read more
clark_anderson Written on 10/21/2011 in Question

Changing value of an argument using MySQL Query

I need help with MySQL query. I want to create a function that will do a lot of sorting on my database. Considering the code below, can I change the default value of a WHERE argument, that will sum up to anything? So the default value of the said...



Read more
chesterhunt Written on 10/21/2011 in Question