Insert into dbo.TableName (col1, col2, col10) values (@par1, @par2, @Par10).

Make sure to validate that non-nullable columns get feeded a value.  Then all other params can be set to null.

Why are you not storing this value in a datetime field?  You wouldn't face this, and a few hundreds other problems like this one!!

This should be a good reading for you :

http://www.sommarskog.se/dynamic_sql.html

http://www.sommarskog.se/dyn-search.html

http://www.sommarskog.se/arrays-in-sql.html

How come you don't know the columns list at run time???

One way to debug this is to use the print statement :

Print @sql

Then tweak that code untill the print...

This is the best of all 5 answers posted.  Does it answer your question or do you still need help?

Cross-posted thread.  Best answer is on this page :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=248311

Consider this thread closed.

Cross-posted thread.  Best answer is on this page :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=248311

Consider this thread closed.

Cross-posted thread.  Best answer is on this page :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=248311

Consider this thread closed.

Change the field back to int, make sure they are still indexed (if they were before).  And never let the client again decide of the DB design!

Please do not cross-post, we monitor all boards, finish this discussion here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=327358

Please consider this thread closed.

Please do not cross-post, we monitor all boards, finish this discussion here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=327358

Please consider this thread closed.

Full question has been posted here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=327358

Please consider this thread closed.

Full question has been posted here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=327358

Please consider this thread closed.

Check out the system tables, those are used all the time in the status columns.

Imagine a single column refferencing a lookup table (ok easy), but where that single column can...

What is forbiding you of using a set based solution and update all rows... or all 8 batches of rows in a single transaction ?