Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,901 through 30,915 (of 59,101 total)

RE: How to display months across like crosstab?

abhilasht (3/4/2012)
Yes PIVOT is the best
Actually, it's not. See the article at the following link for why not. Pay particular attention to the performance chart at the end...
--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)

March 4, 2012 at 7:36 am

#1454557
RE: Problem to write Special Function

Golden_Behzad (3/3/2012)
i know identity column is very good but my database is more than 250 table and relation between table is set.
for change pk and fk datatype is very heavy...
--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)

March 4, 2012 at 12:00 am

#1454521
RE: How to display months across like crosstab?

Heh... {FacePalm}... {Self Head Slap}... {pound head against hard spot on desk}. I've really got to learn to scroll further down in code windows. I didn't see 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)

March 3, 2012 at 11:38 pm

#1454518
RE: How to display months across like crosstab?

J Livingston SQL (3/3/2012)
R.P.Rozema (3/3/2012)
? I think I don't get it? But isn't this simply answered by no longer specifying the columns names as 'Jan', 'Feb', etc, but simply label...
--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)

March 3, 2012 at 11:33 pm

#1454517
RE: How to display months across like crosstab?

siva 20997 (3/3/2012)
The reply to the original question will be long and hard to understand once done
hence I just touched upon the subjects which is needed to be understood 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)

March 3, 2012 at 11:29 pm

#1454515
RE: How to display months across like crosstab?

J Livingston SQL (3/3/2012)
R.P.Rozema (3/3/2012)
? I think I don't get it? But isn't this simply answered by no longer specifying the columns names as 'Jan', 'Feb', etc, but simply label...
--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)

March 3, 2012 at 11:21 pm

#1454514
RE: How to display months across like crosstab?

siva 20997 (3/3/2012)
I just noticed noticed your article on cross tabs etc.
I am new to your Forum and didnt notice who is who etc
There are few additional things i...
--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)

March 3, 2012 at 11:17 pm

#1454513
RE: How to display months across like crosstab?

siva 20997 (3/3/2012)
Jeff
sorry I didnt notice that you were part of the SSC Moderators etc
Can I eMail you the answer and then you can cut and paste whatever you think...
--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)

March 3, 2012 at 11:10 pm

#1454511
RE: Problem to write Special Function

Golden_Behzad (3/3/2012)
Thank for read my problem (Jeff Moden)
i write more description for my problem
i need function that generate sequence uniqueidentifier
i write function that usefull but not 100% sequence
(data type...
--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)

March 3, 2012 at 11:06 pm

#1454510
RE: retrieving the record based on conditions

Also, please define what you mean by "oldest 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)

March 3, 2012 at 10:01 am

#1454457
RE: Looking for the inverse of xp_fixeddrives

cchitanu (4/28/2004)
Send me an email at cchitanu@csc.com
How'z'bout you just post your solution here, instead? 😉
{EDIT}... heh... 8 year old post. I'd still like to see what was going 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)

March 3, 2012 at 9:50 am

#1454455
RE: How to display months across like crosstab?

siva 20997 (3/3/2012)
You need to use the PIVOT command. It is bit tough but read up on it and it will work. I have done it
use a query which 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)

March 3, 2012 at 9:49 am

#1454454
RE: UDF Vs CTE

SQL_Surfer (3/2/2012)
Can we rewrite this UDF to CTE? I've got several thousdands of records that in the main table which passes id to the UDF below. It returns the date...
--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)

March 3, 2012 at 9:41 am

#1454453
RE: Problem to write Special Function

That would be a "sequence" function and, in SQL Server 2000, it's just about (I try to not say "NOT" or "NEVER" :-D) impossible to do because it would also...
--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)

March 3, 2012 at 9:28 am

#1454451
RE: How to display months across like crosstab?

Shree-903371 (3/2/2012)
The problem is we are not allowed to use open queries in out campany.
What do you mean by "open queries"??? Do you mean "dynamic SQL"? If so, then...
--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)

March 2, 2012 at 2:48 pm

#1454384

Viewing 15 posts - 30,901 through 30,915 (of 59,101 total)