Cacher is the code snippet organizer for pro developers

			
			
Declare @WarehouseID as Float			
set @WarehouseID = 157  /*  <--- Enter the warehouseID Being looked over */			
			
			
			
			
Select			
			
		Adj.StockAdjustmentFromWhse as Whse			
		,IT.category			
		,Adj.StockItem			
		,Adj.StockAdjustmentQty			
		,Adj.StockAdjustmentCost			
		,Adj.StockAdjustmentAdjustType as AdjustmentType			
		,Adj.StockAdjustmentSalesman as [User]			
		,Adj.StockAdjustmentComment as Comment			
		,Adj.StockAdjustmentReceived as [DateTime Adjustment]			
From gxWizmo_24..STOCKADJUSTMENT Adj			
		LEft Join product_10..LU_Item IT	
			on Adj.StockItem = IT.Item
Where Adj.StockAdjustmentReceived >= '2015-08-01'	 --<-- Enter Date Range		
and Adj.StockAdjustmentFromWhse = @WarehouseID