Automatic Task to rearrange data from one table into another (SQL or VBS?)

Question

Post reply

Automatic Task to rearrange data from one table into another (SQL or VBS?)

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

SteffenW SSC Enthusiast Points: 172 More actions · Answer 1

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

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 2

SteffenW (2/17/2012)
and well I'm running SQL in a German enviroment so Date is like: DD.MM.YYYY

I guessed something like that so formatted the dates you provided to meet my date format. 🙂

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

SteffenW SSC Enthusiast Points: 172 More actions · Answer 3

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 article about the tally table you gave me, David... I'll read up on that

I'd probalby put the tally table inside my Database on the server than in the master (there are other databases running as well)

David Benoit SSC-Dedicated Points: 34562 More actions · Answer 4

Once you use a Tally table you will want it around for other uses as well which is why master is recommended. They're pretty handy.

David

@SQLTentmaker

“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

SteffenW SSC Enthusiast Points: 172 More actions · Answer 5

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

thanks so far for the solutions and new ideas!!

SteffenW SSC Enthusiast Points: 172 More actions · Answer 6

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... 😉

SteffenW SSC Enthusiast Points: 172 More actions · Answer 7

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 everything works as I wished for :)))

thank you!!