santa326 (7/2/2015)
Hi All ,I got answer to my query but ran into another problem.
I am not able to Add rCTE to a Temp Table.
and Every Part has a DocID how do i fetch it .
Regards
Ravi T
Getting the data into a temp table is easy. The last part of the provided query should just be:
SELECT *
INTO #TempTableNameGoesHere
FROM rCTE
ORDER BY Item_NO ASC
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)