can you please do as asked
Neeraj Dwivedi (5/6/2013)
Also I need data in the form of script where I can insert that in my environment without writing the code.
the times in your spreadsheet seem a bit "odd".
Time_In
1899-12-30 07:47:00.000
1899-12-30 10:32:00.000
1753-01-01 12:01:00.000
1753-01-01 12:01:00.000
1899-12-30 13:52:00.000
......if you provide some create table scripts and data insert scripts that can be used in SSMS, then I am sure that you will get a fast and tested answer.
I don't think that to keep referring to a spreadsheet is going to help.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day