d.krishnap (1/26/2015)

---

CREATE TABLE BILL_DETAIL

([objid] int,[x_billable_to] varchar(19), [x_bill_quantity] int,

[x_billable_yn] int, [x_bill_rate] int, [COST_TYPE] varchar(19) )

;

INSERT INTO BILL_DETAIL

([objid], [x_billable_to], [x_bill_quantity], [x_billable_yn], [x_bill_rate],[COST_TYPE])

VALUES

(1, 'Customer', 3, 1,...

Jeff Moden (1/26/2015)

---

I don't do links for two reasons... 1) is that I don't actually know what's there and don't want to take the chance going there and 2) is...

Carlo Romagnano (1/27/2015)

---

Strange, but the version with PIVOT is a bit slower than that with GROUP BY. See execution plan!

with c

as(

SELECT * FROM (VALUES

(1,2013,1,100)

,(1,2013,1,200)

,(1,2014,0,500)

,(1,2014,1,200)

,(2,2013,1,200)

,(2,2013,1,200)

,(2,2014,1,100)

,(2,2014,1,100)

) AS V([Customer],[Salesyear],[Complete],[Amount])

)

SELECT

*

...

Snargables (1/26/2015)

---

the idea is we have a table that has available coupon codes from there different locations. I need to select from all three environments and get the top one...

Ed Wagner (1/26/2015)

---

TomThomson (1/26/2015)

---

SQLRNNR (1/26/2015)

---

Grant Fritchey (1/24/2015)

---

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines...

Jack Corbett (1/26/2015)

---

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there...

Jeff Moden (1/23/2015)

---

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there are almost...

WayneS (1/23/2015)

---

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there are almost 200...

Jeff Moden (1/23/2015)

---

Ed Wagner (1/23/2015)

---

Sean Lange (1/23/2015)

---

Ed Wagner (1/23/2015)

---

Sean Lange (1/23/2015)

---

Ed Wagner (1/23/2015)

---

sharonsql2013 (1/23/2015)

---

I have a column in the table with datatype DATE

Gives data in the format

YYYY_MM_DD

How can I go...

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there are almost 200 parameters and another...

Oops forgot to include partition.

SELECT variable1 AS PatientBillingID

, ROW_NUMBER() over (partition by variable1 order by variable1 desc) - 1 as RowNum --added the minus 1 since ROW_NUMBER starts with 1

You...

Ed Wagner (1/23/2015)

---

Sean Lange (1/23/2015)

---

Ed Wagner (1/23/2015)

---

sharonsql2013 (1/23/2015)

---

I have a column in the table with datatype DATE

Gives data in the format

YYYY_MM_DD

How can I go back to past 12 months in...

This should produce the results you have in your example.

SELECT variable1 AS PatientBillingID

, ROW_NUMBER() over (order by variable1 desc) - 1 as RowNum --added the minus 1 since ROW_NUMBER...

surf4profit (1/23/2015)

---

Sorry I tried to edit the original post and could save the edit.

I have a query that I need to add a sequence to for a report and I...

Are we supposed to fill in the blank?

I am going to guess "purple man eating elephant".