Thanks Sean,

I've tried it a few ways casting as unique identifiers and varchars and none of them seem to be working. I was only playing round with the shorter values...

Hi,

the datatype of the all of the id columns are uniqueidentifiers within the database. However these values are being passed to the SP from SSRS as a multi value parameter...

As a part time idiot i forgot to hit save before deploying. Your suggested fix worked.

Thank you very much.

Hi, it's a bit value not an integer as I first thought.

However I thought I would be accounting for that with

sub report 1 as =IIF(Fields!AppointmentLetterStage.Value <> 1,True,False)

sub report...

Hi thanks for the response. As I thought I had actually tried that, which makes this all the more annoying.

I did try it again to make sure it wasn't...

Hi, thanks for the response.

Just to clarify, in the properties of the sub report .rdl files or the sub report properties within the master report?

The reason I ask is...

Beaten to it.

I think I had a similar problem yesterday, I'm still working on it now as a matter of fact.

Try something along these lines, you may need to...

I did get the correct result on the one isolated reference. I will be testing again in the morning on a larger scale.

Ultimately my aim was to only select the row that is joined to the highest value..

I think I'm on the right track with this with the text in bold doing...

Thanks, I've read through both of those links and will certainly tread carefully in regards to table hints.

I think I've possibly been going about my task the wrong way.

I'll use...

Thanks, I'll give it a try in the morning, just off home now.

I'm pretty new to T-SQL, having previously only used Access for SQL but my understanding of the nolock...

Based on the above data I'm trying to insert that query as a subquery, I thought I was going about it the right way with this:

SELECTdbo.BookingTransaction.BookingRef

, (

SELECT...

Once again you show me the way with very simple stuff.

Thanks you kindly Sir!

Thanks, an obvious error that I couldn't see.

Updated, I forgot transaction date :doze: and I've added another couple of fields that I didn't think had any consequence.