You can use LAG to check the value of the previous row within a CASE expression and show the comment as needed:

Could you provide us with some sample data and what the results you are after look like?

You can use a CTE and LAG to easily achieve this:

Guessing a bit here, but wouldn't that be easier to do in your SQL? This is pseudo--SQL but you could have something like this that would give you this information:

Steve seems to be on the money here. The error is telling you to look at the resultset property, not the parameters. I suspect you currently have it set to...

Out of interest, has anyone tried setting up LDAP authentication on SQL Server 2019 Preview yet? No documentation on it, so not sure where to start. Was hoping is might...

If that Google translate is to be relied on, your statement about changing the format of your dates is a little confusing. You don't store the format of a date...

You won't be able to do this is SQL itself. It the formatting (and font?) are really that important you'll need to use a different tool like SSRS. You'll then...