Data driven subscriptions seems to be the solution to the problem:

any other good resources or tutorials i can go through ?

microsoft tutorial is confusing me more.

Oh wow, thank you guys. I already saved both of the queries. I was able to track down the report it was on a different server and not on reports/reports....

Under the subscriptions or catalogs table, Am I looking for

'D26XXX' Or '2021cXXXXX' ?

yeah that's true, currently I have more than 50 jobs set up on reporting server, all with funky name, don't know how to figure out which one is associated with...

Would anyone know where and how to edit the following

'exec [ReportServer].dbo.AddEvent @EventType='TimedSubscription', @EventData='2021c27f-0a5a-45f7-9f4d-4a35349d8122'

CAST('Marked' as varchar(20)) AS [XYZ]

On the description of the Job 'D26XXX' I see the following note:

'This job is owned by a report server process. Modifying this job could result in database incompatibilities. Use Report...

yup that was it !!!!

Thanks for clearing the min and max concept.

Alright here you go:

Another sample Data:

Lets analyze the where(filter clause) first, one record(row) of loan 1004 should be eliminated because it has a record where Coloum Exported is NOT NULL

Loan...

there are some records in exported column those are NOT Null and it is also a DATETIME data type. If you look at the attached excel Loan '123123' is actually...

Thanks Scott, I am using the GroupBy and having clause but using them is not making any difference as results are coming out to be exact same. Funny thing is...

I have edited my CREATE TEST TABLE DraftDT and RequestedDt to DATETIME if that helps.

Thanks Scott, I got your point and it makes sense. but somehow its still not giving me the desired result. If I run your above statement without the GROUPBY and...

When I tried the following on the Test Data table it worked,

SELECT LID

FROM TEST_TABLE_Dupe_Pay

GROUP BY LID

HAVING DATEDIFF(d, MIN(DraftDt) , MAX(DraftDt)) <=3

When I tried...

My domain username happens to be 'DMG\Paine while under the network_user_name it is only 'Paine' would that make a difference?