79787356

Date: 2025-10-10 12:46:20
Score: 1
Natty:
Report link

I have figured it out ... I've just added pointless data that I can ignore elsewhere in a normal SQL SELECT column, and kept the data that I need in the secondary column.

Here is the 'ALTER' statement:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[INF_GetWebOrder_JsonNoBillNoLines] AS
SELECT 
  dbassyOrderio.OrderNo AS 'OrderyNumNum',
  JSON_OBJECT(
    /*StaticDataStart*/
    'currencyCode': 'GBP',
    /*StaticDataEnd*/
    'phoneNumber':dbassyOrderio.Telephone,
    'email':dbassyLoggyLogins.Email
   ABSENT ON NULL) AS 'OrderishData'
FROM
    db_Orders AS dbassyOrderio
INNER JOIN 
    db_Logins AS dbassyLoggyLogins ON dbassyOrderio.LoginId = dbassyLoggyLogins.Id
GO

PERFECT!

Reasons:
  • Blacklisted phrase (0.5): I need
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: influentialeliot