Viewing 15 posts - 2,551 through 2,565 (of 4,080 total)
Good question. Gugan, are you dealing with the data from some kind of statistical analysis software? The stats wizards in our analytics group always view data as...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 24, 2009 at 11:00 am
AJ, is there an ORDER BY in your query by any chance?
I ask because when you SELECT TOP (N) rows without an ORDER BY, the execution plan...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 24, 2009 at 10:41 am
Double tally parse with xml concatenation. That was fun. 😀
For my next trick, I will attempt a double gainer with a half twist....
DECLARE @input varchar(100)
DECLARE @output...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 24, 2009 at 10:31 am
Lo, I am a prophet. 😎
Of course you can populate a combo table with whatever you want. If you are going to be populating [TimeLogReason], [Type], 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
August 24, 2009 at 9:38 am
I suspect you are going to make the requirements more complicated, but this is a start. We simply create a table to hold all four possible combinations and then...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 4:25 pm
The ## at the beginning of a temp table name designates that the table is a global temporary table.
Quoting from BOL: Global temporary tables are visible to any user...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 3:59 pm
Alvin: Keyboard!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 3:48 pm
I think that we should be teaching better things than that.
Hear, hear !!
(Applause, thunderous applause...)
Hey Lynn, will you check double-check my last post to Trudye? ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 2:37 pm
Trudye, we're getting closer, but walk with me just a little further, please. Your original code referenced HDR, DTL and Run_Log tables. You showed data for...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 2:32 pm
Yes, but he is too much of an *** to feel it. (Associate?, assistant?, asset?)
As far as he is concerned, his poor behavior was rewarded.
You've wasted too...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 1:31 pm
I just read the "jibber jabber" comment. It was over-the-top offensive, followed by smugness about his rudeness "working." I can't express my sentiments adequately without...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 1:26 pm
Any one else agree with my sentiment here?
That depends... does the sentiment include pillory or bastinado?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 10:42 am
In addition to ROW_NUMBER(), you should also read up on the RANK() and NTILE() functions.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 10:39 am
SQL is limited in this respect too. Sorry.
The sample code below will do what you want, after a fashion. But I don't recommend this at all. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 10:17 am
Using LEFT(@date,3) gets you a 3 character abbreviation for the month name, or you could create a table
to look up up the name to go with the number returned by...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 21, 2009 at 10:10 am
Viewing 15 posts - 2,551 through 2,565 (of 4,080 total)