Thank you both; I will have a look at the results from each method and see what can be done. Given that both of these methods require a bit of...

Simple Talk suggests this:

USE [DataBaseName]

GO

EXEC sys.sp_cdc_enable_db

GO

https://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-%28cdc%29-in-sql-server-2008/

Thanks wBob - that equivalent by a different method will be a really useful tool for me; I am much less familiar with the FOR XML PATH method and will...

I have found a solution to the problem - in each union-ed select statement, I can add a WHERE clause to include or exclude the results. If the select statement...

I am sorry.

I have found the error - it is in the source data; someone has changed something somewhere and the more recent claim create dates are entered differently to...

Ah, so I have found something that might help shed light: if I run the stored procedure as a query by modifying, then commenting out the "alter proc" to return...

I have compared the procedures in the live and test versions - apart from the database references (only one line at the top "USE ..."), they are identical. The field...

Cheers, Jeff - lots for me to chew over there!

I'll look through the links and see what they provide. In answer to your question, I refer often to (e.g.) "Second...

Ok - no point in repeating the logic in separate indexes; got it.

thanks!

Mark

Unfortunately, I cannot use a URL like that in this case, as the report will be printed out and given to a medical escort when they drop in at work...

Cheers LeoZ,

That is exactly the unhappy conclusion that I came to - I just hoped I was wrong as I am not very experienced with SSRS. I think I will...

Hi,

thanks for the answer - unfortunately I had hoped this could be avoided, as it means that I'll have to spend a very long time changing a lot of things...

Hi Sean,

ours is on the server, so I'll need to get someone else to have a look at that, but if that holds the full error messages, then that's what...

Thanks guys,

I have had a little look at the profiler and that looks as though it will do the job for now, but as you say, it seems to record...

OK, so the answer was to add an ABS() around the length part of the LEFT() command. This means that the length will never cause an error - if this...