Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,626 through 32,640 (of 59,099 total)

RE: Deleting from a table with a hierarchyid

In that case, I wonder if the OP ever got an answer from somewhere?
Also... I don't believe you can just "soft delete" when the HierarchyID is being used.
--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)

September 7, 2011 at 6:39 pm

#1378316
RE: How do I combine a column from multiple rows into a string or new column?

Tee Time (8/29/2011)
Very nice! I will definitely find the STUFF fuction useful. Learning more and more each day thanks to you all! 🙂
You do realize that 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)

September 7, 2011 at 6:37 pm

#1378315
RE: SQL 2008 - T-SQL query assistance

R.P.Rozema (8/30/2011)
I, for one, would be very interested to see a nested set implementation explained. I've read a lot about it and think it looks very promising, but I so...
--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)

September 7, 2011 at 6:30 pm

#1378314
RE: PIVOT result column format

R.P.Rozema (8/30/2011)
And if you must do the formatting in T-SQL, you could replace the pivot by a crosstab. Then you can use max(), which allows for character strings to be...
--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)

September 7, 2011 at 6:26 pm

#1378313
RE: problem when loading the bulk insert data from csv file to sql table

SQL_Ninja (9/7/2011)
I've sent you a pm on this one.
Why not post your answer here?
--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)

September 7, 2011 at 6:11 pm

#1378312
RE: Insert data with select statement is very slow.

As Lowell pointed out, you have an accidental cross join (think "many-to-many" join and look for the arrows with counts larger than the table or index they're coming from) in...
--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)

September 7, 2011 at 6:11 pm

#1378311
RE: Need help with cte or self Join

toddasd (9/1/2011)
What would be the logic to populate those values?
Do you already have the columns defined?
Is the start value a running total?
That takes care of #2, but the important question...
--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)

September 7, 2011 at 5:49 pm

#1378309
RE: Convert interger to string

sql_novice_2007 (9/7/2011)
SELECT CAST(ROUND(((99999999 - 1000 -1) * RAND() + 1000), 0) as varchar),ROUND(((99999999 - 1000 -1) * RAND() + 1000), 0)
When I run the above query I am getting 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)

September 7, 2011 at 6:26 am

#1377927
RE: Sequence creation

SQLServerMS (9/7/2011)
Hi,
I need to populate the values for a column in a sequential manner as below, these need to be auto generated:
i1st it starts with
000001
000002
......
999999
A00001
A00002
......
A99999
B00001
......
B99999
......
Z99999
ZA0001
......
ZA9999
......
ZZZZZZ
How can i achieve this.......
--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)

September 7, 2011 at 6:12 am

#1377914
RE: Running totals

cidr (9/6/2011)
Hi Jeff,
I'll double check with them. I think the logic they had was that they wanted to slice/dice data, by productID, then by SalesmanID etc, not together.
However,...
--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)

September 7, 2011 at 12:26 am

#1377781
RE: Are the posted questions getting worse?

SQLRNNR (9/6/2011)
Jeff Moden (9/6/2011)
Roy Ernest (9/6/2011)
Yay...!!! I beat the THREAD to the landmark. I hit 3000 posts before the thread hit 3000 pages. 🙂
I was going to post a prediction...
--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)

September 7, 2011 at 12:20 am

#1377780
RE: Looking for help taking the RBAR from this problem

mister.magoo (9/6/2011)
I am glad you are making progress 😀
I would suggest you keep an eye on this because, from past experience, whenever Jeff goes quiet for a day or two...
--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)

September 7, 2011 at 12:17 am

#1377779
RE: Are the posted questions getting worse?

Roy Ernest (9/6/2011)
Yay...!!! I beat the THREAD to the landmark. I hit 3000 posts before the thread hit 3000 pages. 🙂
I was going to post a prediction that you'd easily...
--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)

September 6, 2011 at 12:23 pm

#1377622
RE: How much time investment do you put in for planning for the future?

I was ready for Y2K in 1980 and I'm ready for 2079-06-06 right now. 😉
--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)

September 5, 2011 at 11:18 am

#1377116
RE: Breakfast

Tom.Thomson (9/3/2011)
I guess pop tarts are nice, but that's purely guesswork as I haven't a clue what one is.
It's fruit flavored SOS with the "S" on the inside. 😉
--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)

September 5, 2011 at 10:59 am

#1377110

Viewing 15 posts - 32,626 through 32,640 (of 59,099 total)