You could try something like this

select ph.PolId, 
       case when isnull(pa_est.est_count, 0)>0 
       ...

He means "Readily Consumable" data.  Please see the article at the...

Thank you Steve!

This query also works from logic perspective

Cheers!

Thank you so much Scott, you saved my day!

Sorry for the late reply as this was the part of the main SQL and I was testing this with live data...

Try this -

INSERT INTO [testing] (sometext) VALUES ('some junk')

UPDATE testing SET idcopied = SCOPE_IDENTITY()

WHERE tid = SCOPE_IDENTITY()

And yes GilaMonster has a valid question - Why you need to do...

Thanks for the reply. I will post other details very soon. But because of confidentiality I can not post the exact query but will send few parts of the query.