Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,951 through 43,965 (of 59,063 total)

RE: Looping SQL Process To Select n rows from SQL Table

It would be a whole lot easier if you could use xp_CmdShell and BCP in a T-SQL loop. Are you allowed to use xp_CmdShell?
--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)

April 29, 2009 at 10:55 pm

#986418
RE: Sending Table to CLR stored procedure

Just curious... what will this CLR Stored Procedure do?
--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)

April 29, 2009 at 10:26 pm

#986415
RE: Performance issue with tally solution

Heh... oh my... someone is as crazy as I. Ya gotta be to know songs like 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)

April 29, 2009 at 10:20 pm

#986414
RE: Auditing Jobs in SQL

I ran into a server that had that many jobs, once. I disabled them all (except for know server maintenace) and would only turn them back on if someone...
--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)

April 29, 2009 at 9:07 pm

#986394
RE: UPDATE column with auto number depending on field value ?!

Bob Griffin (4/29/2009)
This logic would require some kind of looping to work. You also need a where clause in your update. Probably use a subselect for your...
--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)

April 29, 2009 at 8:58 pm

#986391
RE: UPDATE column with auto number depending on field value ?!

john.arnott (4/29/2009)
Now, if we're lucky, someone can help us figure out a single pass solution.
Use two counters and a case statement in the SET.
--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)

April 29, 2009 at 8:56 pm

#986390
RE: UPDATE column with auto number depending on field value ?!

m.berggren (4/29/2009)
DECLARE @counter int SET @counter = 1 UPDATE custom.table1 SET @counter = table1.number = @counter+1
The problem with that is that you've included the table schema in the set clause. It should...
--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)

April 29, 2009 at 8:54 pm

#986388
RE: UPDATE column with auto number depending on field value ?!

Sergiy (4/29/2009)
john.arnott (4/29/2009)
Now, if we're lucky, someone can help us figure out a single pass solution.
Solution was posted here many times, and Jeff Moden even made an article out of...
--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)

April 29, 2009 at 8:45 pm

#986387
RE: Comparison of Dates in SQL

Amber.Brouillard (4/29/2009)
I discovered this several months back, but I use: dateadd(day,1,) as my fix. Just another way of doing it.
This is VERY useful information! Thanks for...
--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)

April 29, 2009 at 8:41 pm

#986385
RE: Comparison of Dates in SQL

Nope... 23:59:59 misses almost a whole second of the day. The >= and < method is probably the best method there 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)

April 29, 2009 at 8:40 pm

#986384
RE: Performance issue with tally solution

Paul White (4/29/2009)
Jeff Moden (4/29/2009)
Thanks, Paul. I appreciate the feedback... didn't know you already knew about it.
😎 I didn't know that you didn't know I knew about it...over 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)

April 29, 2009 at 8:26 pm

#986379
RE: Performance issue with tally solution

Paul White (4/29/2009)
Jeff Moden (4/29/2009)
http://www.sqlservercentral.com/articles/T-SQL/63003/
Thanks Jeff,
I have read that before, and use that approach currently.
When Adam asked for ideas to extend the string-split, this came to mind.
It would be interesting...
--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)

April 29, 2009 at 7:55 pm

#986367
RE: Special Characters

Ok, here we go... Assuming that you have the company name in a variable and the fact that you're using a version of T-SQL that cannot use functions, here's 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)

April 29, 2009 at 7:30 pm

#986363
RE: Performance issue with tally solution

Paul White (4/28/2009)
Florian Reischl (4/28/2009)
Hierarchical data to be split? Well. This becomes really freaky... It would require either recursive methods or a much more complex RegEx which also becomes quiet...
--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)

April 29, 2009 at 6:06 pm

#986347
RE: Special Characters

jim.rasmussen (4/28/2009)
Yes it does. I have researched this, but can't seem to make it work correctly. Any thoughts?
Thanks
Jim
Sorry, Jim... I had almost 900 emails in my inbox since I posted...
--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)

April 29, 2009 at 5:58 pm

#986346

Viewing 15 posts - 43,951 through 43,965 (of 59,063 total)