Sorry I apologise for not making much sense, I'm a sql developer / accidental dba not much experience in partitioning...

Essentially we had to change a data type of a column...

We raised a ticket with our support team however they are saying the database hasnt been backing up since 23rd October (obviously this will be dealt with seperately) due to...

WOW!

Ok so a little more background, the DDL was just a made up example that I thought if cracked would provide the solution to my real dataset.

Thought being the definative...

Wow thanks Dwain (and Itzik Ben-Gan) worked an absoulate treat 🙂

Just to demontrate that it worked with multiple employees I've slightly tweaked it but all in all fantastic, I shall...

Sorry,... just to be clear on what I would expect, if I run for 1 employee this is what I get:

Load Table

850107:13:1307:18:04

950107:13:1307:13:26

1050108:35:5608:36:20

1150108:35:5609:00:00

1250114:08:0818:30:26

1250115:45:2518:30:32

Combined Result

50107:13:1307:18:04

50108:35:5609:00:00

50114:08:0818:30:32

When run for more than 1 employee these...

Morning,

Apologies if there is a rule of somekind that states not to reopen old posts, this is my first time posting so be gentle 😉

I found this post extremely useful...