I would go with SCOPE_IDENTITY(). There is a great example on the differences between these three when you look at BOL for IDENT_CURRENT.

See if this provides additional information

http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867

This mightmare table master..spt_values has also been extended to 2048 (unless I am mistaken) in the next version. 

Umh? Sounds like a Dr. Bob episode from the Muppet Show.

This is a nice solution. However, on a larger table you might be better off using an intermediate table like this when you have gaps in your date sequence.

SET NOCOUNT...

FWIW, here are two other variations

CREATE TABLE #num

(

 nbr INT

)

INSERT INTO #num

SELECT Number+10001

FROM master..spt_values

WHERE type='P' AND Number<100

SELECT * FROM #num

DROP TABLE #num

You can also use your own number table. Pretty handy in...

Piggy-backing on Remi, try this:

SELECT

 REPLACE(REPLACE(RTRIM(REPLACE(@a,'0',SPACE(1))),SPACE(1),'0'),'.','')

Thats the forum software. It parses the text for characters to convert to smilies. Pretty annoying when posting code

Okay, completely ignoring the logical aspects here.

john has already hit the nail right on the head here. Even if you use a CHAR(4) I suspect sorting and/or joining operations to...

Please not again an IDENTITY discussion. This is a never ending story. I really, really like SQL Server MVP Steve Kass' answer here:

How...

Poor old man. Must be hard to be that old, eh? I feel for you.

I have not much experience with DTS. You might find something useful here http://www.sqldts.com

A quick and dirty way moght look like

USE NORTHWIND

GO

SELECT TOP 1

     used AS "# of Pages"

     , rows AS "# of Rows"

     , (used * 8) / 1024 AS "#...

I don't think there is any advantage in specifying TOP 1, since EXISTS will stop evaluating anyway, after it has found one matching row.

You should contact Vyas directly.

He's a nice guy and should be more than willing to improve his code.