Thanks for all the help!!

I found the problem was that it wanted me explicitly to cast everything to a varchar. I hadn't been because everything I had read told...

I think the main diffrence is that my values are being passed into a stored procedure instead of being declared. That wouldn't cause my errors.

I just got off lunch...

I think I've made some progress.

Here's a sample.

set @cmd= 'INSERT INTO '+@myTable+' (ID, Date, Name) VALUES ( '+cast(@ID as varchar)+','''+convert(Varchar, @Date)+''','''+@Name+''')'

I'm using the same format of quotes for...

I've changed the exec string to the format in the previous post.

I am now getting the error: Syntax error converting the varchar value ' ',' ' to column...

I have tried that, without success. It will also be passed in with the @name and other paramaters, so redefining it shouldn't be nessicary. I am pretty sure...