ALTER PROCEDURE [dbo].[sp_Fuel_getFuelSurcharge]

	@ShippedLo smalldatetime = '10/10/2008',
	@ShippedHi smalldatetime = '10/20/2008'

AS
BEGIN

	SELECT fscco as [Fuel Tariff], avgfuel as [Average Fuel], eff as [Effective Date],
		pct as [Fuel Surcharge], cents as [Cents], monday as [Monday],
		CAST(SUBSTRING(eff,1,4) as numeric) as [Year], 
		CAST(SUBSTRING(eff,5,2) as numeric) as [Month], 
		CAST(SUBSTRING(eff,7,2) as numeric) as [Day]
	FROM fuel
	WHERE
		monday >= CONVERT(smalldatetime,@ShippedLo,112) AND 
		monday <= CONVERT(smalldatetime,@ShippedHi,112)
	
	END

quote:

---

Originally posted by GilaMonster

What datatype in 'monday' in that table?

--
Gail Shaw
SQL Server MVP

---