Thanks for the quick response

but that would the get me records older than 80 days

Sorry I may have not explained it correctly, I need clients that the most...

SO I'm a bit further....

But it only select the last one..

Anyway to get it to send an email to each one it finds?

Thanks

DECLARE @ToAddress VARCHAR(max);

...

Ok so with a bit of searching I came up with this which sort of works

But I need to expand my select statement to find the records I need...

Thanks for the info

I am going to try that

I did get around it by including the data in the SP without the where then using the filter on the...

sorry..

Jumped the gun...

I can use =User!UserID

Thanks

Joe

Thanks for the response...

I am going to give it a try , any idea why it still would have older snapshots like 12/24/13 ?

is it maybe a permissions on the...

So I think I answered my own question...

SELECT ASSESSMENT.Code, Client.LName, Client.FName, max(USER_DEFINED_DATA.EffDate), Client.ID

FROM dbo.Client AS Client INNER...

Hi Richard,

Thank you for the info.

That works, but since I had time to think I just queried the active zip codes and its an SSRS report so I allowed...

Thanks Sean & Keith,

That article is great.

I used the typical Catch-All and it worked

I may try to do it dynamically (looks fun, never did it)

Thanks

Joe

Hi Keith

Thanks for getting back..

Sorry I'm a bit confused, but I think it may be better to insert it in a where in the query?

Thinking of something like..

WHERE ...

Perfect!!!!

Thanks so much 🙂

Thanks Sean

Works great.. should have known that one 🙁

Thanks Jeff,

Thant works great.

Now I just want to dissect it so I totally understand it 🙂

Thanks Again

Sorry

I have a provider table each with a unique OID

I want to do the following INSERT on each provider

Some will have them already but it willl just send the...

Hi

Ok so what I figured to do

(Why didn't I think of this before.. It is MOnday 🙂

Anyway, I inserted a Matrix and based off the dataset

Seems straightforward now..

If anyone has...