Viewing 15 posts - 1,126 through 1,140 (of 2,452 total)
I am confused.....
your original post mentions
The report is ran using Crystal Reports with a EndYear parameter where the end-user enters the membership ending year.
They are entering to see all of...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2015 at 11:03 pm
ChrisM@home (8/19/2015)
ChrisM@Work (8/19/2015)
serviceaellis (8/18/2015)
The worksheet is the result that needs to be produced with the highlighted row.
in the Access file the two tables are:
1. PersonMembership - with all...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2015 at 12:37 pm
serviceaellis (8/19/2015)
Club information WITHOUT membership information.Which should but then also include membership information IF it exists BUT still produce the Club information
please use the "quote" button in your response...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2015 at 11:46 am
....had some time on my hands, so for the benefit of other posters and as a pointer to the OP...here's the data ready to be generated from SSMS
use tempdb;
CREATE TABLE...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2015 at 7:34 am
as a starter....does this get you the required results....??
DECLARE @yr AS int;
SET @yr = 2015;
WITH cteclub
AS (
SELECT DISTINCT
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 19, 2015 at 3:19 am
Alan.B (8/17/2015)
Jeff Moden (8/14/2015)
Alan.B (8/14/2015)
BobAtDBS (8/14/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 18, 2015 at 1:37 am
djones 23745 (8/13/2015)
/First post
I'm new to SQL and i'm in a spot of bother trying to work out how to do something!
I have a database with 1million+ records in and...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 13, 2015 at 4:28 am
what have you tried so far?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 3, 2015 at 12:24 pm
Grant Fritchey (8/3/2015)
Jack Corbett (8/3/2015)
Alvin Ramard (8/3/2015)
SQLRNNR (8/3/2015)
Lynn Pettis (8/3/2015)
ok, thank you very much.
I...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 3, 2015 at 11:42 am
Welsh Corgi (8/3/2015)
How is this?Can you see how it could be Improved?
DECLARE @NextIDs TABLE(UniqueID int primary key)
DECLARE @ThreeYearsAgo datetime
SELECT @ThreeYearsAgo = DATEADD(d, -(3 * 365), GetDate())
as a start, from the...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 3, 2015 at 9:34 am
Jeff Moden (8/2/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 2, 2015 at 12:46 pm
Welsh ...your ideas from a few years back...maybe jog your memory 🙂
http://www.sqlservercentral.com/Forums/FindPost1172289.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 2, 2015 at 9:54 am
sushantkatte (8/1/2015)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 2, 2015 at 6:39 am
I am not sure I follow your logic on the output and am concerned that you may you have oversimplified your problem in your post.
based on what you have provided...here...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2015 at 2:05 pm
is this the book you are referring to?
http://www.sqlservercentral.com/articles/books/89519/
free download
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 1, 2015 at 11:35 am
Viewing 15 posts - 1,126 through 1,140 (of 2,452 total)