Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,681 through 46,695 (of 59,095 total)

RE: Need to copy data from table to table with update statement

Nope... no style wars... I'm just tired of people blaming it on the ability to comment out rows easier. The difference between the two styles only affects the ease...
--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)

December 11, 2008 at 5:30 am

#910975
RE: Updating a Column Using a Recursive Definition

Heh... that bit of info should be as a comment in the code. 😉
Anyway, works good.
--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)

December 11, 2008 at 5:19 am

#910970
RE: Generating automatic sequential alphanumeric key

I also don't see anything that would prevent "overruns"... what happens if you use 1001 of any given sequence? Either BOOM or duplication.
--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)

December 11, 2008 at 5:15 am

#910968
RE: Generating automatic sequential alphanumeric key

Be very careful... There is nothing there that will keep 2 or more simultaneous calls to the same code from returning the same number.
--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)

December 11, 2008 at 5:02 am

#910964
RE: display Full date values which falls under 2 input date values

Sure, but as others have already stated, a table source for this is the best way to go. The following code will solve the problem without a table, though....
--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)

December 10, 2008 at 9:42 pm

#910817
RE: Columns (header) and setting something off

Post the OSQL command, please.
--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)

December 10, 2008 at 9:24 pm

#910810
RE: Table Design Question...

EAV won't be a slow as you think. It'll process about 12 million rows in about 7 seconds.
--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)

December 10, 2008 at 9:05 pm

#910798
RE: How to use case in where clause

halifaxdal (12/10/2008)
Hi guys,
Here is my task:
I have couple records marked as integrity = 1 or 2 or 3 or 4
I need to write a query to pull out all...
--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)

December 10, 2008 at 8:58 pm

#910797
RE: Selecting number values from a string column up to first non-numeric chars

Heh... I hate it when impatient people pull this crap... this is a double post... please, no more answers on this thread... go to the following, instead...
http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=gjq2tn3letp4qj554vsxeizy
--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)

December 10, 2008 at 8:55 pm

#910796
RE: Selecting numbers up to the first non-numeric char from a string

mmiruru (12/10/2008)
This function worked perfectly for what I needed to do. Thank you very much for your help.
First, it's not nice to double post.
Second, the function may work perfectly 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)

December 10, 2008 at 8:51 pm

#910795
RE: Can you guide me ....

Heh... to heck with all that... start answering posts on this forum with code! 😉
--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)

December 10, 2008 at 8:44 pm

#910794
RE: Updating a Column Using a Recursive Definition

Nicely done, Peter.
--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)

December 10, 2008 at 8:40 pm

#910793
RE: Selecting number values from a string column up to first non-numeric chars

I don't know how you'd do it in SSIS, but here's the T-SQL solution...
--===== Create a place to hold test data and populate it.
-- Note...
--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)

December 10, 2008 at 8:38 pm

#910792
RE: Urgent: Need help with Query on Group By Part

Zeev Kazhdan (12/10/2008)
Instead of group by, you might think of OVER (PARTITION BY...)
Why?
--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)

December 10, 2008 at 8:24 pm

#910790
RE: Concatenate issue with datetime

... and let me know if you still need a variable for the date...
And, never use INT for such a conversion because it rounds up to the next day 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)

December 10, 2008 at 8:03 pm

#910787

Viewing 15 posts - 46,681 through 46,695 (of 59,095 total)