Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,421 through 36,435 (of 59,067 total)

RE: TSQL Help

vilonel (10/7/2010)
Thanks Parthi - much appreciated
Here's what Dave is trying to get at... Compare the following set based code to the While Loop...
--===== Create and populate a test table...
--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)

October 7, 2010 at 10:14 pm

#1234021
RE: Duplicates values

Ummm... fix the code so it doesn't make duplicates because of many-to-many relationships???
--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)

October 7, 2010 at 9:56 pm

#1234014
RE: inserting into temproray table

Hey Lowell... congrats on the 5K mark. You're one of those that works for every single post and your 5K mark is like a 10K mark for others on...
--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)

October 7, 2010 at 9:54 pm

#1234013
RE: Reports for across last 4 weeks,3 weeks,2 weeks

naresh0407 93367 (10/7/2010)
Just give stored procedure structure on how to do that.
Fair warning and a bit of friendly advise... people are going to take strong exception to a written attitude...
--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)

October 7, 2010 at 5:16 pm

#1233990
RE: Create a table from Column Data in another Table

Cleech (10/7/2010)
Thanks. This works, but I'm still unsure how to use this to create the new table.
Here's an example without the COALESCE...
SELECT *
INTO dbo.NewTable
...
--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)

October 7, 2010 at 5:03 pm

#1233987
RE: Need advice on SQL Server Performance

Little Nick (10/6/2010)
Hi,
My current system as follow
1. Windows 2003 Server Enterprise Edition 32 bit
2. SQL Server 2005 Enterprise Edition 32 bit
3. Strengthen by RAID 5
4. SQL Server now hosting 5...
--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)

October 7, 2010 at 4:58 pm

#1233986
RE: I have never tried this before.

I may be in a minority here. To me, SSIS is a four letter word. 😉
--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)

October 7, 2010 at 4:39 pm

#1233983
RE: Finding Sequences (Need help ASAP)

So... without me running all the code presented so far, what has been decided? Does the numbering restart for each prefix or not?
--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)

October 7, 2010 at 7:39 am

#1233557
RE: Trim field. Remove everything past a certain character

p.stevens76 (10/7/2010)
Hi I have the following field in a refernece table ...
ARMPMAEWC : ARMPM
I have the following field in another table which i need to link to using the 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)

October 7, 2010 at 7:30 am

#1233546
RE: Trim field. Remove everything past a certain character

Leju Geevarghese (10/7/2010)
Use the combination of charindex and substring function to get the results you want and then perform the linking
http://msdn.microsoft.com/en-us/library/ms186323.aspx
http://msdn.microsoft.com/en-us/library/ms187748.aspx
Uh-huh... got some code that might show how to pull...
--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)

October 7, 2010 at 7:22 am

#1233536
RE: similar like Oracle RAC

saurabh.deshpande (10/7/2010)
Can we have anything like Oracle RAC available in SQL Server.
Thanks
What is "Oracle RAC"?
--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)

October 7, 2010 at 7:19 am

#1233534
RE: One Million Posts

Hey Steve Jones,
Thanks for being here and for all the things you do! A million posts could not have happened without 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)

October 7, 2010 at 7:15 am

#1233529
RE: One Million Posts

Scott Arendt (10/7/2010)
GPO (10/7/2010)
What's the point of ten posts a day that say nothing more than "Nice post Jeff", or "Good one Gail" or whatever?
I often say that to myself...
--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)

October 7, 2010 at 7:09 am

#1233518
RE: Convert CSV values in three columns to rows

Ok... here's what I got (using Pavel's code) on my 2005 box which only has 1 CPU (P4 @1.8GHz), 1GB Ram, and an 8 year old hard drive. Notice...
--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)

October 7, 2010 at 6:36 am

#1233465
RE: Convert CSV values in three columns to rows

Zounds... not sure what just changed but I used your script exactly and I'm coming up on 10 minutes on my 2k Box. I've got the Actual Execution Plan...
--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)

October 7, 2010 at 5:41 am

#1233423

Viewing 15 posts - 36,421 through 36,435 (of 59,067 total)