sharon.ferrer (9/30/2013)

---

I have a table name Employee Logs

table consist of EmpID, Empname,Logdatetime.

I can generate the first in and last out by using max and min. Unfortunately there is an employee...

Can you post the code for the sproc?

Are the NVARCHAR(MAX) column types necessary?

DECLARE @PropertyRepairsHistory Table

(

Jobnumber INT

, PropertyReference NVARCHAR (max) --

, JobTitle nvarchar (60)

, Priority nvarchar (20)

, JobType nvarchar (20)

, Contractorcode nvarchar (4)

, Contractor nvarchar...

How long do the two remote queries take to run and how many rows are returned?

SELECT *

FROM OPENQUERY (ingres2, '

SELECT repheader.repairno

, repheader.propref

, repheader.repairdesc

, priority.decode

, reptype.code

, workforce.wforcecode

, workforce.wforcename

,...

dastagiri16 (9/25/2013)

---

hi,

I have a table like

id city

1 A

so i want to update city column from A to B...

-- solution

;WITH SampleData AS (

SELECT test = 'my email is Test@email.com.au how do i capture just the email' UNION ALL

SELECT 'No email address in this string'

)

SELECT test, x3.p3

FROM...

There's a syntax error and a...

Here's your query

SELECT TOP 5

qt.text AS 'SQL',

qstats.total_physical_reads AS 'Total Physical Reads',

qstats.total_physical_reads/qstats.execution_count AS 'Average Physical Reads',

qstats.execution_count AS 'Execution Count',

qstats.total_worker_time/qstats.execution_count AS 'Average...

paulcauchon (9/12/2013)

---

...

If I'm understanding this correctly, we're lining up all of the ID and Color groups in order, and then ascribing row numbers to them. From...

;WITH SampleData (Date, value) AS (

SELECT '01-01-2013', 10 UNION ALL

SELECT '02-01-2013', 20 UNION ALL

SELECT '03-01-2013', 0 UNION ALL

SELECT '04-01-2013', 0 UNION ALL

SELECT '05-01-2013', 30 UNION ALL...

Check if this works. It should generate a count of events per month, including months with no events. If it works then it's a trivial matter to use it as...

dwain.c (9/12/2013)

---

Jack Corbett (9/12/2013)

---

Brandie Tarvin (9/12/2013)

---

Ed,

Go to http://www.sqlsaturday.com and see if there is a way to register for event notifications. That way if one pops up near you...

L' Eomot Inversé (9/12/2013)

---

ChrisM@Work (9/12/2013)

---

Your initialisation code fails with an error. Your expectations are incorrect.

I think this is what you are looking for:

CREATE TABLE #table1(c nvarchar(1));

CREATE TABLE #table2(c nvarchar(1));

INSERT INTO...

Koen Verbeeck (9/13/2013)

---

Too bad SQL Server...

Erland Sommarskog (9/12/2013)

---

Blimey? Must be some lingo local to Port Moresby.

Any way, since I don't think that there was a post with CROSS JOIN for unpivotting, here is an...