Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,831 through 49,845 (of 59,091 total)

RE: PROBLEM in Splitting Comma Seperate Values(CSV) in Sql Server 2005

Please read the following article on Tally tables... there's also a script that demonstrates how to split a whole table's worth of CSV's, just like you have, without even coming...
--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)

June 21, 2008 at 12:25 am

#832171
RE: numeric to uniqueidentifier

No, I don't believe such a script exists... you'll need to write one. And, yeah, it's going to take a bit of time.
--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)

June 21, 2008 at 12:23 am

#832170
RE: Rules, Defaults and the SQL Standard

If I could find out how, I would in an instant. Anyone have a clue on how to get on that committee?
--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)

June 20, 2008 at 11:58 pm

#832168
RE: Best file compression software?

Ummmm.... how far away is your warm server?
--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)

June 20, 2008 at 11:21 pm

#832166
RE: DateTime calculation

Mark Beringer (6/20/2008)
Sounds like you need to write a query that groups by user and selects MAX date and also joins to a cost table. Which table are the costs...
--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)

June 20, 2008 at 11:18 pm

#832165
RE: DateTime calculation

Ok... since you're new, I'd like you to take a peek at the article in the Link in my signature... it'll help you get better answers quicker in the future....
--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)

June 20, 2008 at 11:09 pm

#832164
RE: Rules, Defaults and the SQL Standard

I would really, really like to get my hands on the SQL Standards committee... they all need to be taken out for a porkchop dinner, Jeff Moden style... 😀
--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)

June 20, 2008 at 10:32 pm

#832160
RE: Get TempTable name

Mobasha,
I'm pretty sure what you ask cannot be done. You would have to capture the session name at the time of creation of the global temp table or something...
--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)

June 20, 2008 at 10:16 pm

#832158
RE: How to ignore the comma seperator inside ","

If it's BCP or Bulk Insert or maybe even the Bulk Insert task of SSIS, you may need a format file 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)

June 20, 2008 at 10:11 pm

#832157
RE: Table var maximum row number

Table variables are NOT memory only. Of course, don't take my (or anyone elses) word for it... read the following article about how similar Table Variables and Temp 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)

June 20, 2008 at 10:08 pm

#832156
RE: Delete Rows from Table

mlimp (6/20/2008)
Hi,
This is an easy one.
How do delete rows from a table?
I want to delete all the rows from the last month of a table so i have to be...
--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)

June 20, 2008 at 10:00 pm

#832154
RE: What's the difference. . .

And, apparently, another myth dies...
The old myth was that COUNT(*) and SELECT * performed better than anything else because it would look for the best index to use. Using...
--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)

June 20, 2008 at 9:51 pm

#832153
RE: use a sequence of column values in a query

JRJ (6/20/2008)
Thanks for your reply, sorry about the wrong naming.
Regarding my second query, I am deeling with constantly changing existing data as well as new data; if I don't delete,...
--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)

June 20, 2008 at 6:22 pm

#832143
RE: SYNTAX ERROR - please assist...

Sorry Steve... you got there before I did... must've been just a couple of seconds because we both posted at the same time. 🙂
--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)

June 20, 2008 at 6:07 pm

#832141
RE: consolidating multiple rows to single row in a view

Very cool... thanks for the feedback.
--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)

June 20, 2008 at 5:54 pm

#832136

Viewing 15 posts - 49,831 through 49,845 (of 59,091 total)