#lsdateformat( _fromDate, "mm/dd/yyyy" )# ---TO--> #lsdateformat( _toDate, "mm/dd/yyyy")# select opportunityId, mfrId, ownerId, ownerType, mfr_name from tbl_SPL_Opportunities spl inner join tblManufacturers m on m.mfr_id = spl.mfrId where spl.ownerId = and spl.ownerType = and spl.stageId in ( select stageId from tbl_SPL_Stages where statusCode in ( ) and ownerId = and ownerType = ) and spl.availableDate = update tbl_SPL_Opportunities set mfrPlanStart = , mfrPlanEnd = , mfrPlanYear = , mfrPlanWeeks = , availableDate = where opportunityId =

#htmleditformat( _planDates.mfrName )#	#lsNUmberformat( _planDates.opportunities )#
	#lsnumberformat( qmd_opportunitiesToUpdate.recordCount )#

select ownerId, ownerType, opportunityId, mfrId, availableDate, mfrPlanStart planStart, mfrPlanEnd planEnd from tbl_SPL_Opportunities where opportunityId = and ownerId = and ownerType = update tbl_SPL_Opportunities set mfrPlanStart = , mfrPlanEnd = , mfrPlanYear = , mfrPlanWeeks = where opportunityId =