CreativeGirdProc.sql

ALTER FUNCTION [dbo].[Creative_Grid] (		
  @start DATETIME, 
  @end DATETIME, 
  @clientIds VARCHAR(MAX), 
  @seId VARCHAR(MAX) = null,
  @campaignId VARCHAR(MAX) = null,
  @adCategoryId VARCHAR(MAX) = null
) 
RETURNS TABLE AS RETURN 
(
  SELECT 
    creative_base.*,
    fact.*,
    onsite.*
				
  FROM   
    creative_base 
             
    JOIN Creative_Fact ( @start, @end, @clientIds, @seId, @campaignId, @adCategoryId ) AS fact
      ON 	creative_base.creativeid = fact.FactCreativeId 
			 
    LEFT OUTER JOIN Creative_Fact_Onsite ( @start, @end, @clientIds, @seId, @campaignId, @adCategoryId ) AS onsite 
	    ON creative_base.creativeid = onsite.OnsiteCreativeid 

  WHERE  
    creative_base.AdStatusID != 3
    AND creative_base.AdTypeID = 1
    AND creative_base.ClientID in (SELECT * FROM Split(@clientIds, ','))
)