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

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

DATEPART(YYYY, dbo.DW_SALESINVOICES_F.InvoiceDate) AS [Sih.InvoiceYear],

...

Thanks for the reply - however I am getting the following error -

Server: Msg 170, Level 15, State 1, Line 28

Line 28: Incorrect syntax near '.'.

So easy when you know how.

Thanks so much.

Thanks managed to get the data.

That's Correct. I am not totally new to SQL but have huge difficulty grasping the language.

Thanks for your replies so far. My Code now looks like below -

SELECT...

Now have another issue -

When I run the below query -

SELECT TEN.[tenancy-ref] AS 'Tenancy Reference',

TEN.[corr-name1] AS Name,

...

Thanks guys. I will give this a go and let you know how I get on.

AGE =

-- Find difference in years and subtract 1 if date is before this years birthday

...

If below is my currect Select, where would I input your soloution please?

SELECT dbo.[CORE_CO-PERSON].[PERSON-REF]AS Person_Reference,

dbo.[CORE_CO-PERSON].[PERSON-TITLE] AS Person_Title,

dbo.[CORE_CO-PERSON].[INITIALS]AS Initials,

dbo.[CORE_CO-PERSON].[FORENAMES] AS Forenames,

dbo.[CORE_CO-PERSON].[SURNAME]AS Surname,

dbo.[IH_RE-TENANCY].[corr-name1]AS Name_On_Tenancy1,

dbo.[IH_RE-TENANCY].[corr-name2]AS Name_On_Tenancy2,

dbo.[CORE_CO-PERSON].[D-O-B] AS DateOfBirth,

DATEDIFF (year,dbo.[CORE_CO-PERSON].[D-O-B],GETDATE())AS Age,

dbo.[CORE_CO-PERSON].[NHI-NO] AS NationalInsurranceNumber,

dbo.[CORE_CO-PERSON].[ORIGIN-CODE]AS EthnicOrigin,

dbo.[CORE_CO-PERSON].[GENDER]AS...

Sorry - worked it out.

Thanks guys

Hi there,

Just to confirm it is a string value and will always be in the same format.

Sorry, but I'm really useless when it comes to coding. Where exactly would...

Just to let you know I got this working.

Thanks

Oh dear 🙂

Thanks guys. This will hopefully make a lot more sense to me next month.

Your help is really appreciated.

Still not working, now getting a Line 3: Incorrect syntax near '<'. error when I try and parse the query.

The code now looks like

(SELECT CONVERT(VARCHAR(10), MAX(ServiceOrdersJobs.ScheduledDate+2),)

FROM dbo.ServiceOrdersJobs

WHERE dbo.ServiceOrders.UID...

Thanks very much Gail.

I will give it a go