Thank you Phil and Jonathan.

Hi,

There is a maximum of three occurrences.

I want the output to be the numbers separated by a comma.

07999999999, 07888888888

Thanks,

Paul

Hi Phil,

That does work for extracting one number but I was hoping there is a solution if the column contains multiple numbers begining with 07.

Can you think of a way?

Thanks...

Hi,

Sorry I've worked it out.

  ON  CAST(CONVERT(DATETIME, tk.[Start], 103) AS time(0)) < it.RangeEnd
            ...

Hi DesNorton,

Thank you so much for this! It's a massive help and works when creating the task temp table.

I am not able to get the script working with the amendments...

thank you ever much ThomasRushton!

Perfect thanks. It worked and was really simple.

Hey,

Thanks for the replies. I will let you know when I am back on the server tomorrow.

Paul

I managed to solve it.

SELECT O.ow_id

FROM props.dp_owner O

JOIN props.dp_entry E

...

Hi,

Sorry in more detailed terms;

There is a table with items, these are linked with owners through the entry table.

One owner can have multiple items and each of the items have...

For example here;

SELECT * INTO ##BankStaffTemp

FROM (

SELECT

RIGHT([Cost Centre],5) AS 'Cost Centre'

,SUM([WTE Worked]) AS 'Total WTE Worked'

FROM [MCT-BIT-LIVE01].[MCT_STG].[dbo].[Staging_Finance_Extra_Staffing]

WHERE FinancialYear = YEAR(@startdate)

AND FinancialPeriod = @fp

GROUP BY RIGHT([Cost Centre],5) ) T2

The SP is 220 lines long and uses all the params that are set at the top which I showed before.

This is the SP for the main dataset. What happens is month and year are entered through SSRS to the SP at this point 3 more parameters are based on...

I have changed the SP to include OUTPUT and no luck.

ALTER PROCEDURE [dbo].[USP_Report_Vacancy_Monitoring_Wards] @month VARCHAR(MAX), @year VARCHAR(MAX), @startdate DATE OUTPUT, @enddate DATE OUTPUT, @fp VARCHAR(MAX) OUTPUT

AS

SET @fp = (SELECT MAX(FYMonthNumber)...