THANKS A MILLION!!

thank you bteraberry and David

Your scripts with the Tally Table worked great... First I had to manipulate my Input Date so it fits for the script but now...

well but considering thats a company server and the admins a more comfordable when I only mess with one database I'll probably only use it there... 😉

ok I'll put something together tomorrow and will report back!!

thanks so far for the solutions and new ideas!!

well but I could just calculate the total difference on the Input with an sql statement... well that would then combined with your solutions help me!!

have to check on the...

and well I'm running SQL in a German enviroment so Date is like: DD.MM.YYYY

ok I haven't checked your complete code yet, especially the point with the extra table in the db-master...

I know of the reluctant data but well the output gives me no...

Ok as David suggested I've put together a create skript to give you the sample Data

This is a Table with employee vacation Dates where the start and End-Date are specified...

stupid... was confused because we're already on page 2

I'll put a CREATE skript together 😉

Well yes...reading Forum etiquette first would help *darn 😉

I'll be back in a bit

well the SourceTXT is coming as an export from an propritary programm so I can't change anything there.

The way I thought it would work:

1. Import the txt File into a...

OK let's close this one here... just figured it's the Server 2008 section... running 2005 at the moment ^^

well if some VB-Enthusiast is klicking by I'd be grateful for...

Ok Importing is no Problem

but I need to do the calculations as specified at the top

the import gives me only the start and end date of vacations, but I...

I'll give it a try and will report back... haven't tested the wizard so far

Thanks