Thanks I was able to combine a couple of the suggestions and come up with a good solution.

Thanks for all the suggestions I was able to figure this out with a combination of a couple of the examples.

Yes the source table for this data does include a clock in and clock out time but I could not use thoses fields in the calculation since there are several...

This is awesome! Thank everyone so much for the help. I tried it against my sample data and it worked perfectly. When I ran it against a...

Excellent advice. Thanks for the suggestion I edited my original post to include the table code and data.

Thanks

Thanks very much, that's what I suspected but wanted to confirm before moving ahead with it.

No there are actually about 10 users but for the example I only included these three. The same for application would apply, in fact there are around 15 different...

Thanks for the link it will give me some good reading before jumping into this project.

Yes that's one of the reasons I want move off of SQL Server...

In the past when I have needed to do this I used a script like this to generate the delete statements so that I would be able to review exactly...

Good question. The comp manager field just means they can manage salaries so for example some managers don't do salary stuff while others can so for example what...

You're bang on. Thanks, I added the field names to a template file and it works perfect now. Thanks very much.

That looks like what it was I didn't even notice that I had cerated the variables outside of the package scope. Thanks.

I guess where this came from was a user group wanting to purchase a server license with a limited number user CAL's (20). Personally I think this is much...

If you are not moving the primary data file you can create another file in the same file group and then use the DBCC SHRINKFILE (filename, EMPTYFILE) command. This...

Also ensure the appropriate protocols are enabled. You can check these using the SQL Server configuration Manager under SQL Server 2005 Network Configuration.....Protocols for MSSQLSERVER.