Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,791 through 41,805 (of 59,102 total)

RE: Row to Column Conversion

roy.neelanjana (9/27/2009)
Hi All,
I have a requirement in sql server 2005 reporting services where I need multiple selection. But my database is in Sqlserver 2000.
If the input is as follows:
declare...
--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)

September 27, 2009 at 9:05 pm

#1058898
RE: Check Yourself

Grant Fritchey (9/25/2009)
Flat out, it depends. I get something from Jeff, Gail, Lynn, the usual suspects, I will review it and test it, but I'll generally assume it's right. 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)

September 27, 2009 at 8:07 pm

#1058893
RE: Returning records with matching days of the week

I've got to ask... what do you do next week since this original table posted gives no clue as to date? I don't know if you can change from...
--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)

September 27, 2009 at 8:04 pm

#1058892
RE: MDX to generate CSV file as Output

I agree with you, but you didn't tell them how to export to a CSV. Keep in mind that T-SQL is part of the stack and the user doesn't...
--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)

September 27, 2009 at 7:48 pm

#1058890
RE: Split String and ordering

jwhisman (9/27/2009)
Wow, thank you, Jeff. I'd been trying to think how to use your Tally example, but hadn't quite wrapped my head around how to do it in 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)

September 27, 2009 at 7:40 pm

#1058889
RE: Can't Import Data Fast Enough - Optimize or rethink the design?

winterminute (9/27/2009)
Hey Jeff, as always thanks for your advice.
Sounds like I need to create a new table with the right schema and move all the existing data into it as...
--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)

September 27, 2009 at 7:36 pm

#1058888
RE: Increase data import performance

173 stored procedures? That just doesn't seem right somehow and it smacks of RBAR. How many rows do each of these stored procedures handle... one?
--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)

September 27, 2009 at 8:32 am

#1058841
RE: MDX to generate CSV file as Output

Dan English-729975 (9/26/2009)
...and then export to CSV.
I believe that's the crux of the original question... how would you do that without SSIS or SSRS, Dan?
--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)

September 27, 2009 at 8:28 am

#1058840
RE: SQL Server 2000 Related Query

What I'm concerned about is the apparent lack of detail in the requirements they gave you. I just can't imagine that they don't care about the sort order of...
--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)

September 27, 2009 at 8:01 am

#1058837
RE: how can we create a table snapshot?

I wasn't the one that set it up (our OPs guys set it up) so I don't know many of the details. The servers and the SAN were all...
--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)

September 27, 2009 at 7:39 am

#1058833
RE: Can't Import Data Fast Enough - Optimize or rethink the design?

You can certainly change the PK to an identity column and, if you can guarantee that duplicates across what is currently the PK will be keep out by process, 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)

September 27, 2009 at 7:23 am

#1058832
RE: how can we create a table snapshot?

We never experienced such a thing... not even when the source or target when down for one reason or another. Maybe we just got lucky but it ran 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)

September 26, 2009 at 5:07 pm

#1058796
RE: Are the posted questions getting worse?

Bob Hovious 24601 (9/26/2009)
Makes sense.
Hope you didn't mind my taking pity on the OP who didn't have a clue about how to do a set-based...
--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)

September 26, 2009 at 5:03 pm

#1058795
RE: how can we create a table snapshot?

The thing I don't like about any form of SQL Server replication (it's been fixed in 2k8) is when you need to alter a table which it won't let 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)

September 26, 2009 at 4:47 pm

#1058791
RE: Split String and ordering

Sorry, I'd forgotten to populate the Note_ID column in the Temp Table... I've added it to the code above.
--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)

September 26, 2009 at 4:41 pm

#1058789

Viewing 15 posts - 41,791 through 41,805 (of 59,102 total)