hi All,
I need to write a query taht can compare data from 1 table.
Basically, every morning, the SQL server generates 100 different reports and publish it. I need to know for each date, which file is publish last. Since the files is diffferent in size, so file1 coould be last for today while file 2 can be last the next day.
For ex:
Filename, publish datetime
file1, 1/1/01 7am
file1, 1/2/01 8am
file1, 1/3/01 9am
file2, 1/1/01 10am
file2, 1/2/01 7am
file2, 1/3/01 5am
Thanks
I need to write a query taht can compare data from 1 table.
Basically, every morning, the SQL server generates 100 different reports and publish it. I need to know for each date, which file is publish last. Since the files is diffferent in size, so file1 coould be last for today while file 2 can be last the next day.
For ex:
Filename, publish datetime
file1, 1/1/01 7am
file1, 1/2/01 8am
file1, 1/3/01 9am
file2, 1/1/01 10am
file2, 1/2/01 7am
file2, 1/3/01 5am
Thanks