Yes sir, so you're saying create 3 tables? This is what the total table looks like
(The, exp, company, image and onFile follow the same pattern for all) profileID, -- Bit cprAdultExp, -- Date cprAdultcompany, -- NvarChar cprAdultImage, -- Nvarchar cprAdultOnFile,Boolean cprInfantChildExp, cprInfantChildcompany, cprInfantChildImage, cprInfantChildOnFile, cprFPRExp, cprFPRcompany, cprFPRImage, cprFPROnFile, aedExp, aedcompany, aedImage, aedOnFile, firstAidExp, firstAidcompany, firstAidImage, firstAidOnFile, emtExp, emtcompany, emtImage, emtOnFile, waterSafetyInstructionExp, waterSafetyInstructioncompany, waterSafetyInstructionImage, waterSafetyInstructionOnFile, bloodPathogensExp, bloodPathogenscompany, bloodPathogensImage, bloodPathogensOnFile, oxygenAdminExp, oxygenAdmincompany, oxygenAdminImage, oxygenAdminOnFile, lifegaurdingExp, lifegaurdingcompany, lifegaurdingImage, lifegaurdingOnFile, wildernessResponderExp, wildernessResponderCompany, wildernessResponderImage, wildernessResponderOnFile, certNotes -- nvarchar(4000) >One more note ... > >Do you have any control over table schemas? If you have to filter on that >many columns, and every row has all those columns, then the table really >needs to be broken into three, one with the profiles, one with the >certifications, and one joining the two with the expiration date. That would >make the data retrieval really easy. > >That would really be your best bet. > >--- Ben--> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341144 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
