Now that's another problem .

I'll have to add this possibility when I remake my dts version of this script.

HTH.

Yes but the designer doesn't support it... so I usually build the bulk of the query there, then go back to QA and finish there.

What part are you not getting??

Works fine as long as you don't have 50 columns and 1M rows.

My version does a single pass per table, and all tables.

And as I said, it would be better...

If you just need the final insert to work for now. I'd rebuild it from scratch. It think it would less of a headache.

Also in sqlserver, views are...

My bad, did test on an old db that I don't know very well.. I assumed some nulls were caused by a lack of usefull data.

Here's a better version :...

Glad to hear it can't be that... but that doesn't help much in telling what did happen .

You can't (read shouldn't) do that. Move that select into a view or a inline table function if you need parameters. Then you'll be able to do the...

I'd go further... It would be in your best interest to stop using EM manager for a few days/week just to see all you can do in QA (assuming your...

Thanx .

HTH.

This corrects the problem server side. Access also caches metadata when it opens. So another part of the solution would be to go to the database window of...

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=222242

Why not just add an identity column to the table??

In case anyone's wondering >> (a/b.0) * 100

This one only checks for the length of [n]chars and [n]varchars columns, prints the list of voided tables. This can be usefull if you only want to see the...