[Message Deleted]

khan2010 · modified on Wednesday, October 21, 2009 2:21 PM

see ..!!! Now u are angry..You have to feel this. You have to think twise to tell some one like this " If you're incapable, I suggest you go back to your boss, hand him your keycard and tell him you are not qualified to be a developer. " OK. 1 - and by the way this is wrong answer, what kind of developer you are, each time how can user punch single product name to Check stock, There is million Productname in database. 2 - I just Give you crystal example from my first post. what is in database and what type of output i want, But you didnt understand (No Brain). Lol...I know what type of developer u are i dont need your wrong answer anymore just keep it with you. I will post correct one 2morrow. ''''''''''''

dan sh

khan786 wrote:

i just dont like the way of other helps

Well, learn from the mistakes and get over it.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

dan sh

You do not deserve to be helped. Seriously. A person who wrote code that YOU were supposed to write and instead of being grateful, you are abusing the guy.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

J4amieC

You, sir, are an anus. Your data model makes this query neigh on impossible to write any other way than that posted above. It is quite simple to adjust what I have given you to pull out the data for one particular product, but i dont remember you requesting this at all. I seriously suggest you seek employment in a less brain-intensive industry. Get used to this phrase "Big mac and fries please".

Niladri_Biswas

Try this declare @tbl1 table(productname varchar(20)) insert into @tbl1 values('abc_123a') insert into @tbl1 values('cfl_523j') insert into @tbl1 values('jpm_111k') declare @tbl2 table(productname varchar(20),purqty int) insert into @tbl2 values('abc_123a',50) insert into @tbl2 values('abc_123a',30) insert into @tbl2 values('cfl_523j',100) insert into @tbl2 values('cfl_523j',20) insert into @tbl2 values('cfl_523j',10) insert into @tbl2 values('jpm_111k',105) insert into @tbl2 values('jpm_111k',10) insert into @tbl2 values('jpm_111k',25) declare @tbl3 table(productname varchar(20),soldqty int) insert into @tbl3 values('abc_123a',10) insert into @tbl3 values('abc_123a',05) insert into @tbl3 values('cfl_523j',20) insert into @tbl3 values('cfl_523j',05) insert into @tbl3 values('cfl_523j',10) insert into @tbl3 values('jpm_111k',15) insert into @tbl3 values('jpm_111k',05) insert into @tbl3 values('jpm_111k',10) declare @tbl4 table(productname varchar(20),refqty int) insert into @tbl4 values('abc_123a',2) insert into @tbl4 values('abc_123a',6) insert into @tbl4 values('cfl_523j',4) insert into @tbl4 values('cfl_523j',3) insert into @tbl4 values('cfl_523j',9) insert into @tbl4 values('jpm_111k',3) insert into @tbl4 values('jpm_111k',8) insert into @tbl4 values('jpm_111k',2)

;with cte1 as(
select productname,sum(purqty)as purqty from @tbl2
group by productname)
,cte2 as(
select productname,sum(soldqty)as soldqty from @tbl3
group by productname)
,cte3 as(
select productname,sum(refqty)as refqty from @tbl4
group by productname)

select c1.productname,c1.purqty,c2.soldqty,c3.refqty,c1.purqty- c2.soldqty-c3.refqty as STOCK
from cte1 c1 inner join cte2 c2 on c1.productname = c2.productname
inner join cte3 c3
on c1.productname = c3.productname

Let me know in case of any concern :)

Niladri Biswas

khan2010

J4amieC This is the Correct one Still I am working On it to get some more Correct result, You Brain Less Idiot Look and think your self how u can say you are a developer, and by the way what are you doing here" "U think you can helping people" C ur self in the mirro U Idiot. and learn the manner how to speak with other. ''''''''''''''''''''''''''''''''''''''''''' Just to save time i asked question here. '''''''''''''''''''''''''''''''''''''''''' SELECT Item_Name, (SELECT SUM(Piece_No) AS Quantity FROM Purchase_Detail WHERE (Product.Item_Name = Item)) AS QuantityB, (SELECT SUM(Itm_Qty) AS Quantity FROM Detail_Description WHERE (Product.Item_Name = Item)) AS QuantityC, (SELECT SUM(Itm_Qty) AS Quantity FROM Refund_Detail WHERE (Product.Item_Name = Item_Name)) AS QuantityD, (SELECT SUM(Piece_No) AS Quantity FROM Purchase_Detail AS tblB_1 WHERE (Product.Item_Name = Item)) - (SELECT SUM(Itm_Qty) AS Quantity FROM Detail_Description AS tblC_1 WHERE (Product.Item_Name = Item)) - (SELECT SUM(Itm_Qty) AS Quantity FROM Refund_Detail AS tblD_1 WHERE (Product.Item_Name = Item_Name)) AS Total FROM Product GROUP BY Item_Name

khan2010

Thanks Nildari Biswas for Reply I appreciate for your answer. Thank you very much. But here i solved my problem please check. SELECT Item_Name, (SELECT SUM(Piece_No) AS Quantity FROM Purchase_Detail WHERE (Product.Item_Name = Item)) AS QuantityB, (SELECT SUM(Itm_Qty) AS Quantity FROM Detail_Description WHERE (Product.Item_Name = Item)) AS QuantityC, (SELECT SUM(Itm_Qty) AS Quantity FROM Refund_Detail WHERE (Product.Item_Name = Item_Name)) AS QuantityD, (SELECT SUM(Piece_No) AS Quantity FROM Purchase_Detail AS tblB_1 WHERE (Product.Item_Name = Item)) - (SELECT SUM(Itm_Qty) AS Quantity FROM Detail_Description AS tblC_1 WHERE (Product.Item_Name = Item)) - (SELECT SUM(Itm_Qty) AS Quantity FROM Refund_Detail AS tblD_1 WHERE (Product.Item_Name = Item_Name)) AS Total FROM Product GROUP BY Item_Name again Thanks for reply.

khan2010

J4amieC Moron

J4amieC

Voted & reported as Abuse

Rob Graham

You sir, are a first class jackass.