Wanted to calculate number of days on vacation? or you want to break it down by months? Solution for 2005/2008 using WITH CTE: create table TBL_Vacation ( Name varchar ( 10 ) , DateFrom smalldatetime , DateTo smalldatetime ) insert into TBL_Vacation select...
this is something every DBA should know by heart. I mean, everyone. running query: [DBCC USEROPTIONS] Returns following options each DBA can set on current database that will be affected globaly: 1. textsize 2. language 3. dateformat 4. datefirst 5. lock_timeout...