Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,386 through 41,400 (of 59,067 total)

RE: Summing differences between time stamps

I've seen this exact same problem a couple of times over the years... and it was homework for a course. Please show what you've tried and if you still...
--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 22, 2009 at 11:35 pm

#1069797
RE: help on query

Ashok Nalam (10/22/2009)
So it has basically start from ( based on configuration by customer specific) to end time then start time onwards.
It depends... where is the "configuration by customer specific"...
--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 22, 2009 at 11:26 pm

#1069795
RE: BCP Command with Parameters

You can't use BCP with parameters unless you turn it into dynamic SQL.
--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 22, 2009 at 11:22 pm

#1069792
RE: split a long string column into separate columns

Thanks for the kudo, Lowell.
--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 22, 2009 at 11:09 pm

#1069788
RE: Script all data of a table

I missed this before, Flo... it's written well enough that it probably should have been an article. Well 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)

October 22, 2009 at 10:48 pm

#1069785
RE: Using synonyms to redirect queries

Heh... "It Depends".
It all depends on how you load the data (ie: IDENTITY_INSERT) and whether or not an IDENTITY column is even needed. I don't see an IDENTITY column...
--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 22, 2009 at 10:43 pm

#1069783
RE: query for random data but grouped

Sorry... I just haven't gotten to this one, yet. Do you still need help on it?
--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 22, 2009 at 10:18 pm

#1069777
RE: Are the posted questions getting worse?

Steve Jones - Editor (10/22/2009)
Actually, I think in OODBMS or HDBMS, we'd get worse design. Harder to understand. My point is that RDBMS is the easiest (relative) of the 3....
--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 22, 2009 at 10:16 pm

#1069776
RE: TSQL Question about getting data

All right, Brad... I looked at all of this and, although I return what you wanted, I got carried away. If it were me and I saw some 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)

October 22, 2009 at 10:05 pm

#1069774
RE: TSQL Question about getting data

Steve Jones - Editor (10/16/2009)
You wouldn't use a variable, and you wouldn't go through each row.
If I understand, what you likely want to do is use a CASE statement for...
--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 22, 2009 at 9:57 pm

#1069772
RE: Scalability and performance?

The only thing that remains if for you guys to tell us a fool proof way to find a good local tuner. 😉
--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 22, 2009 at 7:27 pm

#1069731
RE: .fmt and Bulk Insert importing Bad Data

Also, the book is right... change everything in the format file to SQLSCHAR and ad more column width... anything that's an INT should be set to at least 10, 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 22, 2009 at 7:24 pm

#1069728
RE: .fmt and Bulk Insert importing Bad Data

I'd recommend that you take another look at Books Online for how to skip columns. You can't just skip them by leaving them out no matter where they are...
--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 22, 2009 at 7:22 pm

#1069727
RE: Concatenating Rows

I see it's your first post on SSC... Welcome aboard!
Again, as with many of the other posts, that does the whole table. If that's what you want, then you're...
--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 22, 2009 at 7:13 pm

#1069724
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Thanks, David. Coming from someone with your background, that's a great compliment.
--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 22, 2009 at 6:56 pm

#1069720

Viewing 15 posts - 41,386 through 41,400 (of 59,067 total)