DataDrivenSubscriptionTable

CREATE TABLE SubscriptionEmailList (
RowID INT IDENTITY (1,1)
,ReportName VARCHAR(200)
,SubscriptionDescription VARCHAR(200)
,JobID VARCHAR(40)
,TO VARCHAR(4000)
,CC VARCHAR(4000)
,BCC VARCHAR(4000)
,ReplyTo VARCHAR(4000)
,IncludeReport VARCHAR(5)
,RenderFormat VARCHAR(60)
,Priority VARCHAR(6)
,Subject VARCHAR(4000)
,Comment VARCHAR(4000)
,IncludeLink VARCHAR(5)
Active BIT
)

INSERT INTO SubscriptionEmailList
VALUES
(
'Report Name'
,'Report Name Occurance Email'
,'Job ID'
,'TO'
,'CC'
,'BCC'
,'ReplyTo'
,'Include Report'
,'Render Format'
,'Priority'
,'Subject'
,'Comment'
,'IncludeLink'
,1 --Active or Not
)


SELECT * 
FROM SubscriptionEmailList WITH (NOLOCK)
WHERE 
	ReportName = ''
	AND SubscriptionDescription = ''
	AND Active = 1