Viewing 15 posts - 40,531 through 40,545 (of 59,072 total)
purushotham.k9 (12/22/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 22, 2009 at 6:33 am
I guess that's why I don't use it... I don't need to match on approximate data. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
December 22, 2009 at 6:25 am
Sorry... I was still focused on your original post... that code was for only 1 week... this is for 2...
SELECT DATEADD(dd,DATEDIFF(dd,6,GETDATE()+1)/7*7,-9)+t.Number
FROM Master.dbo.spt_Values t
WHERE t.Type = 'P'
...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 22, 2009 at 12:52 am
Using the words "very urgent" on this forum will likely get you black balled.;-) Seriously.
Try this for starters...
SELECT DATEADD(dd,DATEDIFF(dd,6,GETDATE()+1)/7*7,-2)+t.Number
FROM Master.dbo.spt_Values t
WHERE t.Type = 'P'
...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 22, 2009 at 12:49 am
Robert... you have 30 or so joins in your query and the end result according to the Execution Plan you attached is over 4 million rows. First, I don't...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 22, 2009 at 12:16 am
mrpolecat (12/21/2009)
I'm still looking for a set based solution if it is out there.
Do a SELECT/INTO a new table with the identity function... then take (MOD 5)+1 of the identity...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 11:57 pm
Nabha (12/21/2009)
All good answers above,one more way to find your last friday, (and then deduce your other days)
Select dateadd(day, - (datepart(dw, getdate())+1), getdate())
It doesn't appear to work on Saturdays......
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 9:53 pm
vikas bindra (12/21/2009)
Cool. Thanks for showing this. it looks better than converting to varchar
Over a fair number of rows, it's also quite a bit faster because it doesn't have to...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 9:47 pm
PSGS (12/21/2009)
NA
3 posts... 2 deleted. Really bad form... 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 9:40 pm
BrainDonor (12/21/2009)
I don't think some people appreciate the hoops others are prepared to jump through to...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 9:35 pm
steveb. (12/17/2009)
I use Textpad for opening large files and it works very well
I'll second that... Textpad and UltraEdit are both good in my book.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 9:33 pm
shriramrc 75244 (12/21/2009)
I ve done a script task in ssis 2008. My script is about splitting characters. when i try to load my data,my script task is not getting executed....
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 9:32 pm
Don't forget about UPDATE's either. Having a tightly packed table with a FILLFACTOR of 100 on an IDENTITY column is great until you update a VARCHAR column in the...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 9:28 pm
Brandie Tarvin (12/21/2009)
And then you spoiled...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 9:22 pm
Nothing personal but...
Semantics... "When all active tasks have stopped referencing them"... you've combined two requirements and are testing to see if the test taker agree's with your subjective change in...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 21, 2009 at 9:16 pm
Viewing 15 posts - 40,531 through 40,545 (of 59,072 total)