Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,451 through 36,465 (of 59,102 total)

RE: Differences

{edit} Removed my comment. People may have taken it the wrong way.
--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 8, 2010 at 2:37 am

#1234068
RE: Differences

{edit} Removed my comment. People may have taken it the wrong way.
--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:55 pm

#1234027
RE: Any Idea How to Parse a file Like This

ramses2nd (10/7/2010)
I am getting a single file with the following contents and I need to parse it into different tables. Each table is defined a the line which contains...
--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:40 pm

#1234025
RE: Any Idea How to Parse a file Like This

Raunak Jhawar (10/7/2010)
The table names are repeating(Domain Name etc. as you scroll down the file) as per the descrption provided.
And?
--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:36 pm

#1234023
RE: Locking a row

Gianluca Sartori (10/7/2010)
It could be something like this:
CREATE PROCEDURE [getSequence]
AS
BEGIN
SET NOCOUNT ON
DECLARE @newVal int
BEGIN TRY
BEGIN TRAN
UPDATE SequenceTable
SET @newVal = Sequence = Sequence + 1
COMMIT
END TRY
BEGIN CATCH
DECLARE @ErrorMessage NVARCHAR(4000);
DECLARE @ErrorSeverity INT;
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)

October 7, 2010 at 10:30 pm

#1234022
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

Viewing 15 posts - 36,451 through 36,465 (of 59,102 total)