Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,141 through 43,155 (of 59,063 total)

RE: Are the posted questions getting worse?

GilaMonster (6/30/2009)
Roy Ernest (6/30/2009)
Today I actually felt that I am invincible or totally ignored. It was as if I was a ghost... 😛
:hehe:
Looks like totally ignored to me.
Looks pretty...
--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)

June 30, 2009 at 1:51 pm

#1017928
RE: Help Needed ???

Matt Miller (6/30/2009)
Jeff Moden (6/30/2009)
espilman (6/30/2009)
All I was saying is that I wasn't sure whether the integrity of the columns needed to be intact.
That's exactly the reason why I want...
--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)

June 30, 2009 at 12:16 pm

#1017852
RE: printing 1 to 100 in SQL Server as a batch....

Paul White (6/30/2009)
Jeff Moden (6/30/2009)
Does anyone know if Master.dbo.spt_Values has been deprecated?
Oh. I always thought of it as 'undocumented' anyway...? :unsure:
Heh... yep I know. Just wanted to...
--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)

June 30, 2009 at 12:04 pm

#1017837
RE: converting lowercase to uppercase

AmolNaik (6/30/2009)
Best is to leave the formatting and case conversions at the front end application, should try not to use SQL Server for formatting and case conversion tasks which are...
--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)

June 30, 2009 at 11:59 am

#1017833
RE: printing 1 to 100 in SQL Server as a batch....

Yep... I saw that, Lynn. Thanks. I actually thought it was a type-o. Now I know better.
Guess I'll have to fall back a bit and start using...
--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)

June 30, 2009 at 9:05 am

#1017643
RE: printing 1 to 100 in SQL Server as a batch....

Damn... can't keep up with all the stuff Microsoft wants to take away anymore. Didn't know that. I knew that dbo.sysColumns was going away, just not sys.sysColumns. ...
--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)

June 30, 2009 at 8:48 am

#1017622
RE: printing 1 to 100 in SQL Server as a batch....

Ack.... :hehe: wasn't trying to be funny on that one. Master.sys.sysColumns will normally contain over 10,000 rows of system related column info even on brand new installations. 🙂
--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)

June 30, 2009 at 8:33 am

#1017610
RE: Retrieve comma-separated list within group by

Heh... I figured it was driven by management. As you know (especially because you said so :-)), storing such (CSV) data in any type of table other than maybe...
--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)

June 30, 2009 at 8:20 am

#1017600
RE: Help Needed ???

espilman (6/30/2009)
All I was saying is that I wasn't sure whether the integrity of the columns needed to be intact.
That's exactly the reason why I want to know what 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)

June 30, 2009 at 6:41 am

#1017523
RE: printing 1 to 100 in SQL Server as a batch....

Paul White (6/29/2009)
Ha! Er, yeah - it raises an error if there aren't enough rows in the system table 😀
Use Master.sys.sysColumns instead... it'll have enough rows. 😉
--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)

June 30, 2009 at 6:25 am

#1017517
RE: Retrieve comma-separated list within group by

Thank you very much for taking the time to explain that to me. Most people pose what the want to solve for instead of posting what the problem is...
--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)

June 30, 2009 at 6:16 am

#1017513
RE: Help Needed ???

lmu92 (6/30/2009)
Nice one, Jeff!!
Sometimes the occurrence of the word "PIVOT" isn't that bad, obviously... - especially when it comes together with an "UN".
Seems a little easier to deal with than...
--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)

June 30, 2009 at 6:00 am

#1017500
RE: Help Needed ???

mandirkumar (6/30/2009)
Thanks to everyone 🙂
Oh no, no, no... you can't go away, yet. I want to know what the business requirements are that caused you to ask this 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)

June 30, 2009 at 5:57 am

#1017498
RE: printing 1 to 100 in SQL Server as a batch....

Intentional obfuscation of purpose through the joyful infusion of unnecessary code just for the fun of it all. 😉
--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)

June 29, 2009 at 9:52 pm

#1017350
RE: Add a column in system table(SQL_LOGIN)

saxena.rohit (6/29/2009)
I need to add a pin for each user in SQL login table..
Why not just accept "PINS" as the password?
--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)

June 29, 2009 at 8:38 pm

#1017332

Viewing 15 posts - 43,141 through 43,155 (of 59,063 total)