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...
Far away is close at hand in the images of elsewhere.
Anon.
May 27, 2014 at 10:00 am
Why not use MIN
SELECT AccountName,MIN(INVOICE_DATE) AS [INVOICE_DATE]
FROM
GROUP BY AccountName
Far away is close at hand in the images of elsewhere.
Anon.
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.
Far away is close at hand in the images of elsewhere.
Anon.
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?
Far away is close at hand in the images of elsewhere.
Anon.
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)
Far away is close at hand in the images of elsewhere.
Anon.
May 20, 2014 at 7:54 am
Multple posts
refer to http://www.sqlservercentral.com/Forums/Topic1572540-3412-1.aspx
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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:
Far away is close at hand in the images of elsewhere.
Anon.
May 19, 2014 at 8:13 am
STUFF(STUFF(CONVERT(varchar(9),[date],6),1,3,''),4,1,'-')
Far away is close at hand in the images of elsewhere.
Anon.
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.
Far away is close at hand in the images of elsewhere.
Anon.
May 13, 2014 at 1:48 am
I hope all goes well 🙂
Far away is close at hand in the images of elsewhere.
Anon.
May 11, 2014 at 10: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...
Far away is close at hand in the images of elsewhere.
Anon.
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 🙁
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
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...
Far away is close at hand in the images of elsewhere.
Anon.
May 11, 2014 at 7:34 am
Viewing 15 posts - 691 through 705 (of 3,544 total)