Thank you ChrisM 🙂

Gracias Luis

Thanks Koen

Thanks a lot Eirikur 🙂

Gail,

Thanks a lot for your reply and solution, it works fine now with OPTION (RECOMPILE)

Have a happy next new year 2014 🙂

Regards

Claudio

Mark,

Having XPK index cluster at event_history table, how could we enhance the CTE?

Index key columns

System_no

Even_date

Seqno

Thanks

Claudio

It worked fine !! thanks a lot Mark 🙂

Have a good weekend

Regards,

Claudio

HanShi, it works okay 🙂 Just what i'm looking for

Thanks to everybody for your prompt and kindly help

Regards,

Claudio

Okay Sean, thanks for your advise, let's see if the following lines are valid

CREATE TABLE [contact_link](

[contact_no] [int] NOT NULL,

[end_date] [smalldatetime] NOT NULL,

[site_no] [int] NULL,

[cs_seqno] [smallint] NULL,

)

CREATE TABLE [contact](

[contact_no] [int]...

Hi Koen,

Thank you for your support

These are table definitions and sample values for contact_link.cs_seqno 20 assuming that contact cs_seqno 20 is the first contact that has a phone number starting...

Thank you Sean

Thank you SSChampion, how can i adjust your advise in the following sentence where i only can get the MIN one, not really what i am looking for

SELECT ...