What are the challenges you face when working across database platforms? Take the survey
Options

Qualify Object Names not working

TamilaTamila Posts: 1 New member
I am trying to use Qualify Object Names on my query, but it doesn't seem to be working. It doesn't return any errors, but it doesn't qualify the fields. It's a simple query that joins two tables. What could be the issue here??

SELECT
ApplCodeAccountNumber,
AccountNumber,
CustomerName,
CustomerNumber,
HouseholdName,
HouseholdNumber,
HouseholdBUID,
HouseholdBUName,
SUM(NetContribution) AS NetContribution,
SUM(NetInterestIncome) AS NetInterestIncome,
SUM(TotalRevenue) AS Revenue,
SUM(AverageAssetBalance)/12 AS AverageLoansBalance,
SUM(AverageLiabilityBalance)/12 AS AverageDepositsBalance
FROM Table1 AS PR
INNER JOIN Table2 AS BU
ON CAST(HouseholdBUID AS INTEGER) = CAST(Org_ID AS INTEGER)
WHERE
Date BETWEEN @prevFirstDate AND @prevLastDate
AND Physical_Branch = 1
AND Is_Current_Business_Unit = 1
AND IsEmployeeHousehold = 0
GROUP BY
ApplCodeAccountNumber,
AccountNumber,
CustomerName,
CustomerNumber,
HouseholdName,
HouseholdNumber,
HouseholdBUID,
HouseholdBUName
Tagged:

Answers

  • Options
    Hi @Tamila,

    If this query is executed after the creation of tables, suggestions can be out of date. I would suggest to "Refresh suggestion" (SQL Prompt menu -> Refresh suggestions [ctrl+shift+d]) and then try to use "Qualify Object Names" command.
    If that didn't help can you send us Prompt logs?

    Hope that helps.
    Krzysztof
  • Options
    gbrittongbritton Posts: 17 Bronze 1
    Yeah, so refreshing suggestions didn't help.  I notice these lines in the log after the attempt to qualify object names

    13:36:51.415|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Runtime failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go
    13:36:51.415|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.SQLPrompt.CommonControls.resources.dll
    13:36:51.415|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57
    13:36:51.415|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Runtime failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57, let's have a go
    13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.SQLPrompt.CommonControls.resources.dll
    13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en-US, PublicKeyToken=7f465a1c156d4d57
    13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Runtime failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go
    13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.SQLPrompt.CommonControls.resources.dll
    13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57
    13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Runtime failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57, let's have a go
    13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57 from C:\Program Files (x86)\Red Gate\SQL Source Control 6\RedGate.SQLPrompt.CommonControls.resources.dll
    13:36:51.431|INFO |RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.CustomAssemblyResolver|1|Failed to load assembly RedGate.SQLPrompt.CommonControls.resources, Version=9.2.6.6145, Culture=en, PublicKeyToken=7f465a1c156d4d57

Sign In or Register to comment.