You could also just call your procedure and insert it into a table variable or temp table from your main procedure, that way you don't have to create the functions....

of the 16 values in your numeric number 9 are keep for the right hand side of the decimal, meaning that only 7 digits can be used on the right...

good point.

Just case someone wants to Use CHECKIDENT.

Other method of doing it is to

DBCC CHECKIDENT(mytable,reseed,0)

--seed it to 0 first

DBCC CHECKIDENT(mytable,reseed)

--This will automatically reseed to the next correct seed value.

Using...

Ok the first thing to remember is that they both perform different functions

Lets start with ISNULL statement

WHERE ISNULL(Col1,'') = 'NOCHANGE'

The reason you use is null is so that you don't...

will this work for you?

DECLARE @visit TABLE

(VisitID INT PRIMARY KEY,

StudentID INT,

visitDate DATETIME,

score INT)

INSERT INTO @visit(VisitID, StudentID,visitDate,score)

SELECT 1 , ...

I would suggest using a tally table rather than a loop 🙂

basically if OP2.Contract_Line_Number != 'NOCHANGE'

Then you will get results

Is that the solution you using or the problem you having?

We still don't understand why you feel the need to test GETDATE vs GETDATE cause the answer is ALWAYS the...

Or is the situation something like this

DECLARE @TABLE TABLE

(Number INT,

Date1 DATETIME,

Date2 DATETIME)

INSERT INTO @TABLE

SELECT 21,GETDATE(),GETDATE() UNION ALL

SELECT 21,GETDATE(),DATEADD(dd,2,GETDATE())

SELECT Number/CASE WHEN (datediff(dd,Date1,Date2)) = 0 THEN 1 ELSE (datediff(dd,Date1,Date2)) END

FROM...

Is this a real life example.

Cause if you always doing a date diff with GETDATE vs GETDATE then why don't you just do this.

SELECT 21

I think something is missing here.

Do...

I agree with all that steve has said,

I'd just like to add that I see a INDEX hint?

It's not often that the optimizer is wrong, so make sure the hint...

thanks for that I didn't know that.

I'm actually using a real table but my join is using a variable.

So there is Predicate his using a scalar operator.

Will this result in...

I'm not sure what you mean...

What should the actual results be?

You can't use ROW_NUMBER() in SQL 2000 or SQL 7 you need to use another approach.

Try my solution or try reading lynn's post about running totals!

Thanks

Chris

HI all,

This is a double post.

arluna as Jeff and some others mentioned in your other post.

This shouldn't be a problem, and it's best to make sure your column is indexed.

Thanks

Chris