SQLTeam.com | Weblogs | Forums

Lotwise qty

sql2005

#1

Hie all,

I have two tables 1. Bin content - columns are location, item no., zone code, bin type , qty eg Ind , 121, Put - pick (shipping, damage etc) , put-pick , 10 .
2 warehouse entry - columns are location, item no., zone code, bin type , qty , lot no.
eg. Like above with lot no. But not mandatory means null value also there .and table content all plus minus ..adjust qty. So I want lot wise item wise ..location wise...qty which equal to qty of bin
Please suggest means sum of warehouse entry is equal to bin but lot wise and lot not equal to blank.


#2

Hello,

One more thing I am using SQL 2005 for these. Please help asap.


#3

What have you got as a query? If you select using GROUP BY this should work.
Please give example input and expected output.