Works perfect, thanks Scott!!

OK, from my understaning I should to this instead, not really sure though. Otherwise I would be glad with some input! 🙂

--===== If the test table already exists, drop it

IF...

• This reply was modified 1 year, 12 months ago by  pelusch.
• This reply was modified 1 year, 12 months ago by  pelusch.

OK, I will try to make this clear. The dates in my tables have timestamps including milliseconds which makes it almost impossible that one date in Table A would get...

In the beginning - I wanted to get a understanding of the basic principle, but the more I work with it I face a significant problem.

Example: For the Customer 1...

Works perfectly, thanks! If I want to make this code work as a subquery - is it possible?

Thanks, works fine!

But.... I realized that I want to do a group by on departments below - is this possible? See additional column in Table A. I didn't manage to...