Posts
Sort by recent activity
Very minor bug in "expand wildcard"
I know this is a minor issue but it's so odd I thought I would pass it along. Looking at the following code SELECT *FROM( SELECT rpt_rec_num, LEFT(cell_row, 3) AS cell_row, ...
string_agg not recognized as a grouping function
Running version 9.1.1.4243 I had following code SELECT TOP ( 50 ) cd.RPT_REC_NUM , cd.component , cd.sheet , cd.cell_row ...
Format fails if SQLCMD mode variable is present
the following
UPDATE [provider_master]
set FIPS = p.fips_code,
MSA = p.msa_code,
longatude = p.fac_long,
latatude = p.fac_lat
FROM provider_master ...
Update without where warning
While I like the intent of the warning of update/delete without a where clause, I find myself having frequent issues with code like the following :
UPDATE [wk_srv]
SET [surg_disch_mc&#...
Format SQL function fails if SQLCMD mode variable is present
The following code
SELECT * FROM dbo.sheet_master
WHERE RPT_REC_NUM IN ( SELECT RPT_REC_NUM
FROM Cost_report_$(HCycleN).dbo.rrn_status
WHERE Rec_status = 'dropped'
)
will...
Minor bug with Shift-F5
the following query
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 ...
$SELECTEDTEXT$ only expands once
Using 7.0.0.40
setup a new snippet
sum ( $SELECTEDTEXT$ ) as tot_$SELECTEDTEXT$
when it expands the $SELECTEDTEXT$ only expands the second time it appears
Example result
sum ( $SELECTEDTEXT$ ) as t...
"Close all but this" can hang SSMS
If a tab is "executing" the standard "close tab" function prompts to "cancel the Executing query" or the "cancel the close" But the two Sql Prompt "Close all but this" and "Close all unmodi...
Not finding object in explorer if refresh is need
Select object in explorer is great, but it the object has just been created and is not appearing in the list because a "refresh" is needed, then it is not found. Consider forcing a refresh, if not ...
Formatting Bug
If I start with the following code
SELECT *
INTO #tmp2
FROM ( VALUES ( 'A703', '00100'), ( 'A703', '00200'), ( 'A803', '01200'),
( 'G200', '01100')...