Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,366 through 46,380 (of 59,101 total)

RE: Are the posted questions getting worse?

BWAAA-HAAA! Excellent candidate for this year's SQL Darwin award...
http://www.sqlservercentral.com/Forums/Topic478330-8-1.aspx#BM480712
Scroll up from that post to see the hell he caused a bunch of people because he thought Sybase and 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)

December 27, 2008 at 11:12 am

#918055
RE: OLE Automation help

I believe that I'd post that exact same thing on Simple Talk and let Phil and Robyn have a crack at it... they're the ones that wrote the method 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 27, 2008 at 11:03 am

#918052
RE: Update Query Issue

Jay Sapani (12/27/2008)
I Have A Simple Update Query But It Takes A Lot Of Time,How Can I Reduce Its Time ?
I Have A Table With 10 Lakh Records.
I Want 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 27, 2008 at 10:46 am

#918050
RE: Query Help!

ganeshmuthuvelu (12/27/2008)
Can someone help me in writing this update query without cursors?
Yep... and we don't need a WHILE loop, either (it would be just as slow)...
First things first... here's the...
--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 27, 2008 at 10:28 am

#918046
RE: Query Help!

Dugi (12/27/2008)
interesting variable value ...at first when I saw your sample data it shows me the logic that max_value - min_value = allowed_value but the last record doesn't have this...
--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 27, 2008 at 9:59 am

#918040
RE: Query Help!

Nah... the logic is pretty simple if you look at it right... the 23 is not being split by Min value... it's being split by the difference between the Min...
--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 27, 2008 at 9:42 am

#918037
RE: Expressions based on data in the SELECT statement

Thanks for the feedback, Jeanangeo. Glad you got it solved.
--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 27, 2008 at 9:27 am

#918035
RE: Looking Forward

Domagoj Orec (12/27/2008)
My goals would be:
1. Close my buisness and leave this God forbidden country (Croatia)
5. Be Happy, at least for a one day in a year
Anyone that thinks...
--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 27, 2008 at 9:23 am

#918034
RE: Are the posted questions getting worse?

Grant Fritchey (12/27/2008)
Don't be too sure about that. I remember interviewing this guy once who never got an answer wrong. He could talk all day long about the databases. We...
--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 27, 2008 at 9:12 am

#918032
RE: How to transpose the ROWs

Thanks Pravin... I always appreciate the feedback.
--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 27, 2008 at 9:06 am

#918027
RE: How to calculate the Bi-weekly in SQL

Just for grins, here's the CTE version without TOP...
;WITH
cteTally AS
(
SELECT ROW_NUMBER() OVER (ORDER BY ID)-1 AS N
FROM Master.sys.SysColumns
)
SELECT DATEADD(dd,(t.n)*14,'20090102') AS BiFriday
FROM cteTally...
--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 27, 2008 at 9:02 am

#918026
RE: How to calculate the Bi-weekly in SQL

For anyone that reads this that may still be using SQL Server 2000, the system table called spt_Values that Madhivanan used has a bunch of different things in it depending...
--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 27, 2008 at 8:45 am

#918022
RE: Exercise to practise SQL

I'm still looking forward to the sky writing...
--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 26, 2008 at 6:54 pm

#917970
RE: Break Views by modifying tables

Heh... everyone gets all bent out of shape when someone uses a cursor in a place where it shouldn't be, but no one says boo when someone uses a cursor...
--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 26, 2008 at 6:41 pm

#917967
RE: OLE Automation help

Thanks for the backup Lowell... I was thinking that I need to include a graphic and a better explanation... you saved me some work. Thanks, ol' friend.
--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 26, 2008 at 5:47 pm

#917960

Viewing 15 posts - 46,366 through 46,380 (of 59,101 total)