Why not use MIN

SELECT AccountName,MIN(INVOICE_DATE) AS [INVOICE_DATE]

FROM

GROUP BY AccountName

You could try the ODBC Excel driver (ACE)

https://www.simple-talk.com/sql/database-administration/getting-data-between-excel-and-sql-server-using-odbc--/

You will need to install the relevant version.

I use the 2010 redistributable on 2008R2 64 bit with OPENQUERY to access excel spreadsheets.

Out of curiosity why are you using subreports?

Could you not put the chart and table in the main report and set their visibility accordingly?

Well they look the same to me

You will need to provide both queries and how they relate to each other (ie columns to match on)

Multple posts

refer to http://www.sqlservercentral.com/Forums/Topic1572540-3412-1.aspx

Standard pivot

;WITH cte (T_ID,Teacher_Name,Appr_ID,Approver_NAME,ColID) AS (

SELECT T_ID,Teacher_Name,Appr_ID,Approver_NAME

,ROW_NUMBER() OVER (PARTITION BY T_ID ORDER BY Appr_ID ASC)

FROM result)

SELECT T_ID,Teacher_Name

,MAX(CASE WHEN ColID = 1 THEN Appr_ID END) AS [Appr_ID1]

,MAX(CASE WHEN ColID = 1...

As in BOL :w00t:

STUFF(STUFF(CONVERT(varchar(9),[date],6),1,3,''),4,1,'-')

Yes please I'm curious as to the final solution.

I hope all goes well 🙂

Lynn Pettis (5/11/2014)

---

Eirikur Eiriksson (5/11/2014)

---

Hi David and Lynn,

thank you both for the input, I appreciate it.

Firstly, this is a valuable discussion and would merit a thread on its own.

Thanks...

You're far too modest Jeff 😀

Would love to me you in person, if I could ever get across that big pond 🙁

Lynn Pettis (5/11/2014)

---

David Burrows (5/11/2014)

---

Lynn Pettis (5/11/2014)

---

Eirikur Eiriksson (5/7/2014)

---

rhythmk (5/7/2014)

---

Can you please elaborate...

Lynn Pettis (5/11/2014)

---

Eirikur Eiriksson (5/7/2014)

---

rhythmk (5/7/2014)

---

Can you please elaborate with more clarity as...

Eirikur Eiriksson (5/11/2014)

---

Jeff Moden (5/10/2014)

---

If you want real performance, I'd recommend that you stop counting altogether. Indexed views have an overhead on inserts in that they have to recalculate...