SELECT * FROM dbo.FAT WHERE Data BETWEEN CAST(@anno AS char(4)) + '0101' AND CAST(@anno AS char(4)) + '1231 23:59:59.997';