Because it displays values like this:

8:50

5:0

8:10

3:0

8:0

But this format is preferable,

8:50

5:00

8:10

3:00

8:00

Thanks for your help. It was exactly what i was searching for. I realize that subtracting the break period from both starttime and endtime is the right thing to do.

I...

Thanks a lot for the help!

It works now. Actually i made a mistake. I was trying to match the id column too.

I searched in many forums, but could not find any solution. It could not be done in a single query. The only best method is to use stored procedure or...

Thanks

tableA and tableB are in separate databases. Both will have some rows in them already.

But if we set SET IDENTITY_INSERT, When inserting in tableB, if the newly picked ItemID...