Hi,

this might be crude and ugle but it'll deliver what you're asking for...

[font="Courier New"]DECLARE @STARTWEEK INT

DECLARE @ENDWEEK INT

SELECT @STARTWEEK = 37 -- Your Start Week

SELECT @ENDWEEK = 39 ...