Viewing 15 posts - 21,541 through 21,555 (of 26,490 total)
I guess I didn't do a good job of explaining what I found. I rewrite the code some, and it is posted below along with the statistics time and...
April 13, 2009 at 10:05 pm
In my blog, th flip side, I mention that the post should be concise yet detaled. Sort of an oxymoron, but it works.. The code should be well formatted...
April 13, 2009 at 5:46 pm
Here is my take. When you look at your post, could someone with no knowledge of the problem domain understand the problem you are presenting. If so, then...
April 13, 2009 at 4:32 pm
Flo,
If you check my code, I created the temporary table (#TestData) with definition defined as nvarchar(4000) and when loading it, I selected records where the length of definition was <=...
April 13, 2009 at 4:17 pm
Aaron N. Cutshall (4/13/2009)
Charles Kincaid (4/13/2009)
April 13, 2009 at 4:07 pm
Flo,
I understand needing to work with NVARCHAR(MAX). I was trying to find out why the Tally solution may have been slower, and I think the reason is due to...
April 13, 2009 at 4:00 pm
I think the reason the Tally version is slower has to do with the blob data type, nvarchar(max).
I posted some information in The Thread.
April 13, 2009 at 3:47 pm
Jeff Moden (4/13/2009)
RBarryYoung (4/13/2009)
Jeff Moden (4/13/2009)
April 13, 2009 at 3:43 pm
Does this help you get started?
declare @Date1 datetime,
@Date2 datetime;
select
@Date1 = '2009-04-13 10:00:00',
@Date2 = '2009-04-13...
April 13, 2009 at 9:47 am
Do you still want the results in HH:MM or HH:MM:SS format if the hours exceeds 24 hours? For example 2009-04-12 10:00:00 to 2009-04-13 10:05:00 would be 24:05.
April 13, 2009 at 9:16 am
Unfortunately, I know i won't make it. Work won't pay for it and I can't afford it on my own.
I'd love to come and meet you all.
April 11, 2009 at 3:32 pm
Bob Hovious (4/11/2009)
Okay... how many people here advocate the use of GOTO statements in T-SQL?
I haven't used a GOTO in T-SQL in, I don't know, forever?
Last time I used a...
April 11, 2009 at 8:15 am
Viewing 15 posts - 21,541 through 21,555 (of 26,490 total)