Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,481 through 42,495 (of 59,102 total)

RE: How to wrap a Recursive CTE in a view?

No! The recursive CTE method is the wrong method for this! Do you have the link back to the original problem? Recursive CTE's are just too damned...
--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)

August 7, 2009 at 8:39 am

#1036043
RE: Are the posted questions getting worse?

Ok... I need a pry bar or at least a sturdy sword to get the tennis shoe out of my mouth. It was a different guy and not 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)

August 7, 2009 at 6:44 am

#1035943
RE: The query output should be

Ah... my very bad then... you are a different Karthik than the one I'm used to working with. Someone showed me that there are two people with 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)

August 7, 2009 at 6:42 am

#1035939
RE: How to split the batch wise id in commaseparatedly?

Heh... but I know how this works... 99% of the time, if you don't get your answer up front, the OP becomes a check valve as soon as he gets...
--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)

August 7, 2009 at 6:37 am

#1035935
RE: Copying & Tracking Data

Darned sorry about that, Goldie. I answered too quickly.
You would think that Microsoft would allow you to return data from the "from_table_name" on an insert like they do on...
--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)

August 6, 2009 at 9:52 pm

#1035788
RE: Master list of tasks for a complete backup

Ummm... not 100% sure but it seems to me that we needed to change the IP address, as well. Maybe that's because we also copied the Windows Server, as...
--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)

August 6, 2009 at 8:31 pm

#1035762
RE: SQL 2000 --> SQL 2008

I'd also recommend doing several tests on a separate box until you get it right. 😉 Once you get it right, schedule an outage so no one can change...
--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)

August 6, 2009 at 8:23 pm

#1035760
RE: date time

Here's how but I need to know... why do you need to do this type of formatting in SQL?
SELECT STUFF(RIGHT(CONVERT(VARCHAR(50),GETDATE(),109),14),9,4,'')
--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)

August 6, 2009 at 8:19 pm

#1035758
RE: Copying & Tracking Data

With the OUTPUT clause, Goldie...
-- goal is to copy over data for specified test
-- need to keep track of which sections map to each other
-- here's the insert
-- but how...
--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)

August 6, 2009 at 8:02 pm

#1035755
RE: Determine Row Size on a Table

Heh... guess what happens when you do a search for the following in Books Online? 😉
[font="Arial Black"]Estimating the Size of a Table [/font]
--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)

August 6, 2009 at 7:43 pm

#1035752
RE: Loyalty Cards

I like the way the "Speedway" service stations did it here in Michigan. You don't have to fill out a bloody thing. They give you a card and...
--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)

August 6, 2009 at 7:36 pm

#1035750
RE: Loop to count

gaj104 (8/6/2009)
Hi,
Maybe I'm missing something here, but why bother with a script?
Simply use the unpivot function and then query as normal:
WITH P
AS (SELECT EMPLOYID,
...
--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)

August 6, 2009 at 7:30 pm

#1035748
RE: Gain Space Using XML data type

Very interesting indeed! Thanks for the great write up, Paul. That certainly puts a different slant on "the rumor".
--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)

August 6, 2009 at 7:08 pm

#1035740
RE: Update column with itself plus value of column in another table -- accumulating?

hugh.hemington (8/6/2009)
Could you recommend a good T-SQL primer?
I have "Wrox Press Beginning T-SQL with Microsoft SQL Server 2005 and 2008"
I looked up "QUOTENAME" in that book, but when the brief...
--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)

August 6, 2009 at 6:06 pm

#1035738
RE: Update column with itself plus value of column in another table -- accumulating?

Don't use the While Loop examples, either. They're nothing but cursors without the word "cursor" in them. Cursors and While Loops are very bad ways to go compared...
--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)

August 6, 2009 at 5:33 pm

#1035735

Viewing 15 posts - 42,481 through 42,495 (of 59,102 total)