Scene URL Concatenate Individual Images

SELECT 
    a.Client,
    a.SceneUid,
    a.ImageRecognitionStatusRejectedText AS "Manual SubStatus",
    a.IrUserName AS "Username",
    a.CreatedOn,
    b.AssetPurityImageId AS "Imageid",
    CONVERT(VARCHAR(8), a.PurityDateTime, 112) AS "PurityDateTime",
    b.ImageStoragePath,
    b.ImageName AS "AssetImageName",
    'https://portal.visioniot.net//Controllers/CoolerImagePreview.ashx?Imageid=' + 
    CAST(b.AssetPurityImageId AS VARCHAR) + 
    '&PurityDateTime=' + CONVERT(VARCHAR(8), a.PurityDateTime, 112) + 
    '&ImageStoragePath=' + b.ImageStoragePath + 
    '&AssetImageName=' + b.ImageName AS "Image URL"
FROM vwAssetPurityList a
INNER JOIN vwAssetPurityImageList b WITH (NOLOCK) ON a.AssetPurityId = b.AssetPurityId
WHERE a.ClientId = '459' 
  AND a.CreatedOn >= '2025-01-01' 
  AND a.ImageRecognitionStatusRejectedText <> '' 
ORDER BY a.SessionUid ASC;

--------------------------------------------------