2
Reply

Need help in Sql Query

Ravi Shekhar

Ravi Shekhar

Oct 17 2013 3:26 AM
906

Please find attached excel for sql server table data.  I wrote the below query


select distinct WP.PickListNo,WP.OrderNo,WP.ArtNo,WP.Destination,WP.Size,WP.Source,WP.Concept,wp.Status,WP.Category,WP.slotcode,
WP.ActualQty,isnull(WP.ToPicked,0) ToPicked,isnull(WP.PickedQty,0) PickedQty,isnull(WP.LoadQty,0) LoadQty,Picker ,PickListCreatedOn,isnull(convert(varchar,PickingOn,120),'Not Picked Yet') PickingOn,
isnull(convert(varchar,LoadedOn,120),'Not Loaded Yet') LoadedOn
 from wms_picking WP where CONVERT(datetime,CONVERT(varchar,PickListCreatedOn,101)) between
  CONVERT(datetime,CONVERT(varchar,'2013-05-22',101)) and CONVERT(datetime,CONVERT(varchar,'2013-05-22',101))
 

I need result distinct picklistno with there sizes 070/060 in single single row article wise.

NEED HELP.........

Attachment: sample.rar

Answers (2)