sharonsql2013 (8/23/2013)
Yes , Prod year is int.
What about ProdMonth? We'll need that info to identify rows that are a year old. And, because you only have Year and Month data, it's going to be impossible to figure out what rows are available in terms of 365 days.
--Jeff Moden
Change is inevitable... Change for the better is not.