Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,036 through 43,050 (of 59,063 total)

RE: pass values from table to a stored procedure

hi_abhay78 (7/7/2009)
add another column as flag (values 0 or 1) in the main table .
-> Create a cursor that inserts the values from you main table to the 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)

July 8, 2009 at 6:39 pm

#1022072
RE: Create Group of Views with Columns in Upper Case

Garfi61416 (7/7/2009)
I have a client who has database tables with columns in lower case. I need them in upper case, and I can't ask them to change 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)

July 8, 2009 at 6:35 pm

#1022068
RE: Help With a Cursor Please

Drew,
I am actually in the process of writing a book on the subject and thought I'd ask... why did you think you needed a cursor for this problem? I'm...
--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)

July 8, 2009 at 6:29 pm

#1022066
RE: 12 months period by paramter date

Lynn,
If someone runs this against something that also has a time element in the date, won't there be a problem because of the BETWEEN?
--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)

July 8, 2009 at 6:25 pm

#1022065
RE: Naming Conventions Standards

GSquared (7/8/2009)
Like I said, pick a standard and stick to it. In this case, that matters more than what the specifics of the standard are. The advantages/disadvantages 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)

July 8, 2009 at 2:46 pm

#1021933
RE: Naming Conventions Standards

roelofsleroux (7/8/2009)
- Most find it more readable and different object stand out from queries.
I'm sure you can produce a white paper on the multitude of opinion polls that substantiates...
--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)

July 8, 2009 at 2:42 pm

#1021932
RE: Saving Query results as CSV file in SQL Server 2005

mckinnj1 (7/7/2009)
I am trying to use a bcp in 2005 and the file is continually going out as Unicode when I am trying to define it (or at least 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)

July 8, 2009 at 2:34 pm

#1021923
RE: write to text file using sql

ali.m.habib (7/8/2009)
Jeff Moden (7/7/2009)
I've never experienced BCP being slow at anything. Usually, it's the associated query that's slow. Please post both the BCP command and the query being...
--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)

July 8, 2009 at 6:31 am

#1021604
RE: write to text file using sql

Eswin (7/8/2009)
SET @bcpCommand = 'bcp " select '''+ @expFile +'''" queryout "'
SET @bcpCommand = @bcpCommand + @exptionFile + '" -T -c'
EXEC master..xp_cmdshell @bcpCommand
i don't think you can use '+'...
--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)

July 8, 2009 at 6:29 am

#1021603
RE: please help! Cursor or loop?

WayneS (7/7/2009)
Lamprey13 (7/7/2009)
This will probably work, but you cannot guarantee that it'll work based on the PK order.
Thanks for pointing that out... I've edited the post to include the necessary...
--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)

July 8, 2009 at 6:07 am

#1021586
RE: OpenRowset Error

Heh... do you expect it to guess what to do with your stored proc? You need it to be a valid query.
Also, (local) doesn't seem to work 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)

July 7, 2009 at 9:04 pm

#1021446
RE: Find the substring in string

rpyerneni (7/7/2009)
Wayne,
I worked on your code. As I told you I have so many links in the content. I splitted the content and inserted the splitted data into a temporary...
--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)

July 7, 2009 at 8:54 pm

#1021442
RE: write to text file using sql

I've never experienced BCP being slow at anything. Usually, it's the associated query that's slow. Please post both the BCP command and the query being executed by BCP.
--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)

July 7, 2009 at 8:49 pm

#1021439
RE: Concurrency, Insert Into A Table To Capture A Range Of Numbers

Paul White (7/7/2009)
As far as the IF @@ERROR is concerned, I just prefer TRY...CATCH, especially in demo code. (Some idiot will come along one day and insert a SET...
--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)

July 7, 2009 at 8:42 pm

#1021436
RE: Music for DBAs

Alvin Ramard (7/7/2009)
I don't think anyone mentioned:
50 Ways to Leave Your Cursor (Paul Simon)
Here's another one where a name change isn't actually required to still be appropriate...
The good, the bad,...
--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)

July 7, 2009 at 8:31 pm

#1021431

Viewing 15 posts - 43,036 through 43,050 (of 59,063 total)