I need to create a stored procedure with this code. I cannot figure out why the code will not execute inside the stored procedure.
Code:
WITH temp_orgChart (dwgno, part, item, dim1, dim2, um, qty, iteration) AS
(
SELECT dwgno, part, item, dim1, dim2, um, convert(int, qty), 0
FROM dbo.bomlog WHERE dwgno = 'tp134ae'

UNION ALL SELECT b.dwgno, b.part, b.item, b.dim1, b.dim2, b.um, convert(int, b.qty) * convert(int, a.qty), a.iteration + 1

FROM temp_orgChart AS a, dbo.bomlog AS b
WHERE a.part = b.dwgno

)

SELECT dwgno, part, item, dim1, dim2, um, qty
FROM temp_Orgchart
WHERE um = 'si' OR um = 'in' or um = '"' or um = '"2'
ORDER BY dwgno, part