Search
-
Offline Schema-Model Issues
This issue just crept up today and appears to have started happening after the latest update. Message = Could not synchronize Offline Schema Model: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index.Data = System.Collections.ListDictionaryInternalInnerException =… -
Handling flyway migration failure
We have Flyway integrated to Bitbucket pipeline to deploy sql files in Snowflake database. It works like a breeze for best case scenario. When in bad scenarios, let's say there are 5 files added to code repository to be deployed, during migration if first two in the sequence goes through fine and the third has a syntax… -
7.3.0.564 - Formatting Styles - CASE THEN expression
Version: 7.3.0.564 Formatting: CASE THEN expression, -1 is up against the THEN (missing space) Example: SET [Force_Selected_With] = CASE WHEN [bridge_Rule].[Rule_ProductItemID_Selected] = 1 THEN 1 WHEN [bridge_Rule].[Rule_ProductItemID_Selected] = 0 THEN-1 END Thank you! -
DLM Build Error
Hello, I am using the Team City DLM build plugin to create a build script. It seems there is some errors with the change script that the tool is trying to publish to the temp database. The error is: [16:03:03][Step 1/2] WARNING: The error 'Incorrect syntax near '('.' occurred when executing the following SQL:… -
Copying data in the same DB
I have two tables in the same DB. Table 1 has 100 rows and Table 2 has 10. I want to copy data from Table 1, Column 1 to Table 2 Column 1. How? -
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…
>5989 results
