Hey Kat,

I think you will need to use a case statement to tabulate your results the way you wanted. See BOL on how to use a case statement:

I use music to complement the state of mind I'm in. If I'm doing something I already know very well, which is 90% of the time, I prefer heavy metal...

This is a very old thread! I am a touch-typist averaging 70WPM. My burst speed is definitely 100+ WPM, but I make a ton of mistakes, which is why three...

What the heck!? Was it supposed to be identity (-1,-1)?

I wrote it out in SQL and my server returns -1, 0, 1. What's the deal?

I did a cast(0 as datetime), but then I thought hmm. can negatives be converted to datetime? I picked 64000, but that failed, so then I went incrementally to -53690...

I have a work-issue HP EliteBook 6930p. I haven't been fond of HP-anything until this laptop. It is well built, fast, and has the stick. The touchpad is also recessed...

I prefer to use dynamic SQL, and that has always resulted in good performance. However, in this application I chose to encapsulate the query into a stored procedure for the...

THANK YOU!!! I ran into a similar issue where I created a stored procedure from a well perfroming query (2 seconds), which took 40 seconds as a stored procedure. What...