Picture link is broken Steve... No comment on the article as I've not read it, yet .

You can't imagine how happy I am to have bowed out of this one after day 1.  I wish I could compute the time I saved by not reading that...

Gonna save Jeff some typing.

You still don't need a cursor for that conversion.  Use temp tables and batch convert the data before final import.

Can't be done unless you know the system.  This job is much easier to custum make than to be made by sql server.

List all tables where the id has been present, then depending on wether this is n-n or 1-n, then you can simply replace the new id with the old id. ...

Can you supply the table DDL please?

TIA.

Here's a much shorter version of the same idea.  I once had a trigger that was updating a column in a table RBAR style (select the row id, then update...

Can you post the code so we can look at it.  We'll explain as we go along.

Short story : varcharCol1 + UnicodeStaticString + varcharCol2 ... = Unicode = 4000 chars...

USE SSC

GO

IF EXISTS (SELECT * FROM dbo.SysObjects WHERE Name = 'Demo' AND XType = 'U' AND USER_NAME(uid) = 'dbo')

 DROP TABLE dbo.Demo

GO

CREATE TABLE dbo.Demo

(

   TruckID INT NOT NULL

 , StatusDate DATETIME NOT...

We need table DDL to answer this one.

One thing to check out is the make sure that no column is of unicode datatype (nchar, nvarchar) and not even some constant...

A problem / solution post is more usefull to the world than "solved".

Just my 2 cents.

Hence the not necessary to do so.  But it doesn't stop me from doing it all the time .

I'd like to see your final solution if you don't mind sharing it with the world.  It may help someone else in the near future who is in the same...

On the onclick() event of the combobox, check the value of the combo and display/hide the textbox accordingly.

Then depending on wether the textbox has a datasource, then you may hve...

But now just imagine what I could get when I'll hit the 10K mark .