Viewing 15 posts - 16 through 30 (of 92 total)
What's proper when giving an Alias here?
Split2 = "FROM ( SELECT PersonId, ISNULL( OrganizationName, 'Individual' ) HomeClub, MembershipTypeId, InvoiceNumber, EndDate " & _
...
August 26, 2015 at 9:55 am
J Livingston SQL (8/26/2015)
TSQL
FROM attribute.PersonMembership LEFT OUTER JOIN USFSA.dbo.SOP10100 AS invWork
Excel
"FROM...
August 26, 2015 at 7:52 am
Alvin Ramard (8/25/2015)
Looks like you're using pm as an alias twice; on the 2nd line of Split2 and at the end of Split3.
Does that matter?
Strange thing is nothing has changed...
August 25, 2015 at 6:06 pm
Anyone see why there's a syntax error on 'pm' from the function?
August 25, 2015 at 2:45 pm
Sorry, I'm not following on the relevance of how many records there are.
issue is with a syntax error.
otherwise would like to find how to set the hard date range to...
August 25, 2015 at 2:04 pm
I realize this is a SQL forum and why I've only shared the SQL.
And in SSMS it produces the results.
However in Excel there's this Function:
...
August 25, 2015 at 1:54 pm
J Livingston SQL (8/25/2015)
out of curiosity....what is the size of the data you are dealing with...eg number of rows in your tables?
in the date range there's 36,501 records
August 25, 2015 at 1:52 pm
The issue, I think for me, is it's subquery. Therefore, the way I know how to link the SQL in Excel, you do not see those fields in question.
If they...
August 25, 2015 at 1:24 pm
Alvin Ramard (8/25/2015)
How is the user going to...
August 25, 2015 at 11:53 am
Yes, I added the MembershipTypeID IN (1,2,3,4) in the last updated View you provided.
I think, aside from that one lone record ending in 2017 being a member type 1, I...
August 23, 2015 at 3:18 pm
Glad you have what you are looking for. One question remains. How are you deciding which years appear in the parameter list? I ask because if the user selects 2016,...
August 22, 2015 at 9:09 pm
Thank you very much!
Data seems to be resulting the way it's expected on the reporting side with an edit in the Report | Select Expert on Record.
{v060ClubOfficersPresidentMbrCounts.YearEnd} in {?Enter...
August 22, 2015 at 7:07 pm
Lynn Pettis (8/21/2015)
August 21, 2015 at 1:46 pm
J Livingston SQL (8/21/2015)
Steve's seems to be working, in my test db environment. But due to the EndYear not being a field and I can't figure out how to edit...
August 21, 2015 at 1:35 pm
J Livingston SQL (8/21/2015)
serviceaellis (8/21/2015)
Thank you for the link on Using SP!
This is also to sgmunson,
On the question of Crystal, again I thought I answered it.
The end-user enters...
August 21, 2015 at 12:41 pm
Viewing 15 posts - 16 through 30 (of 92 total)