on 08-28-2015 11:52 AM
Hii, Experts.
I need one help I am having one query in which i want 'from date' and 'to date'
Here is my query please help me
-------------
SELECT T1.Code as 'Raw Material',
(select sum(T2.Quantity) from IGE1 T2 where T1.Code = T2.ItemCode ) as 'issue' ,
T0.[Code] 'Finished Goods',
(select sum(T3.Quantity) from IGN1 T3 where T0.Code = T3.ItemCode ) 'Receipt' ,
( isnull ((select sum(T2.Quantity) from IGE1 T2 where T1.Code = T2.ItemCode ),0)-
isnull ( (select sum(T3.Quantity) from IGN1 T3 where T0.Code = T3.ItemCode ),0 )
)
as ' Closing'
FROM OITT T0 INNER JOIN ITT1 T1 ON T0.[Code] = T1.[Father]
-----------------------
Thank you in advance
Hii,
I want date which should applicable for both received or issued .
whatever the date range i ll give it should take data from both table within that date range only .
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please help me ...
Thank you
Neelima
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.