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...

chandrachamarthi8 (11/10/2014)

---

Msg 2760, Level 16, State 1, Line 1

The specified schema name "coustmer" either does not exist or you do not have permission to use it.

i got this error ..any...

Goes without saying:-D

Glad to help, just realize that this is a limited solution, only single digit joining between the different nodes, will...