Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,666 through 40,680 (of 59,070 total)

RE: Convert String to a Table using CTE

Adam Haines (12/14/2009)
Jeff Moden (12/14/2009)
Aaron Gonzalez-394690 (12/14/2009)
I second Roland's comment.
I was involved in a similar situation before and since we were working with sql server 2005 I had the developer...
--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)

December 14, 2009 at 11:45 am

#1092128
RE: Convert String to a Table using CTE

Roland Howard Boorman (12/14/2009)
I simply use XML.
Using XML whole complex structures can be passed to SQL and treated as Tables.
You can use Functions with the XML to render these...
--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)

December 14, 2009 at 11:20 am

#1092116
RE: Convert String to a Table using CTE

Aaron Gonzalez-394690 (12/14/2009)
I second Roland's comment.
I was involved in a similar situation before and since we were working with sql server 2005 I had the developer pass a xml value...
--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)

December 14, 2009 at 11:18 am

#1092115
RE: Convert String to a Table using CTE

Pratap Prabhu (12/14/2009)
As mentioned its for parsing Parameters passed in to a stored proc. In a real world scenerio an app would let a user select multiple items in 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)

December 14, 2009 at 11:15 am

#1092112
RE: Convert String to a Table using CTE

Traversing hierarchies is about the only one I can think of although there are methods that will blow the doors off that, as well.
Also, since we're dropping names and articles,...
--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)

December 14, 2009 at 11:11 am

#1092110
RE: Convert String to a Table using CTE

Pratap Prabhu (12/14/2009)
I however do feel a few minor tweaks are needed ...
The best minor tweek you could make to the code is to write it so it doesn't 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)

December 14, 2009 at 10:03 am

#1092071
RE: Convert String to a Table using CTE

I have some great bit of difficulty in believing that people are still using While Loops and the "Hidden RBAR" method of recursive CTE's for such a thing.
--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)

December 14, 2009 at 8:06 am

#1091962
RE: Are the posted questions getting worse?

Matt Miller (#4) (12/13/2009)
Jeff Moden (12/12/2009)
Steve Jones - Editor (12/12/2009)
And here I think Barry would like this car
Man, I used to love "Spanky and his gang".
Oh - were you madly...
--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)

December 13, 2009 at 5:51 pm

#1091729
RE: Evaluating the Domain of a Binary Value

You bet, Wayne.
As a side bar... now you know why I don't care to store flags as bits. A single bit flag in a row still takes a whole...
--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)

December 13, 2009 at 5:42 pm

#1091727
RE: File Exists using network path

Steve is correct. It's not what you're logged in as... it's what the server is logged in as. Do you know how to find which login SQL Server...
--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)

December 13, 2009 at 5:38 pm

#1091726
RE: Temp DB Transaction log

naveenreddy.84 (12/13/2009)
Thanks for your suggestion. Even i had the same concern about shrinking of the files. If possible, can you let us know in which scenario the log file 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)

December 13, 2009 at 5:30 pm

#1091725
RE: Query

No way to explain it better than that, Steve.
--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)

December 13, 2009 at 5:26 pm

#1091724
RE: spliting the data using replace function

anitha.cherukuri (12/13/2009)
Hi Jeff
I solved my problem by using temp table concept.
sorry for giving trouble....
Sorry... didn't see this before I posted my last message. Two way street here, Anitha... 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)

December 13, 2009 at 5:23 pm

#1091722
RE: spliting the data using replace function

anitha.cherukuri (12/13/2009)
Hi Jeff
I am very new to functions concept ,and i can not create table to hold the results.
I wrote the function,but getting errors...
Writing a function for this will just...
--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)

December 13, 2009 at 5:22 pm

#1091721
RE: spliting the data using replace function

sav-457805 (12/11/2009)
This is brilliant Jeff. Very Well explained. One for my Useful SQL script collection.
Thank you, Sav... the feedback is always appreciated. Glad I could help.
--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)

December 13, 2009 at 5:19 pm

#1091720

Viewing 15 posts - 40,666 through 40,680 (of 59,070 total)