Quick thought, in order to provide meaningful answer to your question, some more information is required. Could you post DDL, sample data and preferably the actual execution plans for both...

Quick question, can you provide the actual query and the table structure?

😎

Quick solution for educational and entertainment purposes (read "spanner in the works") using slight modification of Jack Corbett's data preparation.

😎

USE tempdb;

GO

SET NOCOUNT ON;

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

CREATE...

Koen Verbeeck (11/12/2014)

---

Eirikur Eiriksson (11/12/2014)

---

Koen Verbeeck (11/12/2014)

---

Eirikur Eiriksson (11/12/2014)

---

Koen Verbeeck (11/12/2014)

---

David Burrows (11/12/2014)

---

However max(rate) over( partition by product) will not work if the rate varies +/- and the latest value...

Koen Verbeeck (11/12/2014)

---

Eirikur Eiriksson (11/12/2014)

---

Koen Verbeeck (11/12/2014)

---

In...

Just tried this on SQL Server 2014 and it throws an error:

Msg 9456, Level 16, State 1, Line 1

XML parsing: line...

Koen Verbeeck (11/12/2014)

---

In that case an ORDER...

Quick suggestion, use the row_number function

😎

USE tempdb;

GO

SET NOCOUNT ON

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

create table dbo.test

(

product varchar(50),

QTY int,

...

duggal.priyanka06 (11/11/2014)

---

Hi

I have an excel file which has dynamic columns

i.e. Col1, Col2, Col3 this week. next week i will have a new Col4 in the sheet. This will keep...

Further on John Corkett's post, the [COLUMN SET] bridges the gap between a normal table and an EAV type table. Standard set based approach can be used on the database...

Another question, is this a default or a named instance?

😎

Tony Webster (11/11/2014)

---

We were having trouble redefining a stored procedure, and got the test case down to this:

CREATE PROC testproc

AS

SELECT 123

-- CONVERT(varchar)

GO

which on one particular server gives:

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData...

lizamungro (11/11/2014)

---

I'm new to using SQL Server. I've been asked to optimize a series of scripts that queries over 4 millions records. I've managed to add indexes and remove a...

BWFC (11/11/2014)

---

Stuart Davies (11/11/2014)

---

BWFC (11/11/2014)

---

One of the people whose name I've seen attached to the kitchen cabinets spam lives just down the road from me. He's a reasonably notorious...

Quick note, as LinksUp noted, the parentheses do not match, there is an extra opening one before the first instance of T0.DiscPrcnt. To prevent/detect this kind of errors, I find...