I like the idea of a backup camera but most of them seem to be poorly engineered.  At night, you can't actually see anything in the passenger side mirror or...

To answer the question where the numbers could be anywhere from 1 to 10 digits (up to the max of INT), here's some test code (borrowing heavily on Phil's good...

• This reply was modified 6 years, 7 months ago by Jeff Moden.

Changing Phil's code to handle single digits is easy because of the nature of numeric strings, if your pattern is guaranteed.  Except for the comments, the additional test data, and...

The listed order of of the stairways have nothing to do with the order of a study plan.  They're not collectively meant to be an "overall stairway" to learning SQLServer...

Phil's  code works great for this but I do have a question...

Is there any chance of having less or more than 2 digits on either side of the "/" ?

I think this question is an excellent example of why you should never rely on defaults. 😉

You pointed at me something I should have mentionned in my first post. Sorry : "That's a business decision, not a technical one"

We are OK to loose a day...

For the final result, do you need the format you've portrayed for the monthly column names or can we economize and clean those up a bit.  For example, you have...

You say you were "about" to create a new table.  Did you actually try to finish that task?

Thanks, Sam.  If you have the time, it would be interesting to know how you resolved the problem.

Thanks for the feedback, Sam.  I'd love to hear what you end up with.

Thank you

I figured it out

It was the Server name was incorrect.  The MSTDC setup on the Cluster was wrong after correcting that email starting working.

Thanks again for all the...

I don't know because I don't know what you mean by "exponential numbers" nor what such numbers...

I have to ask... what does the Export/Import Wizard have to do with a Database Restore?

A Database Restore should show up in the SQL Server log.

Ah... got it, Sue.  It looked like you were referencing my reply.  Sorry.