That looks about right.

You had a valid insert above, just add the primarykey column that you are now adding and you should be good to go.

njdevils39 (3/8/2011)

---

Basically I have to write a stored procedure using dynamic sql

to

update the slxhrscreentemplates table in version5_sales

with the information from the

slxhrscreentemplates in version500

I have 4 parameters:

1. source Database =...

Look at the example above, there is no subselect. Short of putting in your column names I coded it for you. 🙂

The Row_Number function creates a new column.

select Row_Number() over(order by someColumn) as myRowCount

, othercolumns here

from mytable

take a look at the Row_Number function on bol. It will get you exactly what you need.

that will work fine as long as the column exists. I put the exists check in to make sure they exist per your requirements.

...need to delete the columns in the...

this should get you close. Just have to repeat each column you want to drop

if exists(

select * from syscolumns

where id = OBJECT_ID('table name')

and name = 'column name'

)

alter table [table...

Please don't cross post. The original thread is here

This is better. It will directly get you the datatype name.

select t.name, sc.* from sysobjects so

join syscolumns sc on sc.id = so.id

join systypes t on t.xtype = sc.xtype

where so.name =...

Of course there really isn't a max length on System.String in .net. Well there is but it is totally huge. You are now trying to get the field size of...

Sounds like regional settings but you said you double checked them.

what is the result from:

select CAST('2011-03-08 00:00:00' as datetime)

That looks like the columns are fixed length. Try looking at rtrim function.

Keep in mind that we can't see your screen and we are not familiar with your project. I still have no idea what you are trying to do here.

One quick...

What is the question here?