Hi
I have below code I want if AcctCode is '10011' its color should be red
ALTER PROCEDURE sp_color
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @body NVARCHAR(MAX)
SET @body = N'<table>'
+ N'<tr><th>AcctCode</th><th>AcctName</th></tr>'
+ CAST((
SELECT p.AcctCode AS td,
p.AcctName AS td
FROM Oact p
FOR XML RAW('tr'), ELEMENTS
) AS NVARCHAR(MAX))
+ N'</table>'
-- Return the generated HTML content
SELECT @body AS HtmlContent
END
GO
Thanks