spLoadRecord_ContentComparisons
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@CCPID | int | IN |
Definition
Copy
CREATE PROCEDURE spLoadRecord_ContentComparisons(@CCPID int) AS
SELECT cc.ID, cc.CID, cc.Selected, sc.Title, cc.NumDisplays, cc.Conversions
FROM [dbo].ContentComparisons cc INNER JOIN [dbo].SiteContent sc ON cc.CID=sc.ID
WHERE CCPID = @CCPID