:w00t::w00t:

No I like being confused , it helps me think more!!

Yes, so it a way(my weird way of thinking) its sort of like creating a series of temp tables, but more effective ?

Thanks Luis

This is getting what I need .

It's great that it works and I'm sure I can muttle my way thru to understand, but do you have any suggestions...

Hi

Thanks everyone one for your input

Although most of this is beyond me 🙂

I was able to rough my way through it

It did error on me so I changed...

Thank you all for the info, not only do they work, but I actually learned something...

So I now get 3,4 and the 5th as null , which is what...

Hi Luis

Thanks for getting back.

I tried something like that and it only returns values with data. I think it it is my where clause?

SELECT RTRIM(data.dbo.CLI.LNAME) +...

Thank you Luis it is exactly what I needed . I feel a bit embarrassed I didn't figure that out

I worked in a case statement so any team with the...

Ok so I think I found something in the forum and adapted it to work

SELECT

ParentObject,

STUFF((SELECT ', ' + [View As] FROM dbo.Signatures t2 WHERE t2.ParentObject = t1.ParentObject FOR XML PATH('')),1,2,'')...

Actually I just tried

case when (Question1 = N'No') then 'text here ' else '' end

+ case when (Question2 = N'No') then 'text here ' else ''...

Hi J Livingston SQL

For some reason it doesn't. Unfortunately I don't do this as much as I'd like to.

As I check the data , I am going to play...

Thanks imex,

That worked exactly as I needed.

Sorry for the bad explanation..

Thanks AGain

Yes it would...:)

Sorry, Rainy Monday morning...

Thanks

Hi

I did figure it out in case someone is looking for something similar..

This works =runningvalue((IIF(count(Fields!Prog.Value)=1,1,Nothing)),sum,nothing)

onto my next question 🙂

Thanks

did a bit of research and found running value

Came up with : =runningvalue(count(Fields!Prog.Value),sum,nothing)

Which gives a grand total of number of programs all clients are in ..

is it possible...

Thanks Alan,

I need to do a little reading on cross apply.

I really want to usndersand how this works!!! 🙂

Thanks

Again