Viewing 15 posts - 52,276 through 52,290 (of 59,070 total)
GSquared (2/28/2008)
alter dbo.TableA
add DateColumnDate as cast(convert(varchar(25), DateColumn,...
February 28, 2008 at 7:23 am
David Jackson (2/28/2008)
where CreatedDate between dateadd(dd, datediff(dd,0,Getdate()),0) --midnight TODAY
and dateAdd(ss,-1,dateAdd(dd,1,dateadd(dd, datediff(dd,0,Getdate()),0)))...
February 28, 2008 at 7:14 am
Nicely done, Gregory Jackson. Outstanding intro to the pitfalls of doing calculations in the WHERE clause.
February 28, 2008 at 6:59 am
Manie Verster (2/28/2008)
February 28, 2008 at 6:39 am
I believe that is correct... I say "believe" because I've never had to do it... I've only read about it. Gails snapshot option is also viable.
February 28, 2008 at 6:28 am
Rumor has it that creating a table on a different filegroup will do what you ask.
February 27, 2008 at 7:31 pm
You know why #77? You get "eight" more 😉
February 27, 2008 at 7:17 pm
Matt Miller (1/28/2008)
I can't take credit for it - I got clued into this by Jeff Moden (who was using 2000's syscolumns equivalent).
Was doing some research on Tally tables and...
February 27, 2008 at 6:42 pm
Just curious... did that solve your problem or did you die? 😉
February 27, 2008 at 6:37 pm
Heh... nah... it's only 0.229 M rows... same as the other two tests...
I did mislabel it though... probably due to low Caffeine with a Niquil kicker, as well... the last...
February 27, 2008 at 5:40 pm
Okidoki... first things first... If you don't already have a Tally table, now is the time to add one to your arsenal of SQL prestidigitation... a Tally table (also known...
February 27, 2008 at 5:26 pm
Perfect... I'll be back soon...
February 27, 2008 at 3:34 pm
Sorry... just as a courtesy, I should post the code for making a Tally table, huh?
--===== Create and populate the Tally table on the fly
SELECT TOP 19000 --equates to...
February 27, 2008 at 3:31 pm
Yep... I'm aware of that, but thanks for making sure, Ian.
So far as using spt_Values as a source of numbers in production, I NEVER do it... I always use a...
February 27, 2008 at 3:27 pm
Ok... is there anything like a CustID or EmployeeNum or some column that I can relate back to that uniquely identifies a given row? Not quite the same as...
February 27, 2008 at 3:04 pm
Viewing 15 posts - 52,276 through 52,290 (of 59,070 total)