Minor bug with Shift-F5
eklein@ahd.com
Posts: 17 Bronze 2
the following query
will run and gives the results I expect. Sql Prompt can format it, but the Shift-F5 feature fails without highlighting any issue
Not a big deal; Select and F5 works fine, Just thought it might be indicative of a bigger issue you should be aware of
SELECT COUNT(*) AS occurs , dt2.sheet_g FROM ( SELECT dt.RPT_REC_NUM , Ed_sandbox.dbo.strconcat(RTRIM(dt.fld_name)) AS sheet_g FROM ( SELECT TOP 100 PERCENT RPT_REC_NUM , fld_name FROM cell_data WHERE ( fld_name IN ( 'E00A_59-1', 'E301_18-1', 'E302_31-1', 'E303_32-1', 'E304_22-1', 'E305_30-1', 'E306_15-1', 'E307_40-1' ) ) AND ( component LIKE '__18' ) GROUP BY RPT_REC_NUM , fld_name ORDER BY RPT_REC_NUM , fld_name ) dt GROUP BY dt.RPT_REC_NUM ) dt2 GROUP BY sheet_g ORDER BY sheet_g;
will run and gives the results I expect. Sql Prompt can format it, but the Shift-F5 feature fails without highlighting any issue
Not a big deal; Select and F5 works fine, Just thought it might be indicative of a bigger issue you should be aware of
Comments
If you open a new query window with just that statement in and run shift+F5 does it work for you? I'm wondering if there might have been an error in the preceding statement which stopped it from being executed.
Thanks,
Aaron.