Comments by Member 12200213 (Top 2 by date)

Member 12200213 16-Dec-15 2:26am View

Hi,
I have modified like below
where(t1.overallqty-(isnull(t2.shipqty,0)+isnull(t2.airqty,0))>=0
now its working fine.

Member 12200213 15-Dec-15 8:43am View

Hi,
your query is working. but if the air qty value is zero system is not fetching that particular line
if the values both ship and air present then only output showing suppose if anyone is not there its not displaying

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid