Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,121 through 42,135 (of 59,067 total)

RE: To display a column value for every row if its repeated in report builder.

Neha,
That's a whole lot different than what I thought you were asking. It's also simpler to resolve... a simple inner join between the two tables should do the trick....
--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)

August 31, 2009 at 10:47 am

#1046980
RE: WORD UP!

crookj (8/27/2009)
http://support.microsoft.com/kb/884202
Jeff - See if this link helps.
Good luck!
Joe
Thanks, Joe... It's not the same problem that I'm having but these things are sometimes related. so I'll check it out. ...
--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)

August 31, 2009 at 10:42 am

#1046977
RE: A True SQL OS

IceDread (8/30/2009)
Jeff Moden (8/30/2009)
IceDread (8/30/2009)
It is as said an interesting idea but I dont see the value of it because sql server is still very lacking.
Can you give some specific...
--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)

August 31, 2009 at 10:35 am

#1046975
RE: Are the posted questions getting worse?

Lynn Pettis (8/31/2009)
Well, well, well, the White House Window Washer is back and still doesn't know how to give us everything we need to help him and he posts something...
--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)

August 31, 2009 at 10:31 am

#1046971
RE: Error converting data type varchar to float.

Pakki (8/30/2009)
Thanks all for all your help. Temporarily managed to push the data into the database using your suggestions. Its nice to know that you all explain 'whats really happening'...
--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)

August 31, 2009 at 10:27 am

#1046966
RE: Error converting data type varchar to float.

Bob Hovious (8/31/2009)
Jeff, I decided if I kept on changing nicknames in addition to avatars I might give Steve a stroke. So out of consideration for his enlightened...
--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)

August 31, 2009 at 10:26 am

#1046964
RE: Twenty tips to write a good stored procedure

arup_kc (8/24/2009)
Unfortunately, in this case, you only substitted one form of RBAR for another form of RBAR. The best solution in this case is to find a set-based solution...
--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)

August 31, 2009 at 10:22 am

#1046958
RE: Storing IPv4 Addresses for Performance

Ah... sorry. My mistake, Elliott. Thank you for the feedback. 🙂
And, to your good point and if I remember correctly, all of the calculated columns constructed from 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)

August 31, 2009 at 10:15 am

#1046951
RE: Hourly Group By

BWAA-HAAA!!! I had to laugh, Jim. I've violated #1 and #2 in the past which is the only reason why I caught it. 😉 Well 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)

August 30, 2009 at 11:39 pm

#1046727
RE: Administering SQL 2000, 2005, 2008

SQL Server 2008 (I believe...)
--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)

August 30, 2009 at 11:34 pm

#1046726
RE: To display a column value for every row if its repeated in report builder.

It's actually pretty easy to do... but in T-SQL and you need something to guarantee the order. If you have something to guarantee the order, I can show you...
--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)

August 30, 2009 at 11:24 pm

#1046723
RE: Error converting data type varchar to float.

Heh... glad to see you back in sorts, Bob... although I was getting used to calling you "the Dot formally known as Bob". 😛
--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)

August 30, 2009 at 10:46 pm

#1046717
RE: Hourly Group By

Jim McLeod (8/30/2009)
Whoops, I mistakenly thought that spt_values was accurate up to 32K instead of 2048. I should have double-checked that one. The error will manifest as 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)

August 30, 2009 at 10:36 pm

#1046715
RE: Hourly Group By

setlan1983 ,
First, you owe me an explanation. You wrote that you want it done in a single query... would you mind telling me why? There's a reason I...
--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)

August 30, 2009 at 10:33 pm

#1046714
RE: Hourly Group By

There's just one problem in all of that... try the following code and see the potential error... especially in SQL Server 2000.
SELECT DISTINCT Number
FROM master..spt_values WHERE Number >= 0...
--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)

August 30, 2009 at 9:55 pm

#1046711

Viewing 15 posts - 42,121 through 42,135 (of 59,067 total)