Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,531 through 40,545 (of 59,072 total)

RE: i need logic to get the days for most recent week that ends with Friday

purushotham.k9 (12/22/2009)
I have a table in the table datefiled is the column my data base. That column has daily date. using that i have to slect the transaction count...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 22, 2009 at 6:33 am

#1095361
RE: Convert GETDATE() to YYYYMMDD

I guess that's why I don't use it... I don't need to match on approximate data. 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 22, 2009 at 6:25 am

#1095355
RE: i need logic to get the days for most recent week that ends with Friday

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 22, 2009 at 12:52 am

#1095263
RE: i need logic to get the days for most recent week that ends with Friday

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 22, 2009 at 12:49 am

#1095262
RE: Baffling performance issue

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 22, 2009 at 12:16 am

#1095256
RE: assigning a record form one table to another

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2009 at 11:57 pm

#1095255
RE: i need logic to get the days for most recent week that ends with Friday

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2009 at 9:53 pm

#1095245
RE: i need logic to get the days for most recent week that ends with Friday

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2009 at 9:47 pm

#1095244
RE: Temporary tables

PSGS (12/21/2009)
NA
3 posts... 2 deleted. Really bad form... 😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2009 at 9:40 pm

#1095242
RE: Temporary tables

BrainDonor (12/21/2009)
Have a look at their history - it isn't the first time they've done that.
I don't think some people appreciate the hoops others are prepared to jump through to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2009 at 9:35 pm

#1095241
RE: Text Editor for Very Large Files

steveb. (12/17/2009)
I use Textpad for opening large files and it works very well
http://www.textpad.com/index.html
I'll second that... Textpad and UltraEdit are both good in my book.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2009 at 9:33 pm

#1095240
RE: Error: Cannot load script for execution.

shriramrc 75244 (12/21/2009)
Hi,
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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2009 at 9:32 pm

#1095239
RE: Fill Factor Calculation

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2009 at 9:28 pm

#1095237
RE: Compare documents in folder to items in a table

Brandie Tarvin (12/21/2009)
Now, see, I've never heard of xp_DirTree before now. And for a moment, I actually considered changing the code I had to use it.
And then you spoiled...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2009 at 9:22 pm

#1095236
RE: Temp Tables

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
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2009 at 9:16 pm

#1095235

Viewing 15 posts - 40,531 through 40,545 (of 59,072 total)