select m.mfr_name, ty.fiscalYear, ty.startDate, ty.weeksInYear, ny.fiscalYear nextYear, ny.startDate nyStartDate from tbl_CRM_FiscalCalendar ty with (nolock) inner join tbl_CRM_FiscalCalendar ny with (nolock) on ny.fiscalYear = ty.fiscalYear + 1 and ny.ownerId = ty.ownerId and ny.ownerType = ty.ownertype inner join tblManufacturers m with (nolock) on m.mfr_id = ty.ownerId where ny.startDate <> dateadd( second, 1, ty.endDate ) and ty.ownerType = and ty.ownerId = order by ty.ownerType, ty.ownerId, ty.fiscalYear

Nothing to do

Sending Email

MFR	Fiscal Year		Start Date	Weeks	End Date	Next Year	Next Start
#htmleditformat( mfr_name )#	#fiscalYear#		#lsdateformat( startDate )#	#weeksInYear#	#lsdateformat( _endDate )#	#nextYear#	#lsdateformat( nyStartDate )#