SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[DynamicForm](
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [FieldName] [varchar](100) NULL,
    [Value] [varchar](100) NULL,
    [Ticker] [varchar](10) NULL,
    [ClientCode] [varchar](10) NULL,
    [Order] [int] NULL
) ON [PRIMARY]
SET IDENTITY_INSERT [dbo].[DynamicForm] ON
INSERT [dbo].[DynamicForm] ([ID], [FieldName], [Value], [Ticker], [ClientCode], [Order]) VALUES (1, N'Last Update
', N'4/28/2021
', N'X', N'Z', 1)
1 rows affected

INSERT [dbo].[DynamicForm] ([ID], [FieldName], [Value], [Ticker], [ClientCode], [Order]) VALUES (2, N'Broker
', N'Argus Research Corp
', N'X', N'Z', 1)
1 rows affected

INSERT [dbo].[DynamicForm] ([ID], [FieldName], [Value], [Ticker], [ClientCode], [Order]) VALUES (3, N'Analyst 
', N'David E Coleman
', N'X', N'Z', 1)
1 rows affected

INSERT [dbo].[DynamicForm] ([ID], [FieldName], [Value], [Ticker], [ClientCode], [Order]) VALUES (4, N'Last Update
', N'7/6/2021
', N'X', N'Z', 2)
1 rows affected

INSERT [dbo].[DynamicForm] ([ID], [FieldName], [Value], [Ticker], [ClientCode], [Order]) VALUES (5, N'Broker
', N'JMP Securities
', N'X', N'Z', 2)
1 rows affected

INSERT [dbo].[DynamicForm] ([ID], [FieldName], [Value], [Ticker], [ClientCode], [Order]) VALUES (6, N'Analyst 
', N'David M Scharf
', N'X', N'Z', 2)
1 rows affected

SET IDENTITY_INSERT [dbo].[DynamicForm] OFF
DECLARE @SQL nvarchar(MAX),
        @CRLF nchar(2) = NCHAR(13) + NCHAR(10);

SET @SQL = N'SELECT ' + STUFF((SELECT N',' + @CRLF + N'       ' +
                                      N'MAX(CASE FieldName WHEN ' + QUOTENAME(FieldName,'''') + N' THEN Value END) AS ' + QUOTENAME(FieldName)
                               FROM dbo.DynamicForm
                               GROUP BY FieldName
                               ORDER BY MIN(ID)
                               FOR XML PATH(''),TYPE).value('(./text())[1]','nvarchar(MAX)'),1,10,N'') + @CRLF +
           N'FROM dbo.DynamicForm' + @CRLF +
           N'WHERE Ticker = @Ticker' + @CRLF +
           N'  AND ClientCode = @ClientCode' + @CRLF + 
           N'GROUP BY [Order]' + @CRLF + --ORDER is a reserved keyword, and should not be used for object names
           N'ORDER BY [Order];'; --ORDER is a reserved keyword, and should not be used for object names

DECLARE @Ticker varchar(10) = 'X',
        @ClientCode varchar(10) = 'Z';

--Print @SQL; -- Your best friend
EXEC sys.sp_executesql @SQL, N'@Ticker varchar(10), @ClientCode varchar(10)', @Ticker, @ClientCode;


Last Update

Broker

Analyst 



4/28/2021

Argus Research Corp

David E Coleman


7/6/2021

JMP Securities

David M Scharf



Warning: Null value is eliminated by an aggregate or other SET operation.


DROP TABLE [dbo].[DynamicForm];
Last Update	Broker	Analyst
4/28/2021	Argus Research Corp	David E Coleman
7/6/2021	JMP Securities	David M Scharf