Sonic

To see if that problem may be present, please execute the following code and report the results, please.

 SELECT  MinLen = MIN(DATALENGTH(log_message))
   ...

You could also try outputting the results directly to file

Also, do not prefix your stored procedure with sp_.

This has a performance impact, as SQL assumes that your proc is in the master DB.

What is the data type of your DOB field?

The answer to this SO question explains why it is a reserved word

https://stackoverflow.com/questions/4054511/what-exactly-does-the-t-sql-lineno-reserved-word-do

The different behaviours are documented here

https://docs.microsoft.com/en-us/sql/t-sql/functions/json-value-transact-sql?view=sql-server-2017

You need to get the min AdmissionDate per group first

WITH cteGroupDate AS (
    SELECT  *
        ...

This will concatenate the values as per the sample data

SELECT STUFF((
          SELECT ',filename=''' + RTRIM(FileName) + ''''
 ...

Assuming a low number of "Work" items, this pattern will work

SELECT
    d.[Date]
  , [Security]     = STUFF((SELECT ' & '...

How many unique "Work" items are there?

If there are 3 names, must they be "Name1 & Name2 & Name3"?

Duplicate post

https://www.sqlservercentral.com/forums/topic/pivot-table-23/#post-3674751

Thanks for all the replies 🙂

@DesNorton:

The reason is that SQL does not short-circuit the OR, and has to evaluate the "@ProjectID IS NULL" against every record in the index/table...

In [dbo].[Sola_uspLogError] , rather use

SET @ErrorLogID = SCOPE_IDENTITY();

In [dbo].[INSE] , the call to EXECUTE [dbo].[Sola_uspLogError] is before the ROLLBACK. This will cause the error information that was...

Don't use functions in a WHERE clause if you can avoid it, as they destroy "sargability".

In this case, just directly check each variable for NULL or a match, as...