Hi Grant

Many thanks for replying.

I've updated and tested successfully using:

AND (@getnull = CASE WHEN (tbl_project_item_invoice.col_project_item_invoice_id IS NULL)

...

Hey Jesse

Very nice, save me having to build a help file to do the searching for all those forgotten bits 😎

Lee

Hi Lynn

Thanks for that, I get it, feeling a bit of a dope now. 8=) So I'd calculate full row storage requirements (max of 8k) by doubling the stated sizes...

Hi Michael

Yep that too, thanks for the reminder I appreciate it.

Lee

Hi Jeff

Yeah I got that one too, with the changes to nvarchar I'd have to double the storage size specified on the field so the change varchar(25) would be nvarchar(50)....

Hi Michael

Thanks for your reply.

Makes sense to me and a lot less involved than I expected to be honest, I had a real dread about the current data. The client...

Got it working, (linked server that is) very fast it is too!

Hi Scott

Thanks for the tips, much appreciated.

I'm going to go back and work on the linked server thing, I resorted to OPENROWSET because I couldn't get the linked server and OPENQUERY...

Finally decided to use OPENROWSET

I think it's the OPENQUERY and sp_addlinkedserver I need to look at, I'll post back if I've got any questions.

Thanks for the explanation Kenneth

Hey Chris

Exactly the kind of info I'm after, thanks a million

the question more is the affect...some like you might just (intelligently and wisely) separate the wheat from the chaff and others like me might just cower beneath my desk and...

sushila >> thanks for the links. Opened my eyes yet again to the other side of the debate. Maybe I'm not as bad as I thought

Hey sushila, thanks for that, it's actually quote sunny out here ...