Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,336 through 43,350 (of 59,063 total)

RE: Using @@IDENTITY With OUPUT Clause

southwynd (6/16/2009)
I figured it out. @@IDENTITY will not work. This is what I needed to do:
SET @ID = IDENT_CURRENT('Table1 ')
No... IDENT_CURRENT can allow other people "in". Take...
--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 16, 2009 at 8:59 pm

#1010605
RE: average rows between last match

andrewd.smith (6/16/2009)
You might wish to cast to a float or decimal value before calculating the average.
Nicely done, Mr. Smith. 🙂
--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 16, 2009 at 8:57 pm

#1010602
RE: How to concatenate row values?

MissyDaisy (6/16/2009)
Jeff,
I don't know how to get an ascii dump of a string from a particular column so I can't accurately say what characters they are.
Visually, it has spacing wider...
--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 16, 2009 at 8:56 pm

#1010600
RE: Code Shortcuts

Steve Jones - Editor (6/16/2009)
Quick clicks, for example, I typically type the code in, highlight, and then click "code" from the left.
So, why not add a "#" to the menu...
--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 16, 2009 at 8:51 pm

#1010599
RE: how to check if SQL Server is running or NOT

You can simply read a single row from a guaranteed-to-be-present table and then catch the error if it fails. If it succeeds, then everything is working fine including 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 16, 2009 at 8:49 pm

#1010597
RE: How to count the record in between 2 dates

Heh... thanks for the plug, Lutz. 🙂
--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 16, 2009 at 8:43 pm

#1010596
RE: Calculate relative dates in Oracle

Jason Coleman (6/16/2009)
as the dates are stored as numbers....
Anyone point me in the right direction
Thx..
The dates should be stored as the Date datatype. What is the data type...
--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 16, 2009 at 8:40 pm

#1010595
RE: NULL and Unique IDentifier.. :-(

It's simply because that setting only affects comparisons... not the way a UNIQUE index works.
--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 16, 2009 at 8:36 pm

#1010591
RE: Code Shortcuts

Steve Jones - Editor (6/16/2009)
when you post, I think a number of you notice there is a list of shortcuts to the left of the text box. This is not...
--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 16, 2009 at 8:25 pm

#1010588
RE: HOW TO AVOID FUNCTIONS ON MERGE STATEMENTS.

Unless you know for a fact that the server or the columns in the given table are case sensitive, just remove all instances of UPPER. This isn't Oracle. 😛
Unless...
--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 16, 2009 at 8:11 pm

#1010586
RE: Are the posted questions getting worse?

GilaMonster (6/16/2009)
I just got word from the documentation people. The lack of the UPDATE <alias> was simply an oversight and it will be corrected in a future version of BoL....
--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 16, 2009 at 7:37 pm

#1010582
RE: Are the posted questions getting worse?

george sibbald (6/16/2009)
Please note that the overall percentage of correct answers for QOTD has recently gone up from 57% to 58%
Heh... probably a rounding error by the same programmers 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)

June 16, 2009 at 7:22 pm

#1010578
RE: DBCC DBReindex with "Sort In TembDB"

MANU (6/16/2009)
Its an option under Create Index in sql 2000:
http://msdn.microsoft.com/en-us/library/aa174535(SQL.80).aspx
MJ
Thanks Manu. What I was looking for, though, was a way to use DBCC DBReIndex with the sort-in-TempDB option. ...
--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 16, 2009 at 6:41 pm

#1010572
RE: How to concatenate row values?

Ah... got it. Seems like the right thing to do in this case.
Gus' code suggestion should work just fine except when you run into things like "&" and 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)

June 16, 2009 at 6:33 pm

#1010569
RE: TempDB mdf file has grown to 11GB

Mani Singh (6/16/2009)
Re-Starting SQL server is the best practise.
Ummmmmm.... Who made that rule? Do you happen to have an MS document that actually recommends such a practice?
--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 16, 2009 at 5:58 pm

#1010565

Viewing 15 posts - 43,336 through 43,350 (of 59,063 total)