Viewing 2 posts - 1 through 2 (of 2 total)
i guess i misunderstood what you were after. i assumed that your date was a date entered, date created, or some such, where the range of allowable values is bounded....
April 3, 2003 at 4:09 pm
#453110
you're using the IN operator in your check constrainst which apparently is not allowed for partitioned views. from BOL:
"The CHECK constraints can only use these operators: BETWEEN, AND, OR,...
April 3, 2003 at 12:25 pm
#453085