|
|
Posted by estesiquevale on 05/07/07 08:33
hello,
I have a table like this:
thing, size, color, type_mov, vary
1, s, red, sell, 1
1, s, red, buy, 2
1, m, green, return, 10
....
and the question is how I can see the total number of products by size
and color having in mind that some type of movement are + and other
are -.
in other words, like stock control.
how I can control this in sql server?
code, procedures?
thanks!
Navigation:
[Reply to this message]
|