Cacher is the code snippet organizer for pro developers

SELECT LEFT(d.Cal_week,4) [Year]
	,RIGHT(d.cal_week,2) [week]						
    ,a.TransferID
	,b.TransferIssueBy
	,TransferDetailLineFromWhse From_Whse		
    ,TransferDetailLineToWhse To_Whse
    ,isnull(cg.GroupName, 'Other')  CategoryGroup						
	,IT.category
    ,a.StockItem
    ,-a.TransferDetailLineQty Transfer_Qty
    ,a.transferdetaillinecost Unit_Cost
	,-a.TransferDetailLineQty * a.transferdetaillinecost Total_Cost    
	,b.TransferCancelDate 
	,b.TransferIssuedDate
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 1=1
	AND b.TransferCancelDate = '1753-01-01 00:00:00.000' -- Exclude Cancelled Transfers
	AND TransferDetailLineFromWhse = 43
	AND a.TransferID >= 3480964