Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,151 through 45,165 (of 59,063 total)

RE: Actual Reason to Use CLR

mdiaz (10/17/2007)
A real quick and easy way to make a split funciton, that returns records as a table.
Imagine writing that in TSQL???
Heh... sorry... ran into this today and I realize...

February 14, 2009 at 2:26 pm

#944158
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

I know it's been close to a month and you may have forgotten... do you remember what you did to get it to work out?

February 14, 2009 at 1:23 pm

#944148
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

Adi Cohn (2/14/2009)
Jeff please don’t get this question the wrong way, but just out of curiosity – Is there anyone in this world that didn’t get your flying pork...

February 14, 2009 at 12:33 pm

#944139
RE: Query output to txt file & columnheader headers

You bet... thanks for the feedback. Let us know how it works out for you.

February 14, 2009 at 12:30 pm

#944138
RE: with out using the cursor/while

Lynn Pettis (2/13/2009)
Jeff, I'm not sure if you are right or wrong still. I ran the following and everything ran fine. Can you suggest any other tests I...

February 14, 2009 at 12:15 pm

#944136
RE: Why do people need to do this?

smunson (1/24/2009)
I understand where you're coming from, but I think the gist of this thread is more related to the reason behind the desire to see order, because what Jeff...

February 14, 2009 at 12:10 pm

#944134
RE: SQL or Oracle

Roy Ernest (2/13/2009)
Bruce W Cassidy (2/12/2009)
Roy Ernest (2/11/2009)
One thing I have seen is that Unix (Linux or Sco or what ever) has a better File system. This made Oracle much...

February 14, 2009 at 12:02 pm

#944132
RE: Query Tune

Mike Levan (2/14/2009)
Guys...what do u mean by that.
" this probloem deos not apply to sql 7 or later"
It means that the myth of SELECT/INTO locking sysobjects so it can't be...

February 14, 2009 at 11:59 am

#944130
RE: how to split following string

bkDBA (2/13/2009)
Jeff, I hear a non-RBAR solution coming... anyway, thanks for the awesome presentation last night at the SEMSUG at Microsoft!
I had a RBAR "discussion" with...

February 14, 2009 at 11:50 am

#944128
RE: How to get start and end value from a sequence of numbers - Grouped by a different field.

gvsriramakrishna,
You must really like pork chops... 😉

February 14, 2009 at 11:46 am

#944125
RE: Find all rows in a VARCHAR that can't be cast into an INT

Shawn Therrien (2/9/2009)
SELECT * FROM TestScores WHERE Score <> '0' AND ISNUMERIC(Score) = 0
Worked perfectly.
Thank you sir. Always a good day when I learn how to do away with...

February 14, 2009 at 11:34 am

#944123
RE: Convert Interger Time to 00:00:00

Vivien Xing (2/13/2009)
My test shows 50% : 50% execution plan cost for these 2 codes.
create table mytest (mytime int)
insert mytest values (91700)
insert mytest values (212000)
insert mytest values (90200)
insert...

February 14, 2009 at 11:21 am

#944121
RE: 1-M join, concat all records

Then, I think Andrew's solution may be the best. If it was a text file input, you could simply do a BCP out using a simple SELECT and use...

February 14, 2009 at 10:20 am

#944106
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Wait a minute... is the goal to have every team play every other team twice (once at home and once away)? If so, just go get a bowling schedule...

February 14, 2009 at 10:16 am

#944104
RE: Query Tune

Andrew Reilly (2/13/2009)
But Jeff
NOTE: This problem does not apply to SQL Server 7.0 and later.
Heh... that's what I said... it's NOT a problem anymore.

February 14, 2009 at 10:06 am

#944101

Viewing 15 posts - 45,151 through 45,165 (of 59,063 total)