SQL Query

 

Declare @showData int;

Declare @ustadKu int;

select @ustadKu = 462;

select @showData = 700;

Select  top (@showData) CreateDate as [Date],TrafficSource as Marketing_Partner,

(case when Campaign = null or Campaign ='' then 'Organic'  else Campaign end) as Campaign_Name,LandingPage 

from [dbo].[ActionTracking]

where PortalId = (@ustadKu) and CAST(CreateDate as Date) = '2021-12-29'