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?
Code:
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