Sorry guys. Didn't make myself clear.

The screen shot is simply a SELECT of table1 and table2, joining on the ID.

What table2 shows is the previous id of all the tasks...

When you say screen shot...a screen shot of what exactly .what do you mean?

Thanks to all that have help with this issue

Thank you Sean. That will meet my needs.

You are right in what you say in what I am trying to achieve.

It's for a single select statement result set.

I have an SSIS package, where I need...

Thanks - Ended up trying the following and it did the trick -

CASE WHEN PATINDEX('%[^0-9]%',left(Address1,CHARINDEX(' ',Address1,0)-1)) = 0

THEN left(Address1,CHARINDEX(' ',Address1,0)-1) ELSE NULL END AS BuildingNumber,

CASE WHEN PATINDEX('%[^0-9]%',left(Address1,CHARINDEX(' ',Address1,0)-1))...

This has done the trick -

select replace (STUFF(( SELECT ISNULL(';' + ltrim(rtrim(l.Description)) + ' ' + ltrim(rtrim(c.Surname)),'')

FROM ContactDetail c

LEFT JOIN ContactGroupMember cgm ON cgm.ContactId = c.ContactId

LEFT JOIN...

Thanks - nearly there. So it's taken care of the & at the start of the result set...but the delimiter in between is still coming back as &amp.

Mr Nicholls&Ms Wainwright

Would this work?

if object_id('Dataload_TEST..Table_DL') is not null

ALTER TABLE Dataload_TEST..Table_DL DROP COLUMN LastChargeDate

Actually this is just checking if the table exists - not if the column in that database exists.

Thanks Guys.

BWFC (2/26/2016)

---

TSQL Tryer (2/26/2016)

---

The only thing I'm thinking is what if the Current Period is 1 but the year is say 2017 (next financial year....it would need to pull back...

The only thing I'm thinking is what if the Current Period is 1 but the year is say 2017 (next financial year....it would need to pull back the previous 11...

That's spot on - it works!!

Just need to work out the logic of it now. But thank you that seems to have done the Trick.

Sorry for the delay.

To make it easier I have placed my results in one table -

The table -

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Test](

[CalendarPeriodId] [int] NOT NULL,

[CalendarId] [int]...