Adrian Charles Chetwynd-Talbot (9/17/2009)

---

the given answer to this question is incorrect because the string variable contains 9 characters including the commas and spaces. Total length through first function being...

very interesting. I too thought the results would be "1, 2,". Until I set the output to text and realized I was wrong.

I thought the final...

ok. Make sure the below query only returns 1 record per ID. If it doesn't rewrite just this portion until it only return the 1 record you need....

Since it is sql 2000. try the below. It should work but I didn't test it at all.

SELECT DISTINCT dbo.DW_SALESINVOICES_F.Reference AS [Sih.Reference],

dbo.DW_SALESINVOICES_F.InvoiceDate AS [Sih.InvoiceDate],

DATEPART(YYYY, dbo.DW_SALESINVOICES_F.InvoiceDate) AS...

Since you only want to pull the max date from the dbo.DW_SERVICEORDERSJOBS_F table but still want to use a left join try something like the below.

Left Join (select [someIDfield], max([someDateField])...