Viewing 15 posts - 691 through 705 (of 3,544 total)
Also if your data contains duplicate invoice dates as shown in the result set in your first post then you will need to use DENSE_RANK not ROW_NUMBER.
Plus your two requirements...
May 27, 2014 at 10:00 am
Why not use MIN
SELECT AccountName,MIN(INVOICE_DATE) AS [INVOICE_DATE]
FROM
GROUP BY AccountName
May 27, 2014 at 9:37 am
You could try the ODBC Excel driver (ACE)
You will need to install the relevant version.
I use the 2010 redistributable on 2008R2 64 bit with OPENQUERY to access excel spreadsheets.
May 27, 2014 at 7:31 am
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?
May 27, 2014 at 6:51 am
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)
May 20, 2014 at 7:54 am
Multple posts
refer to http://www.sqlservercentral.com/Forums/Topic1572540-3412-1.aspx
May 20, 2014 at 7:03 am
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...
May 20, 2014 at 6:45 am
SQLRNNR (5/19/2014)
Better yet, what if people just started throwing in a couple hundred pages of fiction (story form) into their SQL books?
As in BOL :w00t:
May 19, 2014 at 8:13 am
STUFF(STUFF(CONVERT(varchar(9),[date],6),1,3,''),4,1,'-')
May 16, 2014 at 6:40 am
vasugunda (5/12/2014)
If you need the code i can post it for you
Yes please I'm curious as to the final solution.
May 13, 2014 at 1:48 am
Lynn Pettis (5/11/2014)
Eirikur Eiriksson (5/11/2014)
thank you both for the input, I appreciate it.
Firstly, this is a valuable discussion and would merit a thread on its own.
Thanks...
May 11, 2014 at 9:53 am
You're far too modest Jeff 😀
Would love to me you in person, if I could ever get across that big pond 🙁
May 11, 2014 at 9:51 am
Lynn Pettis (5/11/2014)
David Burrows (5/11/2014)
Lynn Pettis (5/11/2014)
Eirikur Eiriksson (5/7/2014)
rhythmk (5/7/2014)
vasugunda (5/7/2014)
Hi everyone..i just want retrieve patient information from 1st discharge date to 6 months later date .
Can you please elaborate...
May 11, 2014 at 8:28 am
Lynn Pettis (5/11/2014)
Eirikur Eiriksson (5/7/2014)
rhythmk (5/7/2014)
vasugunda (5/7/2014)
Hi everyone..i just want retrieve patient information from 1st discharge date to 6 months later date .
Can you please elaborate with more clarity as...
May 11, 2014 at 7:34 am
Viewing 15 posts - 691 through 705 (of 3,544 total)