It's not the sub-query that's your problem, it's mixing variable assignment with returning a result set.

You can do this:-

Select MyField From MyTable

Or This:-

Select @MyVar = MyField From MyTable (as long...

Hmm, that might be worth a punt. I'm away from work until Wednesday but I'll definiely give this a try. Nice lateral thinking:cool:

I don't get an actual error message. I'm just getting the #err# appearing in the matrix cells. Basically it's SSRS telling me "I can't work out the value...

Hmm, not the answer I wanted but thanks anyway.:-)

Don't get me wrong, I've found this site to be freindly, professional and informative. Alot better than many I've encoutered, in fact. My criticism is definitely around an...

Speaking as a relative newcomer to the forum I find the point per post system a bit flawed in that it encourages garbage posting. I find this to be...

I think you want something like :-

Update A

Set A.Address = @StudAddress1

From Student S

Join Address A

on S.PersonID = A.PersonID

Where S.Student_Number = @IDStudent

You'll need to adjust that statement for...

I just had a very simliar problem. It was on a report I'd developed myself and was occuring in the project in which I'd developed it. Clicking View...

I'm sorry but I still don't understand the problem. Can you provide some example of what the user would pick and what you'd expect the result to be?

I guess I just always enumerate my columns so I don't have to worry about the underlying structure of the table changing (such as columns changing position due to datatype...

I apologise, Lynn, but my inner pedant insists on butting in here.

The first column of your table is an integer field defined with the Identity property. You have to account...

I think the point is that you want to understand the difference between replacing and trimming and why you use each technique.

A Trim will remove leading or trailing spaces from...

Oops, my edit crossed over with your post.

Assuming you want to get rid of it regardless of where it is in the string then just replace(MyField, 'Tab', '') (I've...

Are you sure those are actually spaces? Trimming won't remove tabs, for example.

Try this and you'll see what I mean:-

select LEN(RTRIM('Test '))

Select LEN(RTRIM('Test'))

(In the first select there's a trailing...

Just had a chance to do a quick read up and this is definitely what I was after. I think my problem was that I just didn't know what...