>I have another brain freeze
>I know the beginning year and month and the ending year and month (all integers)
>I want to write a query that returns all rows with inv_dates between those months and years.
>All graciously accepted.

WHERE inv_dates 
  BETWEEN CONVERT(DATETIME,CAST(@fromyear AS VARCHAR(4))+'-'+CAST(@frommonth AS VARCHAR(2))+'-01',120) AND 
                  DATEADD(m,1,CONVERT(DATETIME,CAST(@toyear AS VARCHAR(4))+'-'+CAST(@tomonth AS VARCHAR(2))+'-01',120))-1

MartinaJ