Cacher is the code snippet organizer for pro developers

-- DW Out - By Warehouse, Category, Calendar Week
				
SELECT LEFT(d.Cal_week,4) [Year]
	  ,RIGHT(d.cal_week,2) [week]						
       ,TransferDetailLineFromWhse From_Whse		
       ,TransferDetailLineToWhse To_Whse
       ,isnull(cg.GroupName, 'Other')  CategoryGroup						
	   ,IT.category
       ,a.StockItem
       ,-a.TransferDetailLineQty Transfer_Qty
       ,a.transferdetaillinecost Unit_Cost
    
   FROM   gxwizmo_24..transferdetail a 						
       INNER JOIN gxwizmo_24..transfer b 						
         ON a.transferid = b.transferid						
       JOIN misc_10.dbo.LU_DATE D						
		 ON  cast(left(b.TransferIssuedDate,11) as smalldatetime) = d.cal_DATE				
	   LEFT JOIN product_10..lu_item it					
	     ON a.StockItem = it.item					
	   LEFT JOIN product_10..CategoryGroup cg					
		 ON it.category = cg.Category				
WHERE  a.TransferID = 3421407