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...

I have meant 200 rows of code

Column1,

Column2,

----

Column200

I appreciate SSMS will generate it for me, yet again, I was hoping to have neater solution, something like one would do in...

This is how I handle variable inputs

DECLARE @ProjectID   int            = 300;
DECLARE @ProjectName varchar(100) ...

Thanks. That works fine. But the one issue that remains is there is a duplicate value for Bids in the NF is duplicated and there should be only one....

Look at the progress we've got in SQL over the years!

what used to be 13 years ago a short inline formula using system functions and integer arithmetic is...

Duplicate post

https://www.sqlservercentral.com/forums/topic/convert-seconds-to-minutes-2#post-3672679