Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,576 through 37,590 (of 59,072 total)

RE: Parsing QueryString to SQL Table

@RJ,
Are you all set on this?
--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 20, 2010 at 5:58 am

#1195437
RE: Using Format File with IDENTITY COLUMN

For starters...
1. "SQL Lat..." is not a valid collation.
2. For field 35 (the ID field you're trying to ignore), there must be a length.
3. If you're using...
--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 5:12 pm

#1195225
RE: Function with Select * that references a View

doobya (7/19/2010)
I wrote a tool for this type of dependency refresh problem
it calculates the dependency graph for a group of changing objects
and generates the correct dependency-aware script to refresh 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)

July 19, 2010 at 5:00 pm

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

Jeff Moden (7/19/2010)
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....
--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:57 pm

#1195220
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

Viewing 15 posts - 37,576 through 37,590 (of 59,072 total)