Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,076 through 48,090 (of 59,102 total)

RE: Use a database if exist

Matt Miller (9/27/2008)
There's always TRY/CATCH, too.
Yeah, I know... but I just can't bring myself to programming by exception. I'd rather know the correct answer up front and take...
--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)

September 28, 2008 at 6:38 pm

#878221
RE: Update with multiple conditions - Help needed

You bet, Neela.
--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)

September 28, 2008 at 6:35 pm

#878220
RE: table names

I'm not sure who gave you the requirements on these file names, but the yyyymm format will serve you much better and for much longer.
--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)

September 27, 2008 at 9:20 pm

#878124
RE: Help on Dups

salvysmith08 (9/24/2008)
...if you can show me how to dynamically add column GRP on every dynamic table then that would great.
Old gaming trick... when you can't move, change color... Temp Table...
--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)

September 27, 2008 at 9:04 pm

#878123
RE: Use a database if exist

sivavardhan (9/26/2008)
Use the below script to find whether the database is there or not in a server
if exists
(select name from master..sysdatabases where name like '%abc%')
Begin
...
--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)

September 27, 2008 at 8:11 pm

#878121
RE: Use a database if exist

vyas (9/24/2008)
SET QUOTED_IDENTIFIER OFF
IF EXISTS(select * FROM master..sysdatabases where [name] ='pubs')
begin
use pubs
...
--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)

September 27, 2008 at 7:59 pm

#878120
RE: Formatting...date output

Stuff it...:P seriously... the STUFF solution that Chris Morris posted will do the trick just fine.
--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)

September 27, 2008 at 7:49 pm

#878119
RE: Issue with stored procedure...

Heh... thanks for posting your solution. Sometimes the problem just boils down to "must look eye." 🙂
--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)

September 27, 2008 at 7:47 pm

#878118
RE: RBAR update/inserts

Jack Corbett (9/25/2008)
Chris Harshman (9/25/2008)
I'm suprised that Jeff Moden hasn't jumped all over this. 😉
Based on some of Jeff's other posts, he is pretty busy with work right 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)

September 27, 2008 at 7:42 pm

#878117
RE: parsing example

marius.draganescu (9/25/2008)
That is what I was suspecting, too... I guess I will have to do this in VB, process one line at a time.
Thanks you very much for your opinion!
Marius
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)

September 27, 2008 at 7:18 pm

#878116
RE: rounding of decimals

skottikalapoodi (9/26/2008)
MY DATA TYPE IS DECIMAL ONLY.
ACTUALLY WHAT I WANT IS, I DON'T WANT IT TO BE ROUNDED
DECIMAL WHAT??? What is the actual datatype of the column...
--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)

September 27, 2008 at 7:14 pm

#878115
RE: generic stored proc/function to convert columns to concatenated rows

Heh... "Loop" and "Lose" are both 4 letter words beginning with "L". 😛 Please see the following article for how to perform concatenation and some of the pitfalls 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)

September 27, 2008 at 7:10 pm

#878114
RE: Passing a list of integers to use in Stored Procedure

By the way... the methods shown in the articles are a bit faster than the XML methods and can also be used in SQL Server 2000. 😉
--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)

September 27, 2008 at 7:05 pm

#878113
RE: Passing a list of integers to use in Stored Procedure

It's super simple to pass a single dimensional array to SQL Server as a comma delimited string and then to split it into a temp table or table variable using...
--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)

September 27, 2008 at 7:04 pm

#878112
RE: SP_Cursor

Those sprocs are the ones that SQL Server runs behind the scenes for nearly every stored proc. The real problem is not those, but the query the query that...
--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)

September 27, 2008 at 6:58 pm

#878111

Viewing 15 posts - 48,076 through 48,090 (of 59,102 total)