Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,166 through 42,180 (of 59,102 total)

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
RE: Hourly Group By

Jim McLeod (8/30/2009)
Jeff Moden (8/30/2009)
Heh... what are you folks going to do if there's more than one day in the query? 😉
See if management will change their requirements? 😉 ...
--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 8:27 pm

#1046699
RE: Hourly Group By

Heh... what are you folks going to do if there's more than one day in the query? 😉
--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 6:46 pm

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

Converting NULLs to 'N/A' is one of those formatting things for display purposes and it shouldn't be done in the database... it should be done in the GUI or reporting...
--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 6:02 pm

#1046685
RE: Removing Carriage Returns

Heh... have you or Manu actually tried it on the TEXT datatype to see if it works?
--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 4:37 pm

#1046680
RE: What Data Should You Protect?

Steve Jones - Editor (8/30/2009)
Easy to say all of it, but sometimes you need to make choices, especially with encryption. Doing the whole database can have a detrimental effect on...
--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 4:29 pm

#1046678
RE: When Exactly need to do Index Defragment??

gmamata7 (8/30/2009)
thanks,
Can I have the script to know the fragmentation level for all the indexes in a database.Because
1. I want to make a note of Fragmentation level for all 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 30, 2009 at 1:51 pm

#1046665
RE: Oracle to TSQL - query question

Try a right join. If I remember correctly, (+) in Oracle is on the opposite column that you would expect.
--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 1:47 pm

#1046664
RE: restoring only one column

PaulB (8/29/2009)
Rule #33: Never ever run neither DML nor DDL against production without having successfully tested it before.
Shoot... that's rule #1 for me.
--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 1:44 pm

#1046662
RE: Trouble moving 650 million records from one table to another

Export in native format using BCP and then import 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)

August 30, 2009 at 1:42 pm

#1046660
RE: What Data Should You Protect?

Heh... and now that I've read the article, I'll say again... "All of 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)

August 30, 2009 at 1:40 pm

#1046658

Viewing 15 posts - 42,166 through 42,180 (of 59,102 total)