Gus, that may have just revolutionized how I handle those types of situations from this point on. I took your example and put together a quick proof of concept aspx...

To be more precise and maybe add a little clarity to what i was trying to convey...

select 'Update ' + so.name + ' set trm_cde = ''S'' where trm_cde in...

You could change the from in my previous post to

from sysobjects so

join syscolumns sc on so.id = sc.id

where sc.name = 'trm_cde'

and so.xtype = 'U'

That would get you a list...

You could create your stored procedure to do the insert for only 1 row and then call it however many times you need to.

Given that you have a table that lists all the tables that have this column (assuming the column trm_cde is identically named in all of them). A slight modification to...

You got it. Of course if this list expands you may end up kicking yourself as this list gets longer and longer. This approach is the simplest but it is...

Pink123 (3/4/2011)

---

There are 13 choices available out of which user can select may be 1 or 2 or 3 or may be all 13.

So the description parameters will depend on...

This is very common scenario. You have a couple choices. You can either run dynamic sql or parse the values. Given the pretty common appearance of your string you might...

You can alternately use the IDENT_CURRENT('your table name here')

Is there a max of 13 descriptions or is the number of descriptions dynamic?

Sharon Kumar (3/3/2011)

---

Hi this is table values

Investigation_IdCase_IdInvestigation_NoteDateTimeTeam_IdStatus_Id

31101050282Testing Testing Testing 2011-01-26 11:45:00.000 2 1

51101050282sample 2011-01-26 00:00:00.000...

Sharon Kumar (3/3/2011)

---

Hi all

I had a table columns with

sno Name Case Datetime ...

Depends on what you need. Is this code you are trying to reuse? I have no idea what the business rules are or what the data looks like. Maybe TemplateGroup?...

Or you could do an "update from" too. Not really sure what you are trying to do but there are lots of ways to do this.

Not sure exactly what you mean but you can do...