Search
-
Bug - Semicolons added to GO if GO followed by CTE (WITH)
SQL Prompt: 9.0.9.3951 (latest as of this writing) Simplest reproducible I was able to come up with (entirety of the script): SELECT a=1; GO WITH base AS (SELECT b=1) SELECT * FROM base o; -- Result: SELECT a=1; GO; -- <<== ADDS INVALID SEM-COLON WITH base AS (SELECT b=1) SELECT * FROM base o; -- NOTE: Issue does not occur… -
Can I fix this in my setup options?
Discussion by jeffsturgeon2002 · · Home› Discontinued and Previous Versions› SQL Refactor Previous VersionsSQL Refactor first off looks like it will save me hours of tedious work. I purchased SQL Prompt and love it. I am demo testing Refactor to see if its something I may wish to purchase. My code is getting set like this: '120.Insured1Zip' = CASE WHEN COALESCE(pi.InsuredSameAsPatient, 1) = 1 THEN pp.zip WHEN… -
ratio internals
I have a simple web-site - 3 independent pages - page1, page2 & page3 I wrote a load with 3 simple actors (get1, get2, get3), each one waiting 400ms and then getting one copy of the corresponding page. When I run this load for 1 minute with ratios 1:1:1 and 3 virtual clients the pages are retrieved in approximately equal… -
Minor bug with Shift-F5
the following query SELECT COUNT(*) AS occurs , dt2.sheet_gFROM ( 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',… -
Re: Random row selection in table to table synchronization.
table2: accttype acctnum 1 xxxxx123xxxx 1 xxxx452xxxx 1 xxxx654xxxx 2 xxxxx487xxxx table1: name accttype acctnum Joe 1 123456 John 1 456248 Jame 2 154785 Jxxx 1 457885 Now I want to synchronize table1 with table2 based on accttype column. Now when I do table to table sync, the output is: table1: name accttype acctnum Joe 1… -
SCA doesn't create new schema in an existing database
So I'm trying to bring an existing production database under source control. I created a Visual Studio project and successfully created a baseline from the production database in my local environment. The db didn't already exist locally so was correctly created by SCA. When I try and release via Azure DevOps to our "Build"… -
Backup Succeeds but fails on VERIFY
Please help! We have a backup process that keeps on failing on the VERIFY portion. Tested directing the backup to local disk and network, same behavior. Did the sqbutility too. Backup successfully completes yet on the verify portion, it says that the media family on device is incorrectly formed. Please see below message:… -
Formatter removes table from columns in WHERE clause even when it's ambiguous otherwise
First, here is the sample code: CREATE TABLE dbo.#Isolates ( MICSourceID VARCHAR(3) ,VisitID VARCHAR(256) ,PatientID VARCHAR(256) ,AccountNumber VARCHAR(256) ,UnitNumber VARCHAR(256) ,EmrNumber VARCHAR(256) ,Name VARCHAR(256) ,NameLast VARCHAR(256) ,NameFirst VARCHAR(256) ,BirthDateTime DATETIME ,Sex VARCHAR(256)… -
checking in complaining about stored procs not compiling
Discussion by ChrisAdkin · · Home› Discontinued and Previous Versions› SQL Source Control Previous VersionsI'm using source control 1.1.0.19, with SQL Server 2008 R2 and sub version. When I try to check in, Red Gate source control is complaining that a perfectly good stored proc which I have already checking via a different sub version client will not compile, this is what I'm getting:- Errors occurred whilst parsing file… -
Errors in script
Hi Guys, I am a new user. I get the following errors when I try to run a compare script. Does anyone have any ideas? Thanks, Derek Altering [dbo].[PendingProductionAdjustment_SetProcessedFlag] Server: Msg 207, Level 16, State 1, Procedure PendingProductionAdjustment_SetProcessedFlag, Line 18 Invalid column name…
>5978 results