Comments
Sort by recent activity
Aaron:
The issue is fixed in the private build. However, if I do a
IF OBJECT_ID('tempdb..#a') IS NOT NULL
DROP TABLE #a
IF OBJECT_ID('tempdb..#b') IS NOT NULL
DROP TABLE #b
CREATE TABLE #a (id INT IDENTITY(1, 1)
NOT NULL)
CREATE TABLE #b (id INT IDENTITY(1, 1)
NOT NULL)
SELECT *
FROM #a AS a
INNER JOIN #b AS b
ON a.id = b.id
SELECT *
FROM #a AS a
INNER JOIN #c AS b
ON a.id = id
it will now resolve the missing prefix in the second ON statement to an "a.id". Technically, this is correct as SQL Prompt correctly resolves the column to the corresponding table alias. However, it doesn't make much sense to join a column to itself in the same table alias; I'm just not sure you want to add this type of validation logic to SQL Prompt. / comments
Aaron:
The issue is fixed in the private build. However, if I do a
IF OBJECT_ID('tempdb..#a') IS NOT NULL
DROP TABLE #a
IF OBJECT_ID('tempdb..#b') IS NOT NULL
DROP TABLE #b
CREATE TABLE #a (id...
Aaron:
The private build did fix the issue on my machine.
Thanks,
Jens / comments
Aaron:
The private build did fix the issue on my machine.
Thanks,
Jens
Aaron: Re linked server issue: I unfortunately have not been able to create a simple repo that I can share. The issues are happening in large stored procedures that I'm unable to share / comments
Aaron: Re linked server issue: I unfortunately have not been able to create a simple repo that I can share. The issues are happening in large stored procedures that I'm unable to share
Found another issue: I have set all SQL code to be capitalized. If I type the following statement and after "end" type a space character then "END" will be capitalized. However, if I type a TAB character then it will not be capitalized. If I press the TAB character after "EN" then it will insert the END capitalized from the suggestions.
SELECT CASE WHEN a=1 THEN 0 ELSE 1 end / comments
Found another issue: I have set all SQL code to be capitalized. If I type the following statement and after "end" type a space character then "END" will be capitalized. However, if I type a TAB cha...
Found another formatting issue:
SELECT *
FROM dbo.staging_MONOGRAM_INVOICE_fact s
LEFT JOIN (SELECT agreement_id
, fm_processing_pct
, SUM(tot_disbs) AS fm_processing_tot_disbs
, SUM(tot_disb_amts) AS fm_processing_tot_disb_amts
, SUM(tot_cancs) AS fm_processing_tot_cancs
, SUM(tot_canc_amts) AS fm_processing_tot_canc_amts
, SUM(fm_processing_disb_fee) AS fm_processing_disb_fee
, SUM(fm_processing_canc_fee) AS fm_processing_canc_fee
, SUM(fm_processing_tot_fee) AS fm_processing_tot_fee
FROM dbo.staging_MONOGRAM_MARKETER_CHAN_fact f
WHERE excl_processing_fee = 0
GROUP BY agreement_id
, fm_processing_pct) mc
ON s.AGREEMENT_ID = mc.AGREEMENT_ID
"ON s.AGREEMENT_ID = mc.AGREEMENT_ID" will be changed to "ON s.AGREEMENT_ID = s.AGREEMENT_ID" and the subquery will not get the "f" aliases inside the sUM() statements / comments
Found another formatting issue:
SELECT *
FROM dbo.staging_MONOGRAM_INVOICE_fact s
LEFT JOIN (SELECT agreement_id
, fm_processing_pct
, SUM(tot_disbs) AS fm_processing_tot_disbs
, SUM(tot_disb_a...
Control-B, Control-Q does not work if I try to format an INSERT INTO table() SELECT columns FROM table1 WHERE condition statement.
I'm also having problems qualifying object names when there are linked server in the query. This one predates SQL Prompt 6.4 beta. / comments
Control-B, Control-Q does not work if I try to format an INSERT INTO table() SELECT columns FROM table1 WHERE condition statement.
I'm also having problems qualifying object names when there are li...
I can confirm this behavior under 10.7.0.23 as well / comments
I can confirm this behavior under 10.7.0.23 as well
SQL Compare 10.2.0.1108 seems to have fixed the issues. / comments
SQL Compare 10.2.0.1108 seems to have fixed the issues.
I can also confirm that .160 solved this issue for us under SQL Server 2000.
Thanks,
Jens / comments
I can also confirm that .160 solved this issue for us under SQL Server 2000.
Thanks,
Jens
I can cofirm the same issue with both local/global temp tables as well as tables accessed via linked servers. SQL Prompt version is 5.2.0.5 / comments
I can cofirm the same issue with both local/global temp tables as well as tables accessed via linked servers. SQL Prompt version is 5.2.0.5