Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,271 through 39,285 (of 59,098 total)

RE: Representing a hierarchy from comma separated values

pYak (3/17/2010)
Can I do this with a set based solution?
The answer is... kind of. In SQL Server 2005 and below, you need some form of looping for Hierarchy resolution...
--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 18, 2010 at 7:34 am

#1135940
RE: How to pass a Microsoft certification [70-432]

I can certainly understand not having any access to the internet during an exam... but not having access to BOL doesn't seem right to me. It's a tool (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)

March 17, 2010 at 11:48 pm

#1135744
RE: Querying reserved words?

There's a list of reserved words in Books Online and it's not limited to just T-SQL.
--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 17, 2010 at 11:41 pm

#1135739
RE: Should We Lead or Follow?

Heh... and sometimes you have to PUSH! 😛
--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 17, 2010 at 11:36 pm

#1135736
RE: Statement referencing column that doesn't exist yet

Not trying to be a smart guy here...
It's normally a very bad idea to programatically add a column as a matter of course and it's usually really bad if it's...
--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 17, 2010 at 11:32 pm

#1135734
RE: Date format no matter the server settings

Digs (3/17/2010)
Any ideas
Yes... NONE of these problems would exist if the dates and times were properly stored as DATETIME data instead of VARCHAR data.
--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 17, 2010 at 11:27 pm

#1135730
RE: Should We Lead or Follow?

Heh... feedback... it was "feedback" that was supposedly responsible for that bloody "ribbon" in Office 2007.
I've found the same thing even on some of the MVP sites. ...
--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 17, 2010 at 11:19 pm

#1135726
RE: Are the posted questions getting worse?

Alvin Ramard (3/17/2010)
CirquedeSQLeil (3/17/2010)
A thought just occurred to me.
We see several people complaining about the English in the QOD. What if we responded to all QOD comments for 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)

March 17, 2010 at 11:00 pm

#1135718
RE: An Urgent Ad Hoc Report

I very much appreciate this article as we've all had a similar problem at one time or another and they always seem to pop up when you have an after...
--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 17, 2010 at 9:44 pm

#1135695
RE: Are the posted questions getting worse?

Lynn Pettis (3/17/2010)
[font="Comic Sans MS"]Looks like the TitD (Tent in the Desert) will be hosting another party fairly soon!![/font]
Jeff only needs 83 more posts to break the 20,000 posts mark!
Heh......
--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 17, 2010 at 7:01 pm

#1135665
RE: Nested Loop Joins on Temp Tables

ryan.hart (3/17/2010)
I don't know why statistics are disabled. I'm afraid it's not a temporary condition, though... unless I can convince them to rethink it! The one person that...
--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 17, 2010 at 6:55 pm

#1135661
RE: Looks like a PIVOT table problem, but for text, not aggregate data

Rhett Lowson (3/16/2010)
but I can't 'aggregate' my text
Sure you can... MAX...
--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 17, 2010 at 9:29 am

#1135353
RE: loops,ROW_NUMBER,cursor

Peleg... for better answers quicker, please see the first link in my signature line below.
I see what you're trying to do... it's called "Concatenation". There's also several other ways...
--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 17, 2010 at 9:27 am

#1135349
RE: Transposing repeating sets of rows into colums

The problem is that there's nothing in the bulk table to guarantee the order and I don't trust an unindexed heap to do 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)

March 17, 2010 at 9:23 am

#1135344
RE: jobs are runinng long time (urgent )

ramyours2003 (3/17/2010)
iam facing problem in my production system that the jobs are taking longtime from past days to complete , even backup jobs are taking long...
--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 17, 2010 at 9:15 am

#1135334

Viewing 15 posts - 39,271 through 39,285 (of 59,098 total)