We had a similar problem at our company where the entire SQL block was generated with a massive IN-list before being executed. Execution of the code would take forever and...

As Sean already mentioned: we need more information in order to provide useful advice. As the procedure is now, the parameters aren't used anywhere so there wouldn't be a difference...

The running time is because of the functions. You could put the function logic in the main query for better performance but you would be sacrificing readibility.

The arithmic overflow error...

Here are the function definitions that were missing in my previous post. Perhaps it can be of use.

The extra information about the table isn't any help to me. I still...

You are completely right. The function definition isn't included because I am not able to post them. For some reason it keeps timing out if I try to post or...

Well, I gave it a go. I used the sample data in the post to create two functions to convert time to seconds and the other way around to convert...

Hugo Kornelis (12/12/2012)

antony-688446 (12/11/2012)

Being pedantic,...

antony-688446 (12/11/2012)

Being pedantic, GROUPING_ID came...

You could use Phil's suggested query as a subquery. This lets you add as many CASE statements with as many WHEN statements as you want and it lets you filter...

I have to agree that the safest way to verify a backup is by actually restoring it somewhere. If this is not possible or you are looking for a way...