Not enuf. Can you follow the format i suggested in my previous post?

Please provide some sample data, table structure, business rules and expected result, like this format:

Data:

IF OBJECT_ID('tempdb..#t') IS NOT NULL

DROP TABLE #t

CREATE TABLE #T

(

ColA INT

...

This?

;WITHBase As

(

SELECT *

, RN = ROW_NUMBER() OVER (ORDER BY T.TestDate)

, RN1...

I concur 100% and thank you, Lowell 🙂

Can you also please add expected results to the placard the gentleman holds? :w00t:

What makes November the first week of last year?

{Edit: Dint look at the sample data properly}

Now take...

How do you want to handle bus routes that spawn 2 days? Say, the bus starts at 11.45 PM and stops at 1 AM the next day ? How do...

I think the OP needs to find the rows where the status changing form 0 to 1 and vice-versa. WE should consider Status = 2 as Status = 1.

CELKO (7/17/2012)

---

Please stop drawing pictures coloring code. All we really need is the DDL, sample data and specs. It is a bitch to have to edit all that confetti to...

ssc_san (7/17/2012)

---

ColdCoffee (7/17/2012)

---

Meaning, 0,9,13,14,16 will have...

; WITH BaseTable AS

(

SELECT T1.Class

,Names = CASE WHEN T2.Names = '' THEN '''''' ELSE T2.Names END

,T2.PK

,CT = COUNT(CASE WHEN T2.Names...

EXCEPTIONAL REPRESENTATION OF THE PROBLEM!

Hats off 🙂

The code is on ur way!

Meaning, 0,9,13,14,16 will have other entries...

This, probably?

DECLARE

@py_fl BIT ,

@fy INT ,

@p_nm VARCHAR (25),

@pr ...