I tried that, no luck. It didnt use the index when I selected just 2 columns..

Sorry, that was a typo.

This is the output I get from the execution plan:

Physical...

Thanks a lot for all your help. It worked!!!!!!!!

I appreciate it

THanks, I tried the same:

select distinct cl.table_name, field_name, t.name, inc, svalue = '(' + cl.table_name + '.' + field_name + CASE cl.hval

WHEN c1.lval THEN ' ' +

...

If it can help, we use the below in Oracle:

Decode(oper,'!=','=',oper)

But the only difference is, in Oracle the condition for m1.inc='E' is the where clause of the select statement....

Not sure if my previous message was clear. I tried using CASE for the condition. It didnt work. I think its the syntax error.

select distinct cl.table_name, field_name,t.name,inc,

svalue = '('...

Okay. Thanks.

Somehow, I found where exactly we are having problem with in the stored procedure. Below is that bit of the code:

select distinct cl.table_name, field_name,t.name,inc,

svalue = '(' + cl.table_name...

Hmm, I just downloaded the trial version of Visual Studio 2005 I dont see a debug option when I right click on the stored procedure. Is it because of the...

Oh yes, I just realized that I installed the trail version of Idera Diagnostic Manager last week. I did not use it because I found the SQL profiler was more...

Thanks a lot. This helps.

Hi all,

I am back again. Not sure if it just the application issue. We are trying to exec sp_setapprole without the encrypt option now by passing all the parameters...

But this is not executing query from the front end.. it is through the application so I have to go with the session details..

thanks

Thanks, Do you know of a site I can download the trial version of the profiler??

I tried a few, the link has expired.. Thanks again

Rbarry, This worked.

Thanks a lot!!!!!!!!!!!!!!!!!!!!!!!

I appreciate it!

Rbarry,

Thanks for your comments. It is considerably small table and this will be a one time update statement for the existing records. I think it should be fine.

Do...