Thank you for your reply. with prod_id it was just a copy paste mistake.

thanks for the reply...please see below..problem with value fields, segregated but still same error

thanks for the reply, here is the query, problem is in value fields, segregated in 3 fields but still getting the same error...

thank a million for looking at my query. I understood the logic you said.

I tried your way but I am still getting the error cant convert varchar 12.8 to datatype...

here it is, please ignore the bracket errors/syntax, main concern is fields --(value, t.result, result on) please helpppp !!!!

hi everyone ,request your help urgently.

Conversion failed when converting the varchar value '12.80' to data type int. I checked all the datatypes in my procedure

thanks for your help.

thanks for your reply sandippani.

Thanks so much Wayne for replying. I am reading more about CTEs now. thanks

Thank you Grant. It was a totally new perspective with oracle/SQL crossover. thanks,

Thank you Craig. As Wayne said, very well defined. thanks.

Thank you Wayne, I am thinking why do we use temp table in the first place? As soon as you see a problem how you decide you need to use...

Thanks so much Grant. I have a silly question. when do you actually know when to use temp table concept in the first place, I mean if you look at...

Thanks Wayne, Mtillman , Geaorge and everyone who responded to my post. Its such a great learning with you gurus. I am new here and I am practicing using temp...