Thanks for this

Tried that Sanz - but get the same error.

The instance is named - how do I start that instance in Single mode?

Thanks

Morning Guys,

I'm trying to do the following.

In my SELECT Statement I am using DATEDIFF to calculate some difference in dates. As below -

SELECT DATEDIFF(day, MAX(dbo.[IH_IH-LOCATION-STAT-HIST].[RECEIVED-KEYS])

,MAX(dbo.[IH_IH-LOCATION-STAT-HIST].[READY-TO-LET])) AS 'Days_with_Voids'

,DATEDIFF(day, dbo.[IH_RE-TENANCY].[tncy-end]

,MAX(dbo.[IH_IH-LOCATION-STAT-HIST].[READY-TO-LET]))...

Messed up this post - let me explain it better what I am trying to achieve

Thanks Guys.

Done the trick

Thanks for this.

Done the trick

SELECT INV.Reference AS 'Invoice Reference'

,INV.InvoiceDate AS 'Invoice Date'

...

Thanks so much. I was putting "something" similar to what you suggested but couldn't quite make it 🙂

Thanks for the suggestion on the alias. I usually do but have inherited...

Thank you so so much.

Exactly what I was after.

Results still not working I'm afraid -

SELECT 0 AS RecordStatusID

,LEFT(COALESCE(STOCK.postcode + N'/','') + STOCK.address1 ,30)AS ShortName

...

Just to say Thanks.

This worked.

Oh sorry John. It is limied to the first 30 characters. I will give it a go.

Thanks

In my CASE statement I want my results to be limited to 30 characters.

So in the ELSE part of the statement I have

ELSE PROP.postcode + N'/' + PROP.address,...

Thanks

Thanks guys.

Both work.

Was driving me mad!! 🙂