Sorry, how would this code actually be written.

I am a complete novice when it comes to T-SQL, as this is not my code.

Many Thanks

Thanks for your reply Lyn.

I have checked the dats and they all look correct to me.

I have run the query in Query Analyser and the results are pulled back successfully....

Hi Guys I have managed to work out what the issue was - it was with the followinf sub query -

(SELECT DISTINCT LSH.[SUB-STATUS]

FROM [IH_IH-LOCATION-STAT-HIST] LSH

WHERE LSH.[PLACE-REF] = dbo.[IH_IH-LOCATION-STAT-HIST].[PLACE-REF]

AND...

Still not working I'm afraid -

I have changed the Sub Queries from

(SELECT CASE WHEN CONVERT(MONEY, PC.[NET-AMT]) IS NULL THEN 0.00

ELSE CONVERT(MONEY, PC.[NET-AMT]) END

FROM dbo.[IH_IH-PLACE-CHG] PC

WHERE PC.[PLACE-REF] =...

Thanks guys - I will tackle the problem as suggested.

Appreciate the swift response. I'll let you know how I get on.

Sorry for my ignorrance but do you mean queries such as -

(SELECT CASE WHEN CONVERT(MONEY, PC.[NET-AMT]) IS NULL THEN 0.00

ELSE CONVERT(MONEY, PC.[NET-AMT]) END

FROM dbo.[IH_IH-PLACE-CHG] PC

WHERE PC.[PLACE-REF] = dbo.[IH_IH-PLACE-CHG].[PLACE-REF]

AND PC.[ACCOUNT-CODE]...