I edited the post sorry my English not good.

Sorry edited ...

I need if VAL42 ( value ) greater then 0 then run first update query and if VAL42 (value) is equal to 0 then...

Hi

How to do this?

Many thank Gila & Stefan Krzywicki.

By using inner join the issue is solved.

Regards

Hi

Thank you

I removed the join hint form the statement by replacing below. The application having no breaking or fault.

1.

2.

FROM...

Thanks for correction is there way to by pass this error. Because one of the application showing no data when getting this warning on the prompt?

Warning: The join order has...

Thank you David it works for me.

Hi David,

Will you please summarize more how to do that?

Hi SS

Actually the problem is e.g Some times the Val2 is not calculated by meters,but the VAL1 calculates every day in rare case Val1 not calculated, that is why...

Hi SS

Actually the problem is e.g Some times the Val2 is not calculated by meters,but the VAL1 calculates every day in rare case Val1 not calculated, that is why...

Thank you SS ...

your Kind help

Hi

Please Below the query i need to use condition

I need to use in below query how to use

Hi SS

Thanks ! but how to apply in one sql query ?

Jeff,

Actually very sorry to say i dont find any notification from notifications@sqlservercentral.com. I tried 12 hours my self and now i have done.

Thank you 😀 you helped me...

Yes you correct my start week from thrusay and end on wednesday...