"SELECT Campaign_Id,Campaign_Name FROM Campaign_Master WHERE Default_Campaign = 1 AND Process_Id = " + ddlProcess.SelectedValue
                   + " AND ((StartDate <= CONVERT(varchar(10),GETDATE(),101) AND EndDate >= CONVERT(varchar(10),GETDATE(),101)) OR  Campaign_Master.Type = 'Inbound')";

SELECT Campaign_Id,Campaign_Name FROM Campaign_Master WHERE Status ='True' AND Process_Id = " + ddlProcess.SelectedValue
                + " AND ((StartDate <= CONVERT(varchar(10),GETDATE(),101) AND EndDate >= CONVERT(varchar(10),GETDATE(),101)) OR  Campaign_Master.Type = 'Inbound')"
                + " ORDER BY Campaign_Name";