Viewing 2 posts - 1 through 2 (of 2 total)
Hi Jeff,
The reason for this report and data present this way are for account department audit analysis, which have keep the track of the inventory flow in and out....
November 27, 2009 at 12:45 pm
#1085012
Thank you all for imput...this is what I have so far.
--BUILD DATA TO USED
IF OBJECT_ID('tempdb..#tmptb1','U') IS NOT NULL
drop table #tmptb1
select identity (int, 1,1) ID, prodid,tranid, qty into #tmptb1 from...
November 27, 2009 at 9:50 am
#1084971