Hi

it was to say existing table sorry lol

yes I need to select rows where ID is not null and not Total,

I have used...

That worked x brill thanks again

Hi

worked ! thanks team

Hi

that code

SELECT S.CustomerID, CAST(OrderDate AS date)
FROM #Sample S
GROUP...

Hi

I don't understand sorry..this is an example of the data I am using

I am trying to split customer id 3, time between am and pm,...

Hi

data like this

CustomerID   Department    Session    Date Time     Start     End    Time (used for time left session count)
1                     softplay            AM         01/01/2001    09:00   10:00   60
2                     softplay            PM         01/01/2001    13:00   15:00   120
3                     softplay            DAY       02/01/2001    09:00   17:00   ...

Hi

I have something like this

CustomerID OrderID  OrderDate               Department
1                  abc1        01/01/2001 09:00   Home
1                  abc2        01/01/2001 09:30   Children
1                  abc3        01/01/2001 09:35   Home
1                  abc4        01/01/2001 10:50   Catering
1                  abc5        02/01/2001...

yours x

Where Coalesce(A.Department, B.Department, '0') <> '1'

thanx again

Hi

thanx amazing..worked a treat

Kind Regards

Hi

I have got this far using your query

SELECT dateadd(hour, datediff(hour, 0, a.StartDate ), 0) as TimeStampHour, Count(*)

FROM Database.dbo.MainTable a

Where a.StartDate >='20160101'

and a.Department like 'Catering%'

GROUP BY dateadd(hour, datediff(hour, 0,...

Hi

this worked !!! thank you

hi

because I have made a column row_num, it does not recognise it if I just say at end of view

Where ArrivalDate Between '20110101' and '20111231'

and row_num = 1

says invalid...

hi

this works brill within my view

, ROW_NUMBER() OVER(PARTITION BY a.StudentID

ORDER BY CASE WHEN b.[VehicleType] = 'CAR' THEN 1 ELSE...

I basically wish to say if, you see if VehicleID >2 (Duplicate), keep record with VehicleType CAR and not return Train record

please help within the view