Viewing 15 posts - 3,361 through 3,375 (of 7,636 total)
David Reed (3/16/2009)
March 16, 2009 at 11:27 am
Right. By this definition then, XML would not be a flat file because it has metadata in it also (specifically, data definitions and "field" identifiers). What's left is...
March 16, 2009 at 11:17 am
Gaby Abed (3/16/2009)
Bob Hovious (3/16/2009)
All hail The Thread... Eternal is The Thread... Great is The Thread... Mighty Mighty is The Thread.Let us make great sacrifice of cursors and recursive CTEs....
"In...
March 16, 2009 at 11:03 am
Sam Iam (3/16/2009)
March 16, 2009 at 10:23 am
In order to answer this question, you would need a very good definition of what a "Flat File" is. This is because there are many, many things that you...
March 16, 2009 at 10:10 am
EvilPostIT (3/16/2009)
Success. See what you think of this.
...(
(substring(sp.columns,((sc.colid)/8)+1,1) & power(2,(sc.colid-(8*((sc.colid-1)/8)))))>0 and sc.colid<8
OR
(substring(sp.columns,((sc.colid)/8)+1,1) & power(2,(sc.colid+1-(8*((sc.colid)/8))))/2)>0 and sc.colid>=8
)
Well since power(2, X+1)/2 is the same as power(2, X) then you don't need the...
March 16, 2009 at 9:50 am
Try this:
Alter Proc spPerfProduct( @DT as datetime ) as
WITH cteCrossTab as (
Select ID as MID
, Coalesce(Max(Case When Perf_dt=@DT Then Net_Perf End), 0.0) as [Dt1]
, Coalesce(Max(Case When Perf_dt=(@DT-1) Then Net_Perf End),...
March 16, 2009 at 9:13 am
karthikeyan (3/16/2009)
You know i have started to learn XML in sql2005 concepts from yesterday. I also wanted to display the second value,but i didn't find it in HELP. Anyway...
March 16, 2009 at 8:35 am
Steve Jones - Editor (3/15/2009)
Gift Peddie, apologies. I've edited the post.
The last sentence in the quoted paragraph needs corrected also. I have already edited my instance, there's still one...
March 15, 2009 at 10:00 pm
Steve Jones - Editor (3/15/2009)
Ouch, do you at least buy the donuts?
Oh, that's the best part... 😛
March 15, 2009 at 9:27 pm
I like to send them out to get Krispy Kremes for the office and then change the locks before they get back.
March 15, 2009 at 8:40 pm
Viewing 15 posts - 3,361 through 3,375 (of 7,636 total)