Does anyone know the correct synatx to the option query hint keep plan BOL God bless it is sometimes sparce in its explanations.
TIA, Josh SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into ##DA69EE60673311D6B9B3000AD1311671 FROM vw_CTMCORPAPPFULLVIEWprod option query_hint, keep plan where (requestor like 'OVD%') and year = 2001 GROUP BY reg_NO, y_id, M_id ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
