Just compressed some of my templates and they showed (Opened QA after compression)..

Try

set @strsql='insert into ' + @vtbl + ' values (15)'

PRINT probably formats to your local environmental set-up because PRINT denotes that a human wants to see the data.  SELECT is used internally and doesn't need the nice formatting for...

Remove the square brackets from around the comma REPLACE(field, ',', '')

ok.  IF all the cells are populated and the NON leading zero ones are loaded.  I wonder what would happen if you sorted by site number and then loaded...... i.e....

Are all the sitenames being populated?  I seem to remember having a similar problem where not all cells in column were populated and 0 data was loaded along with IF...

We use Red gates software as a sanity check between Production and Dev|Test|Staging to ensure that the 4 environments are back in sync after MAJOR installs.

This has helped (along with...

I would look at Red Gates SQL Compare product.  This does what you are proposing for around 200 a license.....

You can use Import/Export and tell it which columns to copy to different table(s)

We use Harvest as our source control.  Our approach is as follows:

1. Developers develop code and place it in Harvest (Dev env.)
2. Code is migrated to Test and tested by QA team. ...

This is 1 of the most discussed topics here.  Basically when you pass the (333, 222, 333, ) etc in as a parameter SQL "sees" it as the LITERAL "(333,...

Please see response about same topic:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=179272

If you want to review the T-LOG I believe you will need a 3rd party tool (I assume that is what LOG MINER) does..

If you want to know who/what/when without...

Red Gate has a tool that we use (SQL Compare) that is around $200.00 US per seat...  Works like a charm gives you the option to review, apply either way,...

If you have coded an audit trail then you will be to get this information otherwise unfortunately, there is no trail...