select A.part, Sum(A.Qty) - Sum(B.Qty)

from parts A,

parts B

where A.part = B.Part

A.Part = 'A'

A.locationTo = B.locationFrom

A.locationTo = 1

group by A.part,B.part

quote:

---

I need help with a complex SQL...

Hi,

You could create a loop using following syntax

While (your condition)

begin

Execution code

end

quote:

---

I have been successful in creating a sql that will allow...

Hi hari,

hope this solves your problem:

declare @x money

set @x = 13445

select convert(char(10),@x,1)

Output is: 13,445.00

quote:

---

How can i write 13445 as 13,445...