Viewing 15 posts - 166 through 180 (of 374 total)
sql-programmers (8/13/2011)
Please check the below modified code.It shows your expected result.
select p.projectid,
apCount = COALESCE(countap,0)
, arCount = COALESCE(countar,0)
from #projectList...
August 15, 2011 at 5:30 am
Congrats, Lynn! I hope the new job is everything you want it to be.
August 12, 2011 at 5:38 am
Dave23 (8/11/2011)
August 11, 2011 at 12:47 pm
There are also plenty of software packages out there that already do this (provide a sales order processing system) - and might be more cost effective if you have time...
August 11, 2011 at 5:30 am
Grant Fritchey (8/11/2011)
Since all the cool kids are doing it. That makes #14.
...and 15...
August 11, 2011 at 5:24 am
Ninja's_RGR'us (8/10/2011)
In the meantime you can install this. This allows you to change the background color based on the env. you are in.
You just made my day. Half my...
August 10, 2011 at 6:20 am
Gianluca Sartori (8/5/2011)
I'm officially out.I'll never, ever be an employee again.
I'll punch my timecard for the last time in 1 minute.
Good luck!!!!!
August 5, 2011 at 12:23 pm
Jack Corbett (8/5/2011)
What is this "civilization" thing you speak of? Is it a new type of sandwich?
I believe it's a video game...
August 5, 2011 at 12:22 pm
Nice question! I'm really, really glad I stopped, drank more coffee, and thought it through before answering though!
August 5, 2011 at 6:17 am
Lynn Pettis (8/4/2011)
I lovw it when a plan comes together.More to follow late next week.
*wild applause*
Now, if we can just figure out a way to work in a certain black...
August 5, 2011 at 6:10 am
LutzM (8/3/2011)
Kiara (8/3/2011)
...Now, thanks to The Thread, I have beer on the brain too...
Applied from the outside or the inside?
Imaginary type or the liquid form?
That depends on how much...
August 3, 2011 at 10:16 am
Fal (8/3/2011)
Koen Verbeeck (8/3/2011)
If you do try a Belgian beer once more, try one of the trappisten.
And make sure it is server as it should be server, it matters a...
August 3, 2011 at 8:45 am
GSquared (8/1/2011)
It gets worse than just accents.I've had a multitude of people assume I'm not American, because I "speak well" instead of "talk good".
:hehe: Sadly, my experiences with people assuming...
August 1, 2011 at 6:37 am
Britt Cluff (8/1/2011)
Good question, but not sure how you could get it right without guessing.
Believe it or not, for this one, Google. I didn't know the answer (I don't usually...
August 1, 2011 at 6:14 am
Viewing 15 posts - 166 through 180 (of 374 total)