Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,396 through 40,410 (of 59,098 total)

RE: Want to use WHILE loop in Stored procedure

lobbymuncher (12/31/2009)
...and it's too early for beer!
NEVER! 😀
--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 31, 2009 at 9:44 pm

#1098054
RE: Query on CTEs

Lutz is spot on... calculate the answers just once and store them in a temp table.
--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 31, 2009 at 9:40 pm

#1098053
RE: Stuck on "continuous date spans"

David Lester (12/29/2009)
I am stuck on this one for a set based solution, and I think I have it almost working, something is escaping me.
I have a table 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)

December 31, 2009 at 9:39 pm

#1098052
RE: Too much data in my cell

Why won't Access take the native DateTime data type? Why are you trying to push data to Access instead of just using a "pass through" view or proc to...
--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 31, 2009 at 9:31 pm

#1098050
RE: Flagging BCP Operation

murthykalyani (12/31/2009)
Steve Jones - Editor (12/31/2009)
If you use BULK INSERT, you could check the table afterwards. I guess with bcp you could do the same. run a query and determine...
--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 31, 2009 at 9:24 pm

#1098049
RE: Casting the number of decimals in a select dynamically (For eg, amounts based on the number of decimals of the currency)

narensantanam (12/31/2009)
Hi,
As a part of our reporting stack at a bank, we expose off data to reporting tools in the form of views etc. Being a bank, most reports contain...
--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 31, 2009 at 9:22 pm

#1098048
RE: A New Beginning

Heh... I am loath to learn either SSIS or SSRS but it looks like I may have to finally bite the bullet there. I refuse to make it a...
--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 31, 2009 at 9:15 pm

#1098047
RE: Tempdb grows due to code error till no space is left

Credits to Navy beans that a many-to-many join is present forming an "accidental" cross-join... look in the estimated execution plan for some really "fat" arrows with extremely high row counts...
--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 31, 2009 at 9:01 pm

#1098046
RE: Working around ISNUMERIC

Because, as a default, VARCHAR is capable of holding an empty string while CHAR is blank padded. See ANSI_PADDING in Books Online. If you SET ANSI_PADDING OFF,...
--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 31, 2009 at 8:55 pm

#1098044
RE: Running total , missing date , NULL in amount, exception handling

karthikeyan-444867 (12/31/2009)
After including that line, it is running fine now.
Jeff,
I really learned some good things from your article. Thanks for my sql teacher.
you should continue to try to resolve...
--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 31, 2009 at 8:16 pm

#1098041
RE: Master.dbo.SysColumns

Thanks for the feedback, Corey.
--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 31, 2009 at 8:11 pm

#1098040
RE: Cummulative Totals By Dynamic Month Range

For those interested in what has been done on this thread, several "technologies" have been brought together to make this all happen. If you'd like to read about them,...
--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 31, 2009 at 8:04 pm

#1098039
RE: Cummulative Totals By Dynamic Month Range

tm3 (12/31/2009)
Very nice!!! It worked perfectly and I really appreciate the assistance Jeff.
I would have never figured this out on my own and would have probably tried manipulating the records...
--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 31, 2009 at 7:44 pm

#1098038
RE: Cummulative Totals By Dynamic Month Range

All right... here's the test table generator. It gen's a million rows for 100 accounts across 10 years. Read the comments about some of the indexing applied. ...
--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 31, 2009 at 3:10 pm

#1098022
RE: Cummulative Totals By Dynamic Month Range

Sorry... made a "performance" error and I took the code that was here down... I'll be back in a few.
--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 31, 2009 at 1:48 pm

#1098014

Viewing 15 posts - 40,396 through 40,410 (of 59,098 total)