CREATE PROCEDURE GetDataForRange(
    @myDatePart datepart
  , number int
) AS
SELECT * FROM Table1 T 
WHERE T.Date BETWEEN GETDATE() 
  AND DATEADD(@myDatePart, number, GETDATE())

DECLARE @Yak TABLE (Date DATETIME)

INSERT @Yak
SELECT GETDATE()
UNION ALL SELECT GETDATE() + 1
UNION ALL SELECT GETDATE() + 3
UNION ALL SELECT GETDATE() + 12
UNION ALL SELECT GETDATE() + 47
UNION ALL SELECT GETDATE() + 93


DECLARE @DatePart VARCHAR(10)
DECLARE @Number INT

SET @DatePart = 'WEEK'
SET @Number = 10

SELECT *
FROM @Yak
WHERE Date BETWEEN GETDATE() AND 
	CASE 
		WHEN @DatePart = 'SECOND' THEN DATEADD(SECOND, @Number, GETDATE())
		WHEN @DatePart = 'MINUTE' THEN DATEADD(MINUTE, @Number, GETDATE())
		WHEN @DatePart = 'HOUR' THEN DATEADD(HOUR, @Number, GETDATE())
		WHEN @DatePart = 'DAY' THEN DATEADD(DAY, @Number, GETDATE())
		WHEN @DatePart = 'WEEK' THEN DATEADD(WEEK, @Number, GETDATE())
		WHEN @DatePart = 'MONTH' THEN DATEADD(MONTH, @Number, GETDATE())
		WHEN @DatePart = 'YEAR' THEN DATEADD(YEAR, @Number, GETDATE())
		ELSE DATEADD(DAY, @Number, GETDATE())
	END

quote:

---

Originally posted by echovault

Thanks for the reply, Lamprey. I always appreciate the insight of an Aged Yak Warrior.

I understand that I can write a case statement on a varchar variable. What I'm really looking for is some discussion on this elusive 'datatype' and whether it can be captured by a developer in and of itself. If this is not the proper forum for this dicussion, please let me know.

---