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...
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...
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...
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...
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
...
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)
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...
August 13, 2015 at 4:28 am
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...
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...
August 3, 2015 at 9:34 am
Jeff Moden (8/2/2015)
August 2, 2015 at 12:46 pm
Welsh ...your ideas from a few years back...maybe jog your memory 🙂
August 2, 2015 at 9:54 am
sushantkatte (8/1/2015)
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...
August 1, 2015 at 2:05 pm
is this the book you are referring to?
http://www.sqlservercentral.com/articles/books/89519/
free download
August 1, 2015 at 11:35 am
Viewing 15 posts - 1,126 through 1,140 (of 2,452 total)