Thanks, but you didn't test the INSERT statement, did you?

Arithmetic overflow error converting expression to data type datetime.

John

Are those dates in European or US format?  I can't tell.  Please supply them in an unambiguous format (such as '20170116') and test your INSERT statement before posting.

Thanks

OK, and what result do you expect given that sample data?

Incidentally, if you provide your sample data in the form of CREATE TABLE and INSERT statements, it makes...

Damian

It's not necessarily purely a priority thing - if both processes have equal priority, then the process that's easier to roll back is chosen as the victim.

Note that the BETWEEN operator includes both the upper and lower bound and therefore 5 is captured in both the 10 and 20 ranges.  Because of the way the CASE...

I feel for you, having to complete an exercise that isn't written in coherent sentences.  Goodness knows how you're supposed to understand what is required.  Putting that aside, though, do...

Use the DATEDIFF function to get the number of years, then use DATEADD to add that to the acquisition date, then use the DATEDIFF function again to get the number...

Not...

Here's some benefits I can see:
(1) If you want to install client tools on a server (which I think is a bad idea), you have to make a conscious...

Well, you decide whether you want to call it a requirement or an enhancement!  But yes, from 2016 SSMS is no longer bundled in the server product, but instead is...

PowerShell might be a good way to go here.  You can use the Invoke-SQL (I think that's what it's called) cmdlet and then pipe the results to the Format-Table cmdlet,...