Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,166 through 33,180 (of 59,099 total)

RE: Copy from a folder to an other

ALZDBA (7/22/2011)[hrOf course there is nothing wrong with yea good old DOS ..... in a sqlagent job please.
Not in the in-transaction-code !
I have to disagree there. xp_CmdShell can...
--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 22, 2011 at 6:40 am

#1357011
RE: How to use temporary table in function

RichB (7/22/2011)
I am torn between considering this genius or madness...:pinch:
Heh... I've found there's not much difference. 😀 The quality of the outcome is normally the determining factor.
--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 22, 2011 at 6:32 am

#1357003
RE: Strange error in TSQL 2005

I can't help on the original problem because there's just not enough information to go on.
However, I see that you have a Split function and most folks rendition...
--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 22, 2011 at 5:29 am

#1356954
RE: Query to display the following output

Mitesh Oswal (7/22/2011)
DECLARE @string VARCHAR(1000) SET @string = 'aaa,bbb,ccc' DECLARE @tblNumber TABLE ( ID INT ) INSERT INTO @tblNumber SELECT TOP 100 ROW_number() OVER(order by s.object_id) from sys.objects o,sys.objects s select SUBSTRING(@string,id,CHARINDEX(',',@string+',',id)-id) from @tblNumber where ID <len(@string) AND SUBSTRING(','+@string,id,1)=','
That's 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 22, 2011 at 5:18 am

#1356947
RE: Query to display the following output

Eralper (7/22/2011)
What you are asking for is split function
You can find samples on the web if you search with that term
Here is some
http://www.kodyaz.com/articles/sql-server-string-split-tsql-clr-function-sample.aspx
http://www.kodyaz.com/articles/sql-server-t-sql-split-function.aspx
http://www.kodyaz.com/articles/t-sql-convert-split-delimeted-string-as-rows-using-xml.aspx
Oh... be careful. Splitting using 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 22, 2011 at 5:15 am

#1356944
RE: Select Random Row from a table

I realize this is an old post but I have to ask... why would you feel that returning 110,000 (1% of the 11 million row table) would be a good...
--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 22, 2011 at 5:04 am

#1356938
RE: OTLT - Congnitive Dissonance or thoroughly thinking through the problem

I realize that I'm rendering an opinion probably too late, but here we go.
The app has survived the last 4 years with it the way I described. I decided before...
--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 22, 2011 at 5:00 am

#1356935
RE: Best method for moving constant flow of data into SQL

Craig Farrell (5/17/2011)
Add a step 8. Once everything is done, create a loop process that will rename all the older items to an old. schema, and swap in your new....
--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 22, 2011 at 4:43 am

#1356925
RE: Query for Recursive Data Access

Thanks for posting the feedback for the solution you found.
As a side bar, it's a real shame that you didn't post data using the method that Lutz suggested... it's likely...
--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 22, 2011 at 4:20 am

#1356912
RE: Auto generation of Identity column

Just to emphasize...
Generating additional ID's in a column using MAX will frequently lead to duplicated numbers if there's no unique constraint on the column and will lead to frequent rollbacks...
--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 22, 2011 at 4:14 am

#1356910
RE: Help Needed for SQL Query

yatish.patil (7/20/2011)
Hi ChrisM@Work,
Thank you Very much , your solution is working perfectly as it is required for me. Thank you for your help.
Regards,
Yatish
The question now is, if presented with 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 22, 2011 at 3:43 am

#1356899
RE: "Normal" tables vs local temporary (i.e. #) tables

julian.fletcher (7/21/2011)
Thanks for your replies.
We have an index on the SPID column (of course!) but not a clustered one. I was concerned that this might make the situation worse, given...
--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 22, 2011 at 3:33 am

#1356898
RE: Warning while creating a table in SQL 2005

I don't know if it'll help for sure but I seem to remember an old wive's tale that may help. If you put all of the fixed length columns...
--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 21, 2011 at 9:11 pm

#1356856
RE: Warning while creating a table in SQL 2005

I got real curious and looked it up. Out-of-row pointers are freakin' huge... they're 24 bytes. I'm thinking that's likely the problem.
--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 21, 2011 at 9:00 pm

#1356854
RE: Warning while creating a table in SQL 2005

rathod.balu (7/21/2011)
Thanks for your reply. But i am sorry, i failed to understand the point you are trying to make.
Could you please elaborate as for whr i am going worng...
--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 21, 2011 at 8:41 pm

#1356852

Viewing 15 posts - 33,166 through 33,180 (of 59,099 total)