lakb200 (12/17/2009)
can you partition onnvarchar column with values mm/dd/yyyy.
Wait just a sec. An nvarchar column with a date in it? Why nvarchar and not datetime? If it's a date, it should be stored as datetime.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability