For the record I once did a Christmas season as Michael in Peter Pan at Worthing Connaught Theatre circa 1978 which has never been seen as relevant in my IT...

I think sometimes new people come in (management) and they have their way of doing things. What I don't understand is why they don't explain the justification. As an example,...

DoH :ermm:

drop table ##ss

select 3 as nr, 'a' as kar, 1 as groupingcode into ##SS

insert into ##SS values

(9, 'C',1),

(15,'h',1),

(7, 'e',1),

(6, 'd',1),

(12,'z',1),

(4, 'b',1),

(5, 'q',1)

select * from ##SS

--

-- Get the first row...

Thanks for the piece of code. Very nice. In the grand scheme of things the CTE query executes very quickly but happy to use a better solution.

Great stuff.

Have a...

Or something like this

DECLARE @PatientDATE = '2015-01-04';

DECLARE @Discharged DATE = '2015-01-19';

DECLARE @STARTDATEDATE = getdate();

DECLARE @ENDDATEDATE = getdate()+7;

WITH DateCTE AS (

...

Recursive Date

DECLARE @STARTDATE DATE = getdate();

DECLARE @ENDDATE DATE = '2015-03-21';

WITH DateCTE AS (

SELECT@startdate AS myDate...

try using CTE e.g.

with WeeklyQuery ( Select <your weekly query> )

,cancel_1_Query as ( Select <previous transactions> From weeklyquery

where cancel = 1 And date < weekly_startdate and ticket_id in (select...

You will obviously need to adjust to use your table. I just don't have access to your data hence why it's hard coded. It's the bit underneath which sums up...

So does this not give you what you need?

--DROP TABLE #WorkTable;

SELECT RowNum = ROW_NUMBER() OVER (PARTITION BY i_ticket_id ORDER BY dt_when)

,i_transaction_id

...

I don't quite understand the issue here (sorry), but are you trying to find the difference between Cancelled and Non Cancelled for given ticket?

If so would something like the...

this is a great function. thanks for posting.

In response to the previous reply, if you want to ignore the Holiday table you can use the following (Feel free to...