See http://www.sqlteam.com/article/datediff-function-demystified

DECLARE@Sample TABLE

(

polnum int,

startdate datetime,

enddate datetime,

policyholder varchar(200),

policy varchar(200)

)

Set dateformat dmy

INSERT@Sample

SELECT1000012, '01/01/2008', '31/12/2008', 'Joe bloggs', 'CycleIns' UNION ALL

SELECT1000013, '12/08/2008', '17/08/2008', 'Dave Smith', 'TravelIns'...

Are you sure the @SystemUser variable gets set?

SELECTSUM(CASE WHEN CONVERT(CHAR(8), Col1, 114) >= '07:30:00' AND CONVERT(CHAR(8), Col1, 114) < '16:00:00' THEN 1 ELSE 0 END) AS [7:30am to 4pm],

SUM(CASE WHEN CONVERT(CHAR(8), Col1, 114) >= '16:00:00' AND CONVERT(CHAR(8),...

LEFT JOIN(

SELECTPartyID,

MAX(CASE WHEN QuestionID = 13 THEN Col1 ELSE NULL END) AS sd13,

MAX(CASE WHEN QuestionID = 15 THEN Col1 ELSE NULL END) AS sd15,

MAX(CASE WHEN QuestionID = 16 THEN Col1...

Here is a CURSOR solution that scales excellent.

10 times the sample data, 10 times the time.

SET NOCOUNT ON

CREATE TABLE#Source

(

RowID INT PRIMARY KEY CLUSTERED,

RowKey INT,

Locale VARCHAR(10)

)

INSERT#Source

SELECT 1, 5, 'en' UNION ALL

SELECT...

ALTER proc dbo.getMaxval

(

@AllocId bigint,

@Cnt int output

)

as

set nocount on

select@cnt = max(cnt)

fromAllocationVisit

whereAllocId = @AllocId

set @cnt = coalesce(@cnt, 0) + 1

I hope you meant

SELECT FromLocation AS theLocation FROM tablename

UNION

SELECT ToLocation FROM tablename

SELECTCol,

Col2,

Col3,

Col4,

Col5

FROM(

SELECTCol,

Col2,

Col3,

Col4,

Col5,

ROW_NUMBER() OVER (PARTITION BY Col1, Col2 ORDER BY Col3 DESC) AS RecID

FROMTable1

) AS d

WHERERecID = 1

There can be a number of reasons for this query to go slow.

Check out execution plans. See if there is some parallellism gone bad on x64 server.

Check out NTILE() function.

DECLARE@Sample TABLE

(

ID BIGINT

)

INSERT@Sample

SELECT3202306000 UNION ALL

SELECT3202307500 UNION ALL

SELECT3202307503

SELECT DISTINCTs.ID,

s.ID + x.Number AS Yak

FROM@Sample AS s

CROSS JOIN(

SELECT0 AS Number UNION ALL

SELECT1 UNION ALL

SELECT2 UNION ALL

SELECT3 UNION ALL

SELECT4

) AS x

See http://www.sqlservercentral.com/articles/Advanced+Querying/howmanymoremondaysuntiliretire/2475/

Then you were wrong this time, I am sorry to say.

Read the query.

Because you want to filter out ALL records for same coID group if ANY of the records has an mCT = 'Y' value.

http://www.sqlmag.com/Article/ArticleID/92888/sql_server_92888.html

Itzik Ben-Gan

Creating a clustered index on a table does not guarantee that the

data is stored in the file in index key order. Data movement caused

by page splits, changing...