DECLARE @startDate AS DateTime
DECLARE @endDate AS DateTime
DECLARE @station AS int

SET @startDate = '2011/01/01'
SET @endDate = '2011/01/31'
SET @station = 2346

SELECT  DISTINCT ac.[CampaignID] AS [CampaignId], ac.[CampaignPrettyName] AS [CampaignName], ac.[DateCampaignStart] AS [CampaignStart],
        ac.[DateCampaignEnd] AS [CampaignEnd], av.[Industry] AS [IndustryCode], lu.[luName] AS [IndustryName],
        si.[iStationID] AS [StationId], si.[sPrettyName] AS [StationName], [ri].[iStationID] AS [MarketId], [ri].[sPrettyName] AS [MarketName]
FROM    [t_AdTraffic_Campaigns] AS ac
    INNER JOIN  [t_AdTraffic_Ads] ad            ON ac.[CampaignID] = ad.[CampaignID]
                                                AND ad.[Status] = 'A'
    INNER JOIN  [t_AdTraffic_AdStations] aa     ON ad.[AdID] = aa.[AdID]
    INNER JOIN  [t_AdTraffic_Advertisers] av    ON ad.[AdvertiserID] = av.[AdvertiserID]
    INNER JOIN  [dbo].[amf_LookupsByluType]('AvoidanceGroups') lu   ON av.[Industry] = lu.[luVal]
    INNER JOIN  [t_stationInfo] AS si   ON  aa.iStationID=si.iStationID
                                        AND @station IN (si.[iStationID],si.[irollupstation],si.[iNetworkID])
    INNER JOIN  dbo.t_stationInfo ri    ON  si.irollupstation=ri.iStationID
    INNER JOIN  dbo.t_stationInfo ni    ON  si.iNetworkID=ni.iStationID
WHERE   ac.[DateCampaignEnd] >= @startDate
AND     ac.[DateCampaignStart] <= @endDate;