Well lucky for you you know everything about everything.  I will be dropping my membership to this list now as i cannot stomach your smug know-it-all attitude.

Before I go, try...

Order By in the Select Into gets the data into the temp tale in the specified order

Yes, this looks like the route I will need to take.  I was having trouble getting the data in the correct order using method because the code below throws an...

The full scope of the task is to allow an application to pass in an xml string allowing the user to specify how many records to return, sorted by the...

--Try this in query analyzer:

Declare @variable as bit

Set @Variable = 1

If @Variable = 1

Begin

 Select 'a' as [a], 'b' as , 'c' as [c] into #temp

End

Else

Begin

 Select '1' as [a], '2'...

In your example, you are trying to count something that doesn't exist.  If the number of times where the Answer to Question B was U is 0 then there are...