No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
You can put the Convert into the join expression to evaluate simply based on the day instead of the day-time initiallly represented by a smalldatetime value... Declare @Dateparm smalldatetime Set @dateparm = '1/2/2005'Select @dateparm ---versus Select Convert(char(10), @dateparm, 101)
Thanks for the reply KIK....we currently have this in place with one LUN for data and another for backups -- just wanted to make it a bit easier to manage. Adding another LUN would basically make it two drives for data -- nothing wrong with that, just managing it becomes a pain. Pretty much everything […]