Run same query
From: Italy ((Italy)_at_discussions.microsoft.com)
Date: 07/01/04
- Next message: Stefaan Dewulf: "Re: Error using QA"
- Previous message: Steve Kass: "Re: DateTime"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 1 Jul 2004 00:32:01 -0700
Hi NG,
in your opinion (sorry for my bad english) why I can run my query (standard ANSI) in the database A (SQL Server 2000 sp3) and can't run it in the database B where database A = database B?
In the database B I obtain:
'Server: Msg 4414, Level 16, State 1, Line 1
Could not allocate ancillary table for view or function resolution. The maximum number of tables in a query (260) was exceeded.'
Thanks in advance
giorgio
My query is:
select
NEWID() "ID"
, OBJ.containerid "MODELID"
, OBJ.objectid "TABID"
, TAB.stringvalue "NOME_TABELLA" --1
, DEF.DEFINIZIONE "DE_TABELLA" --2
, COALESCE (TAB3.valore,TAB3.INASSENZA,' ') "UDP_ALIAS_TAB"
,CONVERT(CHAR(10),CASE WHEN ISNUMERIC(TAB4.valore)=1 then DATEADD(DD,CONVERT(INT,TAB4.VALORE-2),'1900-01-01')
WHEN ISDATE(TAB4.valore)=1 THEN (TAB4.valore)
ELSE (CASE WHEN TAB4.INASSENZA IS NULL THEN '1911-01-01'
ELSE (CONVERT(CHAR(10),(DATEADD(DD,CONVERT(INT,TAB4.INASSENZA-2),'1900-01-01')),120)) END)
END,120) "UDP_DT_AGG_L"
,CONVERT(CHAR(10),CASE WHEN ISNUMERIC(TAB41.valore)=1 then DATEADD(DD,CONVERT(INT,TAB41.VALORE-2),'1900-01-01')
WHEN ISDATE(TAB41.valore)=1 THEN (TAB41.valore)
ELSE (CASE WHEN TAB41.INASSENZA IS NULL THEN '1911-01-01'ELSE
(CONVERT(CHAR(10),(DATEADD(DD,CONVERT(INT,TAB41.INASSENZA-2),'1900-01-01')),120)) END)
END,120) "UDP_DT_AGG_F"
,CONVERT(CHAR(10),CASE WHEN ISNUMERIC(TAB5.valore)=1 then DATEADD(DD,CONVERT(INT,TAB5.VALORE-2),'1900-01-01')
WHEN ISDATE(TAB5.valore)=1 THEN (TAB5.valore)
ELSE (CASE WHEN TAB5.INASSENZA IS NULL THEN '1911-01-01'ELSE
(CONVERT(CHAR(10),(DATEADD(DD,CONVERT(INT,TAB5.INASSENZA-2),'1900-01-01')),120)) END)
END,120) "UDP_DT_FINE" --5
,CONVERT(CHAR(10),CASE WHEN ISNUMERIC(TAB6.valore)=1 then DATEADD(DD,CONVERT(INT,TAB6.VALORE-2),'1900-01-01')
WHEN ISDATE(TAB6.valore)=1 THEN (TAB6.valore)
ELSE (CASE WHEN TAB6.INASSENZA IS NULL THEN '1911-01-01'ELSE
(CONVERT(CHAR(10),(DATEADD(DD,CONVERT(INT,TAB6.INASSENZA-2),'1900-01-01')),120)) END)
END,120) "UDP_DT_INIZIO" --6
, COALESCE(TAB7.valore,TAB7.INASSENZA,' ') "UDP_DENORM" --7
, COALESCE (TAB8.valore,TAB8.INASSENZA,' ') "UDP_LINK_DOC" --8
, COALESCE (TAB9.valore,TAB9.INASSENZA,' ') "UDP_GG_SCO" --9
, COALESCE (TAB10.valore,TAB10.INASSENZA,' ') "UDP_REF_DATI" --10
>From
(select * from mmobject where classid = 22
-- and containerid = 293391 -- Modello
and containerid = (select ObjectId from dbo.mmLibrary where ObjectId in (select ObjectId from dbo.mmObject where ContainerId = (select ObjectID from dbo.mmLibrary where ObjectName = (select CO_VALORE from dbo.PARAMETRO where EntryID = 2)) and ClassId = 21) and ObjectName = (select CO_VALORE from dbo.PARAMETRO where EntryID = 4))
and (endversion = 0 OR endversion IS NULL) -- considera solo il modello e non i save
) OBJ
LEFT OUTER JOIN mmobjectproperty TAB
ON (OBJ.objectid = TAB.objectid and TAB.propertyid = 200) --1
LEFT OUTER JOIN dbo.OBJ_DEFINITION DEF
ON (OBJ.objectid = DEF.OGGETTO_ID) AND DEF.TIPO = 'DE_TAB'
LEFT OUTER JOIN ENTITAeUDP TAB3
ON (OBJ.objectid = TAB3.IDEntita AND TAB3.udpNAME = 'Alias Tabella')
LEFT OUTER JOIN ENTITAeUDP TAB4
ON (OBJ.objectid = TAB4.IDEntita
AND TAB4.UDPISLOGICAL = 1 AND TAB4.udpNAME = 'Data Agg.Doc.to') --4 UDP LOGICAL
LEFT OUTER JOIN ENTITAeUDP TAB41
ON (OBJ.objectid = TAB41.IDEntita
AND TAB41.UDPISLOGICAL = 0 AND TAB41.udpNAME = 'Data Agg.Doc.to F') --4 UDP physical
LEFT OUTER JOIN ENTITAeUDP TAB5
ON (OBJ.objectid = TAB5.IDEntita and TAB5.udpNAME = 'Data Fine Validità') --5
LEFT OUTER JOIN ENTITAeUDP TAB6
ON (OBJ.objectid = TAB6.IDEntita and TAB6.udpNAME = 'Data Inizio Validità') --6
LEFT OUTER JOIN ENTITAeUDP TAB7
ON (OBJ.objectid = TAB7.IDEntita and TAB7.udpNAME = 'Denormalizzazione') --7
LEFT OUTER JOIN ENTITAeUDP TAB8
ON (OBJ.objectid = TAB8.IDEntita and TAB8.udpNAME = 'Documento Collegato') --8
LEFT OUTER JOIN ENTITAeUDP TAB9
ON (OBJ.objectid = TAB9.IDEntita and TAB9.udpNAME = 'GG. Scostamento') --9
LEFT OUTER JOIN ENTITAeUDP TAB10
ON (OBJ.objectid = TAB10.IDEntita and TAB10.udpNAME = 'Referente Dati') --10
- Next message: Stefaan Dewulf: "Re: Error using QA"
- Previous message: Steve Kass: "Re: DateTime"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
