if the amount of data to be vaidated is large, is it recommended to use the dll for validation or the sp's?

Thanks,

SSM

I tried that but my query is like

declare @filename varchar(30)

set @filename = 'abcd.txt'

There is row in table where filepattern = 'ab%.%'

select fileid from dbo.table1 where @filename like filepattern

if my variable...

It was my bad!!!The data was getting inserted,I was not able to see anything in column in the EM.When I used query analyser I saw data in the column.

Thanks all...

Thanks,I will try that out.

thanks,ssm

This is basically what I want

All rows from v_formulary_status_drug_label_assoc_detail_3 and all rows from v_formulary_status_drug_label_assoc_detail_2 which do not exist in v_formulary_status_drug_label_assoc_detail_3.

phew..found the issue.

The cursor_close_on_commit was set on the server and not in my machine.That was why it executed fine from my machine but did not from the server.

Thanks.

Thanks.I can actually execute the same sp from the query anlyser from my machine pointing to the dev server without any error but the same sp throws an error when...

thanks.I tried that but still getting the error.

I get the error when I use any DML statement inside the cursor loop.doe the cursor close on any dml statement?

Thanks,

SSM