The approach to this issue was to add a trigger to the table wherein these values are getting inserted, and once this values are inserted, Build up the view (...

Thanks Joe for you kind sarcastic words, I am doing my bit by explaining a scenario which is there in our systems and redefining those which is totally not under...

His error lies in the 1st statement itself; since he is trying to reference a column comparison in the IF statement.

I am assuming he wants to check if the column...

I was pretty much clear to what i was trying to point at.! This was something which I observed in one of our older procs while retuning them and was...

@sturner :

I totally understand that the query is not going to yield me proper results since it is a string of UID's and IN is the way to...

@Dixie is right( Because in your first case the where clause is stripped down to remove the column name totally)

I dont think you will be able to use column names...

@Nevyn: The reason I have a CASE statement since this...

@getoffmyfoot

Even after considering various scenario's i was not very confident in both the queries performing the same tasks( Or maybe they are). I was replacing the logic...