Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,416 through 35,430 (of 59,099 total)

RE: Rows to Columns in SQL Server

Double post. No posts here, please. Please refer to the other post at the following URL:
http://www.sqlservercentral.com/Forums/Topic1045849-391-1.aspx
--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)

January 11, 2011 at 7:36 am

#1271879
RE: Assigning values to multiple variables with single SELECT (with a twist)

Agreed... either one would do a nice job on such an article.
--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)

January 11, 2011 at 7:13 am

#1271869
RE: Display name of months in a matrix report

durai nagarajan (1/11/2011)
Hi,
the data you are pulling from sql server should have month as a field.
then populate the month in matrix header side and the data as desired.
hope this helps.
Do...
--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)

January 11, 2011 at 7:11 am

#1271865
RE: deduplication

bicky1980 (1/10/2011)
Jason Norsworthy (12/19/2010)
I imagine there are better ways to do this, but this is what I was able to come up with...
select * from
(
select *,
row_number() over(partition by...
--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)

January 10, 2011 at 7:42 pm

#1271699
RE: extract the number before %

mazzz (1/10/2011)
Frances L (1/10/2011)
well , I think if there 100%. then it will different. Thx.
True. Trust me to worry about decimals and miss the obvious 🙂
Did you also check it...
--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)

January 10, 2011 at 7:34 pm

#1271698
RE: How to pass list of values(us,canada,japan) as parameters to SP and get output(10,20,40) as list as well

sqldoubt (1/10/2011)
... and get output as an comma separated list and insert the output values to a table.
I have to tell you that's a very bad thing to do...
--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)

January 10, 2011 at 7:27 pm

#1271697
RE: How to pass list of values(us,canada,japan) as parameters to SP and get output(10,20,40) as list as well

Steve Jones - SSC Editor (1/10/2011)
This might help: http://www.sqlservercentral.com/articles/Array/70702/
Depending on how you structure things, you need to parse your procedure.
Heh... No! 😛
--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)

January 10, 2011 at 7:22 pm

#1271696
RE: Rewriting the query without using 'Insert' <Query Optimization>

Craig Farrell (1/10/2011)
mister.magoo (1/10/2011)
mounish (1/10/2011)
Well, Even though I am not good at using CT Expressions, According to my knowledge, the following should work. But, if I try this, Its showing...
--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)

January 10, 2011 at 7:07 pm

#1271694
RE: Assigning values to multiple variables with single SELECT (with a twist)

WayneS (1/10/2011)
Craig Farrell (1/10/2011)
GSquared (1/10/2011)
Since you're using SQL 2008, can you switch from delimited lists of parameter values to a table variable parameter? Those are more efficient.
I haven't had...
--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)

January 10, 2011 at 7:03 pm

#1271693
RE: updating a column

MonsterRocks (1/9/2011)
CREATE TABLE #TAB2 (SNO INT, UNQ_ID BIGINT) INSERT INTO #TAB2 VALUES(1,10)
i have to increament the value of UNQ_ID by 1 and assign it in one variable....
how it...
--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)

January 10, 2011 at 7:00 pm

#1271692
RE: Query converted into Dynamic SQL string within Stored Proc yields syntax error

I guess I'd like to know why this has to be in dynamic SQL to begin with.
--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)

January 10, 2011 at 6:47 pm

#1271688
RE: Select statement of view stays 5 hours to return results......

Now, THAT'S a Table Spool. Just the estimate, I know, but a 101million row spool? No wonder those distincts are crying.
That's your basic accidental cross join usually caused by 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)

January 10, 2011 at 6:45 pm

#1271686
RE: Proc Performance

BaldingLoopMan (1/10/2011)
also it is bad proctice to default ur input params to null. If its a varchar it's not so bad however dates. Not so good.
I have to ask... why?...
--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)

January 10, 2011 at 6:34 pm

#1271685
RE: Best Fit Algorithm/Function

Gabe,
I agree with Craig... which tag keys do you want to use up first? Also, what do you want to do if you don't have an exact match 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)

January 10, 2011 at 6:18 pm

#1271683
RE: substring funcation.

BaldingLoopMan (1/10/2011)
i'm doing a little string parsing. Does anyone else find it odd that when using the substring function the second param is the starting pos and the third param...
--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)

January 10, 2011 at 6:12 pm

#1271679

Viewing 15 posts - 35,416 through 35,430 (of 59,099 total)