Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
landau66
Yak Posting Veteran
61 Posts |
 Posted - 2014-01-18 : 11:45:50
|
| Hi everyone,I have a table where the Primary Key is of datatype DATE. This column is also a clustered index. Since not every day is in this column i am looking for a way to address a date one ( or two, or three) Dates before a given date. Something like:select * from myTablewhere [date] = one record previous to record where date = '22-05-2000'How is that possible.Thank you very much in advancelandau |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
|
|
|
|
|
Datatype 'Date' as clustered Index - next,previous