select max(purchasingmonth) as purchasingMonth from tbl_dw_operatoranalyzer_#client.ownertype##client.ownerid# where ownerid = and ownertype = select count(*) as historyCount from tbl_dw_operatorAnalyzer_#client.ownertype##client.ownerid# az with (nolock) where ownertype = and ownerid = and cho_id = and skuid = --and datediff(d,purchasingMonth,getdate()) <= 365 and purchasingMonth between and select sku from tbl_prd_skus with (nolock) where skuid = and ownerid = and fsl_tablecode = select count(*) as historyCount from tbl_dw_operatorAnalyzer_#client.ownertype##client.ownerid# az with (nolock) where ownertype = and ownerid = and cho_id = and prodid = --and datediff(d,purchasingMonth,getdate()) <= 365 and purchasingMonth between and select product from tbl_prd_products with (nolock) where prodid = and ownerid = and fsl_tablecode = select count(*) as historyCount from tbl_dw_operatorAnalyzer_#client.ownertype##client.ownerid# az with (nolock) where ownertype = and ownerid = and cho_id = --and datediff(d,purchasingMonth,getdate()) <= 365 and purchasingMonth between and select o.cho_name, o.cho_address, o.cho_address2, o.cho_city, o.cho_state, o.cho_zipcode, o.cho_phone, o.cho_url, seg.segment, o.cho_type, dwopr.affiliationName_1, dwopr.affiliationName_2, dwopr.affiliationName_3, dwopr.affiliationName_4 from tbl_cho_operators o with (nolock) left outer join tbl_opr_segments seg on seg.segmentid = o.cho_segmentid left outer join tbl_dw_1fsOperators_#client.ownertype##client.ownerid# dwopr with (nolock) on dwopr.choid = o.cho_id and dwopr.ownerid = and dwopr.ownertype = where o.cho_id =


#htmleditformat(qryOperator.cho_name)# #qryOperator.cho_address# #qryOperator.cho_address2# #qryOperator.cho_city#, #qryOperator.cho_state# #qryOperator.cho_zipcode# #qryOperator.cho_phone# #qryOperator.cho_url#

PURCHASING