Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,871 through 42,885 (of 59,063 total)

RE: show column data as rows

Maybe it's just a bit late for me but I'm thinking you're going to have to explain the mapping on that one just a wee bit more than you have....
--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, 2009 at 12:42 am

#1026759
RE: Using UDF parameter in select statement of UDF

AShehzad (7/19/2009)
I am required to use select statement by parameter provided in UDF. Table name is provided as parameter and it is required to use in select statement in UDF....
--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, 2009 at 12:37 am

#1026756
RE: Returning Multiple Columns - T SQL

Shuaib (6/25/2009)
Hi
I have a comma delimited values and I want to split this values into mulitple columns. Can someone share the idea / scripts?
Ex
Input
@v-2 = 'A,B,C'
Output
Col1 ...
--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, 2009 at 12:10 am

#1026753
RE: Returning Multiple Columns - T SQL

ab5sr (6/25/2009)
I'd look at the split method in .Net to create an array for this. Otherwise you might get stuck with some cheesy TSQL string manipulation.
I know this is an...
--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, 2009 at 12:06 am

#1026751
RE: Creating millions of records in one go

ps (6/22/2009)
Well, Jeff's queries are like that, Rocket speed execution. 😀
:blush: Thanks, Pradeep. :blush: That's an awfully nice compliment especially coming from someone like 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 20, 2009 at 12:02 am

#1026748
RE: sp_MSForeachdb to exclude master DB. doesnt seem to work

So I say to the doctor, "Doc, when I hold my arm up like this, it hurts." Doctor says, "So don't do that."
Being that this is SQL Server 2000...
--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, 2009 at 11:56 pm

#1026747
RE: Raw count for all tables in databsae

Ummmmm.... be careful folks. If you don't run DBCC UPDATEUSAGE(0), you can get some seriously incorrect information. I'll try not to bad mouth the cursor/loop solutions 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 19, 2009 at 11:47 pm

#1026744
RE: Please help in writing a function

Lookup "Expanding Hierarchies" in SQL Server 2000 Books Online.
--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, 2009 at 11:25 pm

#1026738
RE: Best Way To Get A Charater Field using SQL

Provided that you will always have a 2 digit month and a 2 digit year, all you have to do is flip the MMYY to YYMM, add the DD part...
--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, 2009 at 11:23 pm

#1026737
RE: Writetext to all rows returned

Thought I'd "bump" this for you... do you still need help 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 19, 2009 at 11:11 pm

#1026736
RE: set identity_insert mytable on local or global

Edward (7/14/2009)
Yep we are filling the gaps as we are reaching the min/max integer barriers.
Save yourself and others the pain... simply switch the column datatype to BIGINT. You will...
--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, 2009 at 11:09 pm

#1026735
RE: Crosstab not returning desired results

It's simple but no one ever answers my questions once I give an answer. With that in mind, please explain the business reason for wanting to do 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 19, 2009 at 11:01 pm

#1026732
RE: please help! Cursor or loop?

WayneS (7/8/2009)[hrSo, just to make sure I have it correct, I should have used from #tblTest with (TABLOCKX) OPTION (MAXDOP 1) Correct?
Correct. Man... sorry... I got way behind...
--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, 2009 at 10:58 pm

#1026731
RE: Add " + " to add column values dynamically

karthikeyan (7/9/2009)
Greg,
They will pass it as STRING.
Why i need like this?
I have a table called country_exposure
create table country_exposure
(
Fund_Id int,
Malaysia decimal(16,8),
Philippines decimal(16,8),
Taiwan decimal(16,8),
Thailand decimal(16,8),
India decimal(16,8),
Austria decimal(16,8),
Belgium decimal(16,8),
Denmark decimal(16,8),
Finland decimal(16,8)
)
Really, really bad...
--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, 2009 at 10:54 pm

#1026730
RE: Funciton Vs Inline Query

See the following for an answer...
http://www.sqlservercentral.com/articles/Test+Data/61572/
And please stop double and triple posting.
--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, 2009 at 10:50 pm

#1026729

Viewing 15 posts - 42,871 through 42,885 (of 59,063 total)