Thank you very much, it works

Thank you, this seems to work for me, appreciate quick reply

Thanks for clear explanation it worked

This is how I solved the issue:

use InputDatabase;

run my scripts where my inserts look like this:

insert into OutputDatabase.Scheme.Table

I still don't understand why it matters so much if the current database...

My question still stands - does column content (some values vs. all nulls) matter when altering column type from INT to BIGINT?

As I have said - old values no longer needed, this recommendation is not really applicable

No, the name is unique, I have checked that

Thank you!

I think that group by along with having clause is what you are after, such as:

select customer_id
,street_number
,street
,City
,State
,Zip
from your_table

Thanks for a simple yet effective tool.

One thing was not clear = why all those functions are declared to return TABLE? it looks to me these funcs return just a...