Viewing 15 posts - 2,806 through 2,820 (of 4,081 total)
Calm you must be, Lynn. Dwell on them you should not.
For though their numbers are legion they are not strong in the Force.
Hey Bruce...
May 14, 2009 at 10:51 pm
Get some sleep, Flo! Wake up in the morning and have more coffee.
Tomorrow is another day. 😀
May 14, 2009 at 3:58 pm
GilaMonster (5/14/2009)
Bob Hovious (5/14/2009)
On Qo'noS, none rise to the rank of Klingon Senior DBA except over the bloody bodies of their fallen predecessors.And that's different from current-day corporates how?
On Qo'noS,...
May 14, 2009 at 2:40 pm
Sorry, Alvin. I went to see the new Star Trek movie for a second time last night. 😀
For the record, I don't play the...
May 14, 2009 at 2:11 pm
On Qo'noS, none rise to the rank of Klingon Senior DBA except over the bloody bodies of their fallen predecessors.
May 14, 2009 at 1:50 pm
No problem. Hope you didn't mind me poking a little fun.
May 14, 2009 at 12:50 pm
I went back and looked at your post again. To sum various amount columns into a single results column, you can do one of a couple of things....
May 14, 2009 at 9:43 am
SSIS (Integration Services) is probably going to be your best bet. You could create a scheduled job to do it, rather than have to manually cut and paste...
May 14, 2009 at 9:22 am
Hey Guys,
Sorry for misunderstanding the requirements, I didn't realize multiple rows needed to be summed, but SUM() is the answer.
Why do you need an extra...
May 14, 2009 at 9:15 am
I'm with Barry. Why waste people's time?
May 13, 2009 at 4:29 pm
--
INSERT INTO T1 DEFAULT VALUES;
--
This is right out of the examples in Books Online for the INSERT statement. Sometimes it's as easy to RTFM as it is to...
May 13, 2009 at 4:25 pm
I don't know ... I have trouble with making a connection between Klingons and anything associated with the word "think".
Your mother has a smooth forehead!! :crazy:
May 13, 2009 at 3:17 pm
(note found engraved on a charred bulkhead floating near a wormhole entrance)
Klingons do not use laptops as they are fragile and easily damaged in combat.
May 13, 2009 at 2:00 pm
Your options include:
1. Cut-and-Paste from Sql Server Management Studio (SSMS)
2. Using the "RESULTS to FILE" option in SSMS
3. Using Sql Server Integration Services
4. Creating this...
May 13, 2009 at 10:38 am
Piece of cake.
select
sum(case when amount < 15000 then 1 else 0 end) as criteria1_count,
sum(case when amount 15000 and terms 15000 and...
May 13, 2009 at 10:03 am
Viewing 15 posts - 2,806 through 2,820 (of 4,081 total)