Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. INSERT INTO tbl_ItemReturnMaster (FromTo_Type_Id, From_Id, To_Id,ReturnedDate,StatusId,UserId,Reason,DateUpdated,PharmaReturnID)
  2. SELECT FromTo_TypeId,From_Id,To_Id,ReturnDate,StatusId,UserId,Reason,DateUpdated,PharmaReturnID
  3. FROM tbl_InternalItemReturns group by ReturnBatchID,From_Id
  4.  
  5. select ReturnBatchID,From_Id from tbl_InternalItemReturns
  6.  
  7. group by ReturnBatchID,
  8. From_Id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement