Hi SSC

Lookup definition is as follows:

USE [ABI_Reports]

GO

/****** Object: Table [dbo].[REFERENCE_LKUP_Month] Script Date: 03/27/2014 11:37:38 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[REFERENCE_LKUP_Month](

[FinMonNo] [int] NOT NULL,

[FinMonName]...

Thanks Jeff - that's true. I actually got it before I checked yours out as per Sean's earlier post.

Chris, I'll give your suggestion a try.

Cheers T

Many thanks for all the contributions - I know there's a lot to read through on this particular enquiry.

I've rejigged the split list function as suggested and ditched the union...

Right, the previous post was getting a little long, so just to clarify -

I don't mind dirty reads at all.

I've removed the join hint - makes no difference, although...

Sorry, I should have checked that out.

Please note each of the main tables contain approx. 450,000 each rows and the query returns 3350 rows. I can see that there are...

Hi

Sorry for the late reply, I've been pulled away to work on another project.

I've tried Dense_Rank, but that doesn't work either.

I did however find this post where the guy is...

Hi

No - that doesn't work either. I end up with the sequence:

FollowUp_No

1

1

2

2

3

3

4

1

5

Basically, I want the sequence to recommence at 1 at each ocuurrence of the value 'NS' under GenActivityCode, then...

Please ignore - I've reposted this in the general forum as I posted it here it error.

Tim

Hi Chris

Thanks for that. It works like a dream. I shall also implement your more elegant SQL against the other schemas as well.

Have a top day.

Cheers.

Tim.

Thanks Koen

That was my suspician too. Maybe one of those joins is not 1:1.

The split list function might be worth another look after that.

Cheers.

Tim

Hi Gini

Thanks for that, I think it will do the job. I just need to get our server to speed up as it took 2.5 mins to execute. I think...

The XML being retrieved is actually the content of reporting services' .rdl files. I suspect there may be some wierd image reference or somesuch in there, although I'm guessing of...

Hi Matthew

Thanks for that, but I get the same error as before.

I shall come back to this later, but thanks for your help - it's pointed me (or our...

Hi Matthew

Sorry, I should have mentioned that. No it doesn't execute OK - error message is:

Msg 9420, Level 16, State 1, Line 1

XML parsing: line 1, character 3, illegal xml...

Hi Rob

Bit late in replying as I was away yesterday.

I've just tried both NON EMPTY and the NONEMPTY() function and the latter has pointed me in the right direction, even...