Sometimes you need to return a single column that contains values that are comma separated or pipe separated or what ever floats your boat from a multiple row result set, a perfect example is returning the category id’s for a product that could be in one of more categories but you don’t want to return multiple rows with duplicate information. There are two ways of doing this or two that I know of – meaning simple enough. 1. The COALESCE method, which is probably the most common. This method works by tricking the coalesce function into doing something...
While trying to install SQL server 2008, the installation failed several times because of a single error that reads “The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools.” to fix this error, I simply deleted the following registry key. SOFTWARE\Microsoft\Microsoft SQL Server\90 some say removing SQL Prompt resolved the problem but in my case I have never installed Red-Gate SQL Prompt. DISCLAIMER: Backup your registry before modifying, messing around in your registry usually leads to trouble and reformat.