damcguire (1/31/2014)
This syntax works fine to create the table, insert the data, and delete it... but will not work against my actual db field/data. Syntax I used and errors above were copied. Maybe there's somekind of constraint on the db that I'm not aware of. Fwiw, I had asked the software vendor's developers to delete similar data some time ago, and they were not able to. Thanks for trying to help!
So post the ddl to create your table. Since we don't know your datatypes we are guessing.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/