Viewing 15 posts - 2,806 through 2,820 (of 4,080 total)
Get some sleep, Flo! Wake up in the morning and have more coffee.
Tomorrow is another day. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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,...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 14, 2009 at 1:50 pm
No problem. Hope you didn't mind me poking a little fun.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 14, 2009 at 9:15 am
I'm with Barry. Why waste people's time?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 13, 2009 at 10:03 am
If you are simply wanting counts of loans within the various criteria, try this:
-- produces counts by criteria
select sum(case when amount 15000 and terms 15000 and terms between...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
May 13, 2009 at 8:32 am
Viewing 15 posts - 2,806 through 2,820 (of 4,080 total)