Posts
Sort by recent activity
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')...
Question about recent updates
Several years ago I looked at Sql Data Compare (V5 i think). I was impressed with the product, but several limitations prevented me from purchasing. It appears that several of my concerns have be...