SELECT *,

[Duration] = DATEDIFF(SECOND, c.TakenDate, c.CompletedDate),

[Response Time] = DATEDIFF(SECOND, c.CreatedDate, c.TakenDate)

FROM #CONSULTATION c

ganapathy.arvindan (6/17/2016)

---

I have table called logininfo where each employee gets on record if he is present on that day..i need ur help to calculate total working days of the month

CREATE...

What does the 12345 represent?

DECLARE @FromDate DATE = CONVERT(DATE,'01.05.2016',104);

WITH Table1 (ItemNr, FromDate) AS (

SELECT 1 , CONVERT(DATE,'01.01.2016',104) UNION ALL

SELECT 1 , CONVERT(DATE,'01.02.2016',104) UNION ALL

SELECT 2 , CONVERT(DATE,'01.01.2016',104) UNION ALL

SELECT 2 , CONVERT(DATE,'01.02.2016',104) UNION ALL

SELECT...

dudekula.kareemulla (6/17/2016)

---

Hi,

I have a table 'AAA'

Structure:

CREATE TABLE AAA (ID BIGINT PRIMARY KEY CLUSTERED,Name VARCHAR(225) NULL,UAN BIGINT NOT NULL)

Assume that this Table Having 75 million of records.

Here I am going to...

eleduke (6/16/2016)

---

2 posts up the sq.png shows the results

When I query the entityname table with a value copied from the namefile table I get the results I was looking...

This remains unanswered:

ChrisM@Work (6/16/2016)

---

Choose a...

eleduke (6/16/2016)

---

ok so

This works fine select * from EntityName e where e.EntityName = '17L-52W7 KVAR'

But this returned nothing select * from namefile n where n.Listname = '17L-52W7 KVAR'

So there seems...

Choose a single value from...

Check your column names.

What does the staging table contain? select * from namefile.

Unable to repeat OP's results...

Is this you testing...

Just curious...since EXEC DailyReport_sp 'MyTablename' is exactly equivalent to...

;WITH MyOne AS (yada yada yada)

INSERT INTO #dummy1

(tqm_call_data_id, std_questions_selected, Dept, call_reference_no)

SELECT tqm_call_data_id, std_questions_selected, Dept, call_reference_no

FROM MyOne

Kingston's link doesn't work for me either.

Find section [Figure 22: Testing Functionality]...