thanks Steve,, i am so dumb 🙁

ok,, lets change the requirement a little bit

instead of two tables lets use one but include date columns

so i have guid and date

every on has at least one record and...

I am collecting some patient data based on some unique survey,, a patient might report many side effects ,, i am calling these side effects observations ,, i want to...

Using a cursor is slowing down the database to a crawl?

Thank you Steve.

I am not getting the desired results still. Let me go over what I want so you have better idea.

remsae1,remsae2,remsae3,remsae4,remsae5 can have one of the following values

C,H and...

Thanks for your help.

Here is I am at for now

DECLARE patt CURSOR

FOR

select distinct column_name, table_name from information_schema.columns

where column_name like '%patt' and table_name like 'drugs%'

OPEN patt

DECLARE @tablename as varchar(15)

DECLARE @Patt...

Both solutions worked just fine,, thanks a bunch for your help.

just to update u Steve,, following works ,, as long as i dont try to convert @QuestDate to smalldatetime it works fine,, i dont know why? actual type of questdat...

Thanks Steve,, i think i almost got it ,,, i have the following trigger and getting this error message when i trigger it with sample data ,,, i am sure...

Steve,, it does not give me any syntax error if i have just this

SELECT @cmd = 'UPDATE ' + @Table + ' SET ' + @Variable...

I am trying something like this but getting syntax erros ?

CASE @DataType

WHEN 'INT' THEN SELECT @cmd = 'UPDATE ' + @Table + ' SET ' +...

Thanks,, is there a simple way to tell if a given variable/column need quotes or it does not --- or do i have to check all data types as in...

one more byte of help

How would I make something like that

select @cmd = 'update ' + @targettable + ' set ' + @variable + ' = cast( ' + @value...

Steve,,, when i try that to find Variable 'DOB' -- i get 5 answeres. It pulls out DOB from Tables, Views etc... is there a way to limit the answers...