Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,606 through 37,620 (of 59,098 total)

RE: How do I calculate the week number given a date?

Eralper (7/19/2010)
Hello,
Easiest solution is using DATEPART function
select DATEPART(WEEK,GETDATE())
If that is not useful for your requirements, you can also think of to create date table in SQL Server
It depends. What...
--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)

July 19, 2010 at 4:56 pm

#1195219
RE: BCP error

sunny.tjk (7/19/2010)
Hi everyone,
nothing happens when I run this in command prompt:
bcp CRIS_IST.dbo.Blaze69Repository in blazerepo.cris.bcp -T -c -SLUWZD5584 -Uroger -Proger
the table isn't getting loaded with the data which is 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)

July 19, 2010 at 4:52 pm

#1195214
RE: BCP error

Never mind...
--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)

July 19, 2010 at 4:50 pm

#1195211
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/19/2010)
Trey Staker (7/19/2010)
Alvin Ramard (7/19/2010)
mtillman-921105 (7/19/2010)
I'm with Alvin! Yes, come on over here to Memphis and we'll show you what terrific BBQ's all about. 😀
Actually, if you...
--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)

July 19, 2010 at 4:46 pm

#1195207
RE: Are the posted questions getting worse?

Alvin Ramard (7/19/2010)
mtillman-921105 (7/19/2010)
I'm with Alvin! Yes, come on over here to Memphis and we'll show you what terrific BBQ's all about. 😀
Actually, if you come to Memphis...
--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)

July 19, 2010 at 4:20 pm

#1195200
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

kjc-1057161 (7/19/2010)
I've got a horrendous cursor problem, to do with calculating interest owed on accounts. The summary is that rather than use a simple calculation to work out the interest,...
--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)

July 19, 2010 at 4:16 pm

#1195197
RE: Help with using mulitple replace in a function

Eugene Elutin (7/19/2010)
Jeff Moden (7/15/2010)
Eugene Elutin (7/14/2010)
Julie Breutzmann (7/14/2010)
...
What would be an efficient way to code this?
...
If you need high-performance heavy string manipulation functions write them as CLR functions 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)

July 19, 2010 at 4:08 pm

#1195192
RE: Generating SubTotals using GROUPING

R.P.Rozema (7/19/2010)
Guys, this topic was about the article on the usage of grouping() but you've moved away to wether or not to add a sort clause now. I feel a...
--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)

July 19, 2010 at 4:00 pm

#1195182
RE: Generating SubTotals using GROUPING

Hugo Kornelis (7/19/2010)
Jeff Moden (7/19/2010)
Hugo,
The gain is that there is nothing you can naturally order by that will give you the correct original order. 😉
Huh?
USE AdventureWorks2008;
SELECT TerritoryID, GROUPING(TerritoryID),
...
--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)

July 19, 2010 at 3:53 pm

#1195173
RE: Becoming a business intelligence architect

mike mcneer (7/19/2010)
Maybe a explanation of how you would go about getting the experience needed to become one would be helpful. I would be interested to hear this as well....
--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)

July 19, 2010 at 3:42 pm

#1195167
RE: Generating SubTotals using GROUPING

Hugo,
The gain is that there is nothing you can naturally order by that will give you the correct original order. 😉 And stop playing the "gotcha back" tricks... can...
--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)

July 19, 2010 at 6:34 am

#1194855
RE: Query time out

mithun.gite-1086228 (7/18/2010)
Thanks for the reply,
This is not a actually a SQL job but its just similar to that , at scheduled time bunch of sps will start executing pulling 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)

July 18, 2010 at 12:58 pm

#1194655
RE: Average Inventory (Stock) Age

gah (7/18/2010)
also a sincere thanks to Jeff Modem for his article
It's actually spelled "Moden" but I'll take the compliment. 🙂 Thanks, Graham.
--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)

July 18, 2010 at 12:54 pm

#1194653
RE: Cursors to compare to values

Sagar Sawant (7/17/2010)
Hi,
Why you are using cursors? it's degrade the performance of sql query and also consuming memory..
Use while loop instead of cursor. [font="Arial Black"]You can see the dramatic performance[/font]......
--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)

July 18, 2010 at 12:44 pm

#1194650
RE: BCP Utility

Do the changes you're making make some data wider than the column that it was intended for?
--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)

July 18, 2010 at 12:35 pm

#1194648

Viewing 15 posts - 37,606 through 37,620 (of 59,098 total)