Unfortunately SSC, and the use of tabs, has made your expected results an unreable mess. Guessing you need a conditional aggregation?

This is more of a gaps and islands question. With functions like ROW_NUMBER it doesn't care about "gaps" in the data, if the value of the column (Cell in this...

• This reply was modified 6 years, 6 months ago by Thom A. Reason: Alternative solution

You haven't explained your goal here or the results you want, however, is this not what you are after?

DECLARE @XML xml = '
<Location>
    <Address>
...

Difficult to read when everything is in a code block, however, if you need every date group, look at a calendar table, or similar. Otherwise you can use a Tally...

SSIS has been available for a long time on VS2017. I would guess, as commented above, that you've downloaded VS, but not SSDT.

Did what I suggested above not work then?

Welcome to SQL Server Central.

Those look like interview questions. You should be answering those question first, not us (random strangers from the internet). If people from SSC answer the questions...

Are you talking about how the date would be displayed in a textbox to the user in the report? I honestly can't remember if SSRS (2012), detects the user's language...

That statement looks malformed to me. If we format and correctly quote your strings we get the following (I've added some comments where there are problems):

CREATE PROCEDURE...

This doesn't sound like you need sample code but that the email server you're connecting to isn't allowing you to send emails. You probably need to talk to the administrator...

Yes, the version I provided will work on all supported...

Looks like it's the editor that "flattens" the image, rather than the upload. I managed to get the animated gif uploaded, but as soon as I select it for use...

Perhaps the OP really does want to know the steps their idol would...

Are these all interview/homework questions? ethical question, replication, Adjusting T-sql to prevent injection, accidenly dropping production, failover, idol steps to take.

Why don't you tell...

I'd avoid a CURSOR in truth. You'll find that solution will not scale well and will very likely be the slower of the 2.