error in calculation in SP 1

[Hueby]

I'm using this in my SP. But it throw a error "Invalid column name 'taxprice'." The taxprice works fine, but when I try to do the total is throws the error. I guess I can not do what I am trying to do?

ROUND(CAST((1+(.06))*(tbl_products.pprice)as Decimal (10,2)),2) as taxprice,
ROUND(CAST((1+(.02))*((taxprice)*(tbl_material_used.mqty))as Decimal (10,2)),2) as total

 

[SQLSister]

YOu have to repeat the whole formula there, it won;t accept the alias.

Questions about posting. See faq183-874

 

[Hueby]

How would I do that, I'm not understanding?

 

[rp1504]

ROUND(CAST((1+(.06))*(tbl_products.pprice)as Decimal (10,2)),2) as taxprice,
ROUND(CAST((1+(.02))*(((1+(.06))*(tbl_products.pprice))*(tbl_material_used.mqty))as Decimal (10,2)),2) as total

 

[Hueby]

OHHHHHHHHHHHH!!! Duh.. I feel dumb now. Thank you soo much everyone.