Would the code below work? Would capture anything with 2 or more spaces?

SELECT *

FROM dbo.Postcode AS p

WHERE LEN(RTRIM(p_code)) - LEN(REPLACE(RTRIM(p_code),' ', '')) >=2

Have you got the following installed?

Oracle JRE 7 Update 51 (64bit) or higher.

In addition as part of the SQL installation did you select PolyBase Query Service for External Data? (Feature...

Azure data factory is rather cool. We use this a great deal in our shop.

This script may help in the moving of database files to a new location.

http://www.sqlservercentral.com/scripts/attach/139890/

drew.allen (9/23/2015)

---

Perhaps I'm missing something, but if you want to look specifically at the second ticket, then COUNT is the wrong aggregate. Try the following.

WITH Ticket_Number AS (

SELECT ti.person_ID,...

I did notice no ordering on the data in the table but failed to mention it. My bad.

Yes, you would 🙂

WHERE ti.ticket = 1

We don't use SQL2014 where I work but from a quick search the following link may be of use

https://msdn.microsoft.com/en-us/library/hh231256.aspx

That said, I think based on your test data the...

Quick and dirty:

SET NOCOUNT ON

DECLARE @TicketRange TABLE

(

DateFrom DATE ,

DateTo DATE

)

INSERT...

Similar to above but I thought I would still post it as I was in the middle of doing it anyways 🙂

SET NOCOUNT ON

DECLARE @TicketRange TABLE

(

...

Perfect thanks. I will sleep tonight:w00t: it's been bugging me

Ditto that. Getting stripped out along with the nested cursors.

We use the following in a job which runs every hour. There may and probably will be better ways of doing it but it works for us.

SET NOCOUNT ON

SET...

Worth a shot to try that or reference the text box with the value directly. Without the actual report and data set it's difficult.

Any chance of some sample data and I will have a stab at it 🙂