How can we help you today? How can we help you today?

Qualify Object Names not working

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
Tamila
0

Comments

2 comments

Sort by
  • krzysztofkroczak
    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
    krzysztofkroczak
    0
  • gbritton
    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

    gbritton
    0

Add comment

Please sign in to leave a comment.