Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,526 through 45,540 (of 59,101 total)

RE: Risk and Assumptions

I actually believe it was just the opposite... I think it was severe over confidence... why else would the prices on houses have gone so high? Gas prices more...
--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)

January 27, 2009 at 6:15 pm

#933574
RE: Trying to convert number range (1-5) to numerical progression (1,2,3,4,5)

I don't know which would be preferred, which is why I didn't dupe check them into oblivion.
--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)

January 27, 2009 at 6:08 pm

#933572
RE: How can you supress the dash line in the output

Steve Berry (1/27/2009)
The output is created by a series of select statements, as sample is shown bellow:
--Output Report Master Header
set @output = 'Weekly Stock Report - Year '+ @yearcode +...
--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)

January 27, 2009 at 5:58 pm

#933568
RE: Inner and Outer Loop to add count to existing table data

Thanks for the info... just trying to understand so we can do this in as high a performance method as possible...
In your original post on this thread, you have (obviously)...
--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)

January 27, 2009 at 6:33 am

#933134
RE: Hidden RBAR: Triangular Joins

Thanks David... the article was first published over a year ago. Seems like some different folks jumped in this time and dang near doubled the length of the comments....
--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)

January 27, 2009 at 6:24 am

#933129
RE: Passing number of rows to be returned as a SP parameter

Can't tell... not enough information. You need to prove to yourself that you're passing something besides a null or a negative number for pages, pages, and rows per page....
--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)

January 27, 2009 at 6:20 am

#933128
RE: How can you supress the dash line in the output

Steve Berry (1/27/2009)
Its part of a scheduled job, that runs overnight and outputs to a text file...which then gets picked up by another package and sent out to remote locations...
--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)

January 27, 2009 at 6:16 am

#933125
RE: Converting rows into columns

The other thing is that SQL is not SQL between vendors... you're looking for a DB2 solution which could be quite different than the SQL Server solutions you'll get. ...
--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)

January 26, 2009 at 7:48 pm

#932963
RE: SQL Query help

Grant Fritchey (1/26/2009)
Two possible answers, both will work:
TOP
ROW_NUMBER
Simple MAX would do 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)

January 26, 2009 at 7:47 pm

#932962
RE: Best performance Row by row loop (SQL2K)

CHAR(0) is the NULL character... remember what happens with nulls... same thing here.
--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)

January 26, 2009 at 7:42 pm

#932961
RE: How to Insert multiple rows if quantity is more than 1

ah.nasr (1/26/2009)
set @count = 0
select quantity from .....
while @count < quantity
begin
set @count = @count + 1
insert .......
end
Heh... try THAT on a million invoices...
Lowell has it right with the Tally...
--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)

January 26, 2009 at 7:38 pm

#932960
RE: Calling VBScript or command file from within T-SQL without xp_cmdshell??

Helmut, since your relatively a "newbie", I'll be nice... there's really no quicker way to tick off the alumni on this forum than "duplicate posting". Just pick the correct...
--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)

January 26, 2009 at 7:32 pm

#932958
RE: SMO vs SQL-DMO

kasper (11/16/2006)
Hi,
Did anybody compare the performance of scripting operations with SQL-DMO vs SMO? What other reasons should be considered, to choose between two solutions?
Thanks.
Heh... now wait just a cotton-pickin'-minute ;)......
--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)

January 26, 2009 at 7:25 pm

#932957
RE: Calling VBScript or command file from within T-SQL without xp_cmdshell??

If you have VB, you could convert the script to a CLR... I'm sure there's other ways, but I don't know what they are.
What I'd be more interested in finding...
--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)

January 26, 2009 at 7:21 pm

#932956
RE: How can you supress the dash line in the output

Where are you doing this at? No such dashed line appears in SMS in the Text Mode.
--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)

January 26, 2009 at 7:18 pm

#932954

Viewing 15 posts - 45,526 through 45,540 (of 59,101 total)