Hi..

or "Hi Sean" !!!

So I have the data merging, and read the article and assumed to replace SELECT ', ' +

with SELECT CHR(13) + ,for a Carriage Return?

It...

Thanks for the Help...

Here is my final list(If interested..lol)

Yes the data came from an old foxpro db

Sorry, one more question , OK two....

one...

can I add a...

Thanks for that..

Now I get ...because it contains a character (0x0003)

I read that only &, < and > (as well as " or ' in attributes) are illegal in...

So somehow you figured out what i need via my cryptic request...

and I came up with this

WITH CTE AS

(

SELECT DISTINCT

CLINO

...

I'm sorry, and I'm not trying to be a smartA$$...

But could you give me an axample of wht you would like to see?

Thanks

Thanks worked great !!

I tried this on the dataset filter expression but is not working

=IIf(Parameters!active.Value = "A",isnothing(Fields!DischargeDate.Value),Fields!activestatus.Value = "A" or Fields!activestatus.Value = "B")

Thanks...

sorry found it

,dateadd(month, datediff(month, 0, getdate()) - 4, 0)

,dateadd(month, datediff(month, -1, getdate()) - 4, -1)

Thanks

Joe

Thanks for the info...

Ok I sort of get it....

The SP sets up the email addresses...

But how do I get my data there

I have a SP that writes out...

Thank you !!

I'll be back with questions.... 🙂

Thanks for getting back

we use 2008R2

Where/How would I find the article. I know we don't have enterprise version

Thanks

Again

Thanks Chris

Worked great, I guess I'll need to use CAST alot with the data in this table 🙂

Have a nice weekend!!

So I've been playing with this and below works

Not sure if its the best way .....

But I'll try to incorporate it

SELECT

ASSESSMENT_DATA,

start1.pos1,

[end1].pos1,start2.pos2,

[end2].pos2,

case when [end1].pos1 >1 then

SUBSTRING(ASSESSMENT_DATA,start1.pos1,[end1].pos1-start1.pos1)

else '' end as...

So I tested with adding the last line in the where clause to get only valid start and end position, and it worked but of course I am missing data...