MMartin1 (5/6/2015)

---

I assume the tables are used directly instead of a view. Later, you could possibly add a view that combines date and time columns as one value. Any future...

Thank you .will definitely give this a try

This would be in Mountain Standard Time (MST)

Thank you

Ohk .Thanks.

If it makes sense that way,how do I do the math to convert say a 8.00 AM (from 'Time' column in csv file) to seconds after midnight in SQL...

This is the first time I am hearing of any such thing!!!!.

But if it is so...then 82860 is closer to the midnight and usually, no transactions occur at that time

In one of the tables I am looking at :

MAX Value: 82860

MIN Value : 24480

To elaborate a little :

My current task is to append a csv file (sent by another dept) to existing tables in sql server.

One of the column in the SQL...

Thank u.

It now works with 2012 management studio