Quick thought, the description of the logic does not fit the expected results, can you please amend either or both?

😎

Quick question, can you post the code for the procedure Abc.DBO.aspRoleFCUD?

😎

Quick questions, what are the memory specs (hardw.,vm,provisioning)? What are the sql server's mem configs?

😎

For completeness, the order by does not work with the over clause prior to 2012

😎

WITH SampleData (PERSON,TRANSACTDATE, STARTDATE, END_DATE, IN_PUNCH,OUT_PUNCH,HOURS) AS

(

SELECT 1234,'08/03/2015','08/03/2015','08/03/2015', '06:00','09:00','3' ...

Limoncello

Quick question, is this a named instance?

😎

Further on Phil's fine answer, recommend adding a POC (Partition, Order, Covering) index on the table, makes a huge difference if the set is large, here is a quick example.

:cool:...

To get the desired result set, we only need to do minor changes to the query, note that there is one "FOR XM" for each nesting level in the output.

😎

SELECT

...

Quick thought, script the restore rather than using same, it is straight forward and doesn't fail as the ui does. If you want I can dig up some of my...

Relation

Have you...

ARC211 (8/20/2015)

---

I have been receiving the following error for 2 days now and I cannot seem to find the root source of the problem:

Date8/20/2015 12:55:50 AM

LogSQL Server (Current - 8/20/2015...

Terminal

Thank you Arun for this write up, good job.

😎

Quick static solution

😎

USE RDSTEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_DATA') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DATA;

CREATE TABLE dbo.TBL_SAMPLE_DATA

(

ItemID INT ...