Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,931 through 42,945 (of 59,102 total)

RE: converting column into rows

Read this to solve the problem of an unknown number of columns.
http://www.sqlservercentral.com/articles/cross+tab/65048/
What I'd like to know is why do you need to denormalize data in such a fashion? Spreadsheet?
--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 9:54 pm

#1026713
RE: Increasing the values in a column

kramaswamy (7/10/2009)
If that's the case, then the approach of updating one record at a time is probably the better one, despite looking ugly.
Ummm... no... not if it's done correctly. ...
--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 9:50 pm

#1026710
RE: Collecting a number of text fields together using group by

Uh huh... the real question would be, "Why does this type of denormalization need to be done?" 😉
--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 9:39 pm

#1026708
RE: convert varchar to timestamp

Heh... seriously...
--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 9:36 pm

#1026707
RE: convert varchar to timestamp

mysticslayer (7/13/2009)
Well, because SSIS sees it as a varchar.
But I found a solution for me as well for SQL2k0, SQL2k5 and SQL2k8.
So this topic can be closed 🙂
Two way street...
--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 9:33 pm

#1026706
RE: Select a column dynamically

T4FF (7/13/2009)
...the platform we are bringing in has some weird and wonderful quirks about it and this is just one, so I am attempting to make a simpler view 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)

July 19, 2009 at 9:30 pm

#1026705
RE: Not in and Not exists

It for the same reason you cannot say ...
SELECT CASE WHEN NULL = NULL THEN 1 ELSE 0 END
... and ever expect to get a "1" unless you mess 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)

July 19, 2009 at 9:26 pm

#1026704
RE: Determine Traffic Light Status with Sql

za34571 ,
You all set or what? 😉
--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 9:22 pm

#1026703
RE: Text Parsing Problem

Uh huh... and what do you do with names like the following?
Mrs. Betty Joe Lynne Van de Horn MD
--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 9:21 pm

#1026702
RE: split batch to get time

Karthik,
There is nothing in that data nor in the table to establish the order of the rows. You know you cannot rely on such a thing as the "natural...
--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 9:11 pm

#1026697
RE: split field into numbers and join to table

So, Jamie... now you have 3 tables to maintain instead of just 2. The real problem is this table...
MakeID Make CategoryIDs
1 Dell 1,2,3
2 Sony 1,2
It's not normalized. Tables...
--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 9:03 pm

#1026692
RE: Tsql query help

srathna77 (7/17/2009)
Can you please let me know how to do in batch process.
Did any of that work for 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 19, 2009 at 9:00 pm

#1026689
RE: Rewriting a complex function as Inline

J-F,
Did you ever figure out how 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 8:52 pm

#1026688
RE: How to add values into a variable?

lopes80andre (7/16/2009)
Lowell (7/16/2009)
it should work with some minor tweaks:
after you've done the DECLARE @acumul_error varchar(100) or whatever it is, you need to initialize it as an empty string:
SET @acumul_error...
--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 8:44 pm

#1026687
RE: query running now for over 3 hours

kevinwinters (7/14/2009)
yes, that is the exact query.
*every* row of that field is null, I am trying to make every row of that field blank so I can concatenate the field...
--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 8:39 pm

#1026686

Viewing 15 posts - 42,931 through 42,945 (of 59,102 total)