Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,806 through 50,820 (of 59,098 total)

RE: The T-SQL Quiz

Matt Miller (5/2/2008)
Grant Fritchey (5/2/2008)
How did you know what I had planned for the week-end... 😀
I have to ask though, what's drowning breath exercise? While we do incorporate a lot...
--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)

May 2, 2008 at 7:14 pm

#810385
RE: The T-SQL Quiz

DFalso, if you get hit by a bus tomorrow and your boss can't figure out your code, then you're proving exactly what I said... your code is not production quality...
--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)

May 2, 2008 at 7:07 pm

#810384
RE: Row-By-Row Processing Without Cursor

poornima.s_pdi (5/1/2008)
Hi Jeff,
Thanks a lot for ur reply.I learnt more from ur sites.very good snd useful forum...
Thank you for the feed back, Poornima... are you all set now?
--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)

May 2, 2008 at 6:54 pm

#810383
RE: Row-By-Row Processing Without Cursor

Funny, they work fine for me... they take me right to the post I wanted.
--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)

May 2, 2008 at 6:52 pm

#810382
RE: Add a temp unique ID column to a view?

ebarsamian (5/2/2008)
Thanks for the help. This is the sql that puts the stored procedure into a temp table with a unique ID:
CREATE TABLE #trustgoals
(ID int IDENTITY,
Trust varchar(100),
InitialReview varchar(100),
ReReview varchar(100),
TotalReview...
--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)

May 2, 2008 at 6:49 pm

#810381
RE: Another Crappy Cursor

By the way, MDevore, very nice formatting you did on your code. Makes for a really easy read. Nicely 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)

May 2, 2008 at 6:43 pm

#810380
RE: Another Crappy Cursor

mdevore (5/2/2008)
HOLY CRAP! :w00t::w00t::w00t::w00t: I rewrote the query based on Jeff's Running Total post, and it went from 8 hours to 6 seconds! Jeff, I bow down before you! THANKS!!!!!!!
Heh......
--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)

May 2, 2008 at 2:52 pm

#810354
RE: Add a temp unique ID column to a view?

Post what you have for the view already, please.
Strange that something should require a view to work...
--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)

May 2, 2008 at 2:44 pm

#810350
RE: Dynamic View creation is taking long time

Part of the problem is that you go back to delete the trailing comma... you basically do something like this...
DECLARE @somestring VARCHAR(8000)
SET @somestring = ''
SELECT...
--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)

May 2, 2008 at 8:09 am

#810097
RE: Working with strings

And, you need that in a file 100,000 columns wide, right? You trolling here or ??? I ask because you asked for comma delimited in the first post...
--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)

May 2, 2008 at 7:39 am

#810071
RE: Fetch Row by Row with out using cursor

shalini_pdi (5/2/2008)
Hi Jeff
I m getting error when i get the query based on some condition as i have mentioned in previous post
"I am getting the error as Violation of PRIMARY...
--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)

May 2, 2008 at 7:10 am

#810054
RE: Help grouping results in date ranges

Obviously, I don't have your data nor the query that calculates the age of the invoices, but if you use the output of that query as a derived table in...
--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)

May 2, 2008 at 7:02 am

#810050
RE: Create a Tally or Numbers Table

Heh... NO! 😛
--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)

May 1, 2008 at 9:11 pm

#809909
RE: Add a temp unique ID column to a view?

In SQL Server 2000, the absolute fastest way would be to insert the results of the query on the view into a temp table with an IDENTITY column and read...
--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)

May 1, 2008 at 9:10 pm

#809908
RE: The T-SQL Quiz

I very much appreciate the feedback... thanks.
I understand where you're coming from... been there myself... been burned by that very same thing. Now, I assume that all code, no...
--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)

May 1, 2008 at 9:00 pm

#809904

Viewing 15 posts - 50,806 through 50,820 (of 59,098 total)