Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,756 through 34,770 (of 59,099 total)

RE: Are the posted questions getting worse?

Kiara (3/7/2011)
But... but... it's *pretty*! I just wanted to look at it... really! We have such *boring* money over here in the States...
-Ki
BWAA-HAA!!! I will be happy to 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)

March 7, 2011 at 6:02 pm

#1295658
RE: Concatenating Rows

jim Etheridge (3/7/2011)
This works to simplify the 'for xml path ('')' option: {snip]
The rtrim/ltrim function apparently removes the unprintable xml tokens, and the substring removes the first comma. This works...
--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)

March 7, 2011 at 5:04 pm

#1295651
RE: Concatenating Rows

SQLkiwi (3/7/2011)
Jeff Moden (3/7/2011)
At the risk of quibbling, yeah... it's RBAR because it requires a scalar UDF (or equivalent) to return just one text aggregate and it handles the same...
--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)

March 7, 2011 at 5:02 pm

#1295650
RE: code help needed

varunkum (3/7/2011)
http://imageupload.org/?di=1312995099649
Please see the image above i want the output like this. I hope i made myself clear. I just need an idea to print all the codes even 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)

March 7, 2011 at 9:49 am

#1295424
RE: tempdb question

"Accidental Cross Join" and Many-to-Many join
--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)

March 7, 2011 at 9:45 am

#1295420
RE: Concatenating Rows

Never mind on the .WRITE method. I just found the answer in Flo's article that you provided a link for. Thanks for the link.
--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)

March 7, 2011 at 8:34 am

#1295366
RE: tempdb question

TheSQLGuru (3/7/2011)
1)3) I guarantee you that I can fill up an 8GB tempdb with data from a 400MB database for a SORT operation - it is called a cartesian product....
--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)

March 7, 2011 at 8:23 am

#1295360
RE: Concatenating Rows

SQLkiwi (3/7/2011)[hrWell it's not really RBAR - it is a set-based solution of sorts, but you are absolutely right to point out that it is not at all suitable for...
--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)

March 7, 2011 at 8:21 am

#1295358
RE: Execute stored procedure

There are ways to build all 200 commands at once and then execute them with a single EXEC but it won't make the code any more effecient because building 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)

March 7, 2011 at 6:33 am

#1295296
RE: Difference between varchar(max) and varchar(8000)

Nah... no pork chops required on this friendly little thread. 🙂
--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)

March 7, 2011 at 6:23 am

#1295288
RE: Is Microsoft neglecting SMO?

Phil Factor (3/7/2011)
I just had a look at the projects I'm using Powershell for and there is nothing there that SSIS can be made to do.
Now THAT's an interesting thought....
--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)

March 7, 2011 at 6:21 am

#1295286
RE: Is Microsoft neglecting SMO?

Saravanan Durairajan (3/6/2011)
Why do I need Powershell, when I can do all the stuff in GUI using SSIS? Powershell is another geek tool.
Heh... because some of us are heavy-duty batch...
--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)

March 7, 2011 at 6:20 am

#1295285
RE: question about update record

Mike01 (3/6/2011)
don't forget the where clause or all of your records will be the same 😉
Thanks for the catch, Mike. Shamefully, I only fixed what I saw. :blush:
--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)

March 7, 2011 at 6:16 am

#1295283
RE: Concatenating Rows

guruprasat85 (3/7/2011)
Declare @var varchar(1000)
Set @var=''
Select @var = @var + fruit + ',' from #temp
Select substring(@var,1,len(@var)-1)
Please read the posts above for why that's a bad idea and what to do about...
--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)

March 7, 2011 at 6:14 am

#1295280
RE: how to write this query

Mad-Dog (3/6/2011)
Hi,
I've 2 server with the same tables and i need to move data between the DEV to the PROD.
my question is how i can write the tsql that will...
--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)

March 6, 2011 at 1:19 pm

#1295151

Viewing 15 posts - 34,756 through 34,770 (of 59,099 total)