Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,146 through 47,160 (of 59,101 total)

RE: adding single quotes to group of varchars

Magy (11/18/2008)
I am trying to simulate an array within a stored procedure by passing in a large group of values like this:
EXEC sp_EpiData 1,25,'G1000026, G1000086, G1000088, G1000090, G1000092, G1000094, G1000096,...
--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)

November 18, 2008 at 9:40 pm

#900283
RE: adding single quotes to group of varchars

bitbucket (11/18/2008)
May I sugget reading the EXCELLENT article by Jeff Moden
http://www.sqlservercentral.com/articles/TSQL/62867/
About half way through the article Jeff has an example that is very, very close to what you want...
--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)

November 18, 2008 at 9:36 pm

#900282
RE: Process blocking itself .. help !

Lots of code will have temporary blocks that make it look like it's blocking itself. But, thats NOT the reason it takes an "age" to run... the cursor has...
--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)

November 18, 2008 at 9:29 pm

#900280
RE: SQL Table Variables

My recommendation is to leave the temp tables as they are instad of converting them to table variables... Read Q3/A3 and Q4/A4 in the following to see why...
http://support.microsoft.com/default.aspx?scid=kb;en-us;305977&Product=sql2k
Yeah... 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)

November 18, 2008 at 9:22 pm

#900278
RE: Update Table based on Sum()

The question Christopher is asking is what is in the mdtrans table that is also in the TESTsalescontract table? For example, is there a ResortID column in the mdtrans...
--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)

November 18, 2008 at 9:18 pm

#900274
RE: field with multiple values

Yep... see the following
http://www.sqlservercentral.com/articles/T-SQL/63003/
--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)

November 18, 2008 at 9:10 pm

#900273
RE: Are the posted questions getting worse?

I've gotta agree with Michael... the questions have gotten a lot worse. Yeah, I agree that they're probably for the reasons Steve and a couple of others have identified,...
--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)

November 18, 2008 at 9:08 pm

#900272
RE: getting rid of 0's in the start of a varchar(6) column

Rajesh (11/18/2008)
Hi,
You should be using derived column transformation, and use substring or available string functions. This would help.
Raj
Easy enough to say... what formula would you use to return the following...
--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)

November 18, 2008 at 8:35 pm

#900270
RE: Replace all empty values with NULL

Jack Corbett (11/18/2008)
Now that you mention it I do recall, but I still think it is a foolish requirement and impediment to success. You'd be done by now if...
--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)

November 18, 2008 at 8:30 pm

#900269
RE: Displaying NULL as the last row + ORDER BY

Must look eye... let the code be the teacher...
SELECT [font="Arial Black"]CASE WHEN N IS NULL THEN 5 ELSE 4 END, N[/font]
FROM
(
SELECT N
from Tally
where N < 11
UNION ALL
SELECT NULL
) X
ORDER...
--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)

November 18, 2008 at 8:20 pm

#900267
RE: Help with Money and Decimal datatype

ALZDBA (11/18/2008)
presentation ....... should be handled by the front end application !
(and preferably client side)
Do not bother sqlserver with how you want things actually presented for the human eye.
One...
--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)

November 18, 2008 at 8:13 pm

#900265
RE: Optimizing Database Growth

No... I'm not talking about "growth" rates.... I'm talking about setting the database size correctly so it never has to grow. Database growth should never take you by surprise...
--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)

November 18, 2008 at 8:08 pm

#900263
RE: Format "1" as "01"

riga1966 (11/18/2008)
The field data type is INT.
I want to display it always as "01","02","03" format.
What is the best way to do it?
Now that you have a couple of answers, please...
--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)

November 18, 2008 at 8:04 pm

#900262
RE: Set Date Format on Flat File Source

If you set a column as a DATETIME datatype, and the data put into that column is in the YYYYMMDD format, no conversion is necessary... it'll just work because of...
--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)

November 18, 2008 at 7:56 pm

#900260
RE: My application's response time has gone down from 20 sec to 2 sec after upgrading from SQL Server 2000 to SQL Server 2005.

Heh... you guys are missing it... OP wants to know why performance IMPROVED so much after the upgrade so they can go back to the original database and make 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)

November 18, 2008 at 7:15 pm

#900252

Viewing 15 posts - 47,146 through 47,160 (of 59,101 total)