
March 1st, 2013, 11:29 AM
|
|
Registered User
|
|
Join Date: Aug 2003
Location: Philadephia
Posts: 9
Time spent in forums: 2 h 34 m 28 sec
Reputation Power: 0
|
|
|
Maximum number of prefixes exceeded
Good morning, I am getting the above error from the following query...any ideas
select accountid,c_acct_engagementID,client_code,engagement,ltrim(rtrim(client_code)) + ltrim(rtrim(engagement)) as
EngCode from saleslogix.sysdba.c_acct_Engagement B
where
ltrim(rtrim(B.Client_Code)) + ltrim(rtrim(B.Engagement))
not in (select ltrim(rtrim([rl-sql02].abc_sql.dbo.clients.cltnum)) + ltrim(rtrim([rl-sql02].abc_sql.dbo.clients.clteng))
from [rl-sql02].abc_sql.dbo.clients)
--------------------------------------------------------------
Server: Msg 117, Level 15, State 2, Line 6
The number name 'rl-sql02.abc_sql.dbo.clients' contains more than the maximum number of prefixes. The maximum is 3.
|