Hilariously you solved it for me....

I had made a very rookie mistake and simply needed to look at yours to solve it. Too embarrassed to state what it was....for...

Right, I had an epiphany....as I don't care about the actual value of the ls_id all I need to do is return the max ID so one record populates..

SELECT

'thistype' AS...

Yes that is the case:

LS_TABLE:

ls_id L001 L002 L003

ld_id A001 ...

Alan.B (8/13/2013)

---

learning_sql (8/13/2013)

---

Ha, it literally said "Reporting Services does not support CROSS APPLY".

However I have just been playing around and when just typing the query it worked every time, I...

Ha, it literally said "Reporting Services does not support CROSS APPLY".

However I have just been playing around and when just typing the query it worked every time, I have now...

That would have been great, really great - had it been supported on my version of SSRS....:(

Thanks, those are much easier to read.

I have tested against SSRS, I will be using the coalesce query alongside the usual where clauses.

Thanks again.

SSRS doesn't like that method, never mind at least I have it working. Many thanks Sean.

thanks, I was hoping for an easy answer and got it.

So there is no way to query the case's result itself, make sense but I wanted to be sure.

If I wanted to replace the id structure (to clean up the data) to the form Lnnn (AG001/1/L001 etc) - is there a way I could do this.

I realise I...

Thought I would ask this in here - I know little about it but wondered if there is any specific advice to follow...I read you can handle errors in triggers...

Thanks Scott,

I don't always do it - usually do. Unfortunately i edited the code a lot before posting it onto the forum.

Many thanks - I have changed my code to join the inserted records...

My nick is fairly accurate - I am still learning sql..

EDIT - I have actually changed the code...

I will look at it, it will certainly make the solution more comprehensive.

The triggers I created update the tables perfectly considering they will only be executed by users selecting/deselecting a...

Ok - this is how it works...

The column "Closed_Ind" on Table_A is updated (1 or 0). The trigger updates table_B's closed_ind column depending on whether the Table_A was a...