Recent content by cgarmas

Thank you, this is very helpful. I don't want to abuse of your kindness, but I would like to ask you if you can explain also how the Min(MembId2) and Min(TermDate) work in this case. Cgarmas

George, I wanted to thank you for your help and all the work you put on this, I had to abandon this project for a while but I finally got back to it and got the results I needed from the code you developed. I only have one question though, just to try to understand how the code works, how does...

The expected results would be as follows> rows with empty TermDate cells are because these members are still enroll. As I am interested in the enrollment segments based on the unique MemberID, those segments with enrollment and terminartion date on the same day are to be ignored and excluded...

this is a good sample of duplicate situations. ----------------------------------------------- MemberID MembID2 EnrollDate TermDate 8187 1010602-00 19960109 8187 1010602-10 19960109 19970317 8187 1003533-11 19980128 19990505 8187 1003533-11 19990506 20000731 16978...

Yes, I identified the duplicate records. This data is a little tricky, In this database we have two fields that have MemberIDs, one is the MemberID, and MemberID2, the first one stores the unique ID for each member, but the same member may have multiple MemberID2. The problem is that some times...

I excluded the records with NULL MemberID, but I got this message: "Violation of PRIMARY KEY constraint 'PK__@Data__571B2BD2'. Cannot insert duplicate key in object '#56270799'."

You are right, there were some records that have a NULL value for MemberID

I got the following error message when I tried getting the data into the table variable. "Cannot insert the value NULL into column 'UniqueId', table '@Data'; column does not allow nulls. INSERT fails.

I tried this approach, but due to the large number of records in the data set: over 500,000 records; to process this is taking several hours and is not done yet, and I am causing a problem to other people with the server. Is there any other way I can do this that can be more efficient in terms...

Thank you George, I'll try this first thing in the morning.

Hi all, I am using MS SQL and I need help with creating a column were I can add a sequantial numbering of groups of records based on sequantial dates. The table structure is as follows MemberID EnrollDate TermDate 001 01/01/2005 05/30/2005 001 07/01/2005 09/30/2005 001...

Hello everyone. I desperately need help with this project, and I will appreciate any suggestions. I have a Main form with a subform, which in turn has another subform with a tab control with other three forms in each tab. Each form corresponds to a separate table each. I set up this form to add...

Thanks again Leslie, and I do have more questions. These are some of the tables I am creating and I am trying to figure out the best way to link them. TblClients ClientID TblEnrollment EnrollmentID ClientID EnrollmentNumber (first,second..) EnrollmentDate Prenatal/Postpartumperiod...

Leslie, I think the suggestion of the Enrollment table is great, and the suggested reading was helpful, but I jus have one more question; would it be appropriate instead of having two tables, the clients table and the enrollment table to have just one table like this: UniqueID PK (autonumber)...

Thanks for the reply, unfortunatelly this is a little bit more complicated because each patient whether they come to the clinic in their prenatal or posnatal care, they may enroll in the program multiple times for a new pregnancy or posnatal care, in which case we have a field EnrollmentNumber...