6 replies to this topic

[cornclose]

[V70Ben]

[cornclose]

Another fail...

	IF @RodSku = 1
  	BEGIN -- Find a silo with same coffee type or same committed coffee type and within the time allowed and same roasted on date
			SET @RowCount = 0
		SELECT @VesselID = VesselID FROM VesselViewROD WHERE VesselClass = @DestClass AND VesselGroup = @DestGroup AND 
				CommittedCoffeeID = @CoffeeID AND CommittedNISID = @NISID AND (InService=1 OR InService=3) 
				AND MaxVolume > (Volume + CommittedVolume + @EstimatedVolume) AND (GetDate() < DATEADD(hh,@SiloInCloseTime,FirstCycleInStamptime) OR FirstCycleInStamptime Is Null)
				AND (CoffeeID = 'EMPTY' OR CONVERT(VARCHAR(12), GetDate(),101) = RoastedOnDate)
			SET @RowCount = @@RowCount
		END
		IF @RowCount = 0
		BEGIN
	   	SELECT @VesselID = VesselID FROM RoastedBeanVessel WHERE VesselClass = @DestClass AND VesselGroup = @DestGroup AND
				CoffeeID = 'EMPTY' AND CommittedCoffeeID = 'EMPTY' AND (InService = 1 OR InService = 3)
				ORDER BY MaxVolume, VesselID DESC
			IF @@RowCount = 0
	  BEGIN
		  SELECT @Fail = 1
		  SELECT @ReturnVal = 16  /* No Destination */
		END
	  END

[T5-Andy]

Best place for 'em   

Attached Thumbnails

• 

Edited by Lord B, 24 May 2010 - 19:23 .
silly sized picture

[cornclose]

Where are the other two ?  

[T5-Andy]

They heard Alastair Campbell was on the grill;

[cornclose]

So what is the adjective ?