Viewing 15 posts - 166 through 180 (of 375 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...
-Ki
August 15, 2011 at 5:30 am
Congrats, Lynn! I hope the new job is everything you want it to be.
-Ki
August 12, 2011 at 5:38 am
Dave23 (8/11/2011)
-Ki
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...
-Ki
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...
-Ki
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...
-Ki
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!!!!!
-Ki
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...
-Ki
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!
-Ki
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...
-Ki
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...
-Ki
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...
-Ki
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...
-Ki
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...
-Ki
August 1, 2011 at 6:14 am
Viewing 15 posts - 166 through 180 (of 375 total)