I guess it's kinda hard to add 1 to a char field. I see what your trying to do Chris. I need to cast the char as a bigint,...

I didn't see my last post. I'm testing with 1 iteration first. Once it works I'll figure out a bulk method.

INSERT INTO Ex_ItemsException (ReviewDate, Hub, BankNumber, BranchNumber, AccountNumber)

SELECT ReviewDate, Hub,...

INSERT INTO Ex_Items (ReviewDate, Hub, BankNumber, BranchNumber, AccountNumber)

SELECT ReviewDate, Hub, BankNumber, BranchNumber, (AccountNumber + 1)

FROM Ex_Items

Causes:

The conversion of the varchar value '000000005121321212' overflowed an int column. Maximum integer...

Thanks for the replies guys. I'll try suggestions. I can do a SELECT, but not sure how to manipulate data and then insert.

Existing data in row 1

Col0(Identity)Col1 Col2 Col3 ...

INSERT INTO Mytable (col1, col2, col3, col4)

SELECT col1, col2, col3, col4

FROM Mytable

Set col1 = col1 + 1

Set col2 = col2 + 1

Set col3 = col3 + 1

Set col4...

I'd like to see some type of formula that would determine the efficiency of a particular index, e.g. (pseudo-code)

If (user_seeks <> '0') and (user_scans/user_seeks > 0.5)

output 'Verify Index' , Table_Name,...

Everyone's right. Partition the tables and align indexes. Use different physical disk channels where possible.

Let the server handle the identity column, not your app. Do not set Identity_Isert to ON. Insert your data and SQL will increment the identity column.

They could expand the DateAdded field to char(17) and use

Select replace(convert(varchar, getdate(),111),'/','') + replace(convert(varchar, getdate(),114),':','')

to return 20081102115655013

If you need unique fields and the .013 seconds does not suffice then...

Oops! Little quick on the draw.

Good one. Thanks for the laugh.

I know it's not trivial. Only knowing your tables in general terms I'd make some external tables:

FirstNameTable

LastNameTable

AccountNumber

SocSecNumber

etc

and read from them...

Good one. Thanks for the laugh.

I know it's not trivial. Only knowing your tables in general terms

Never, never, never use customer confidential data in a demo or presentation. You probably signed, or your clients should have had sign, some type of non-disclosure. You won't be a...