Hallo,
meist du das hier?
Hier noch die Codes:
select-Statement:
Tabelle ACode:SELECT KTR44, KTR12,REPLACE(FAK28,'"',''),KTR07 FROM tabelle1 LEFTOUTERJOIN tabelle2 ON KTR12 = FAK07 WHERE KTR12 <>'' GROUPBY KTR07, KTR12, FAK28, KTR44 having count(KTR07)> 1 ORDERBY KTR44, KTR12, KTR07
Tabelle BCode:USE [DB1] GO /****** Object: Table [dbo].[dim_tabelle1] Script Date: 03/06/2009 13:26:04 ******/ SETANSI_NULLSON GO SETQUOTED_IDENTIFIERON GO SETANSI_PADDINGON GO CREATETABLE [dbo].[dim_tabelle1]( [KTR07] [varchar](14)NULL, [KTR08] [varchar](3)NULL, [KTR12] [varchar](14)NULL, [KTR44] [varchar](14)NULL, )ON [PRIMARY] GO SETANSI_PADDINGOFF
Code:USE [DB1] GO /****** Object: Table [dbo].[dim_tabelle2] Script Date: 03/06/2009 13:28:26 ******/ SETANSI_NULLSON GO SETQUOTED_IDENTIFIERON GO SETANSI_PADDINGON GO CREATETABLE [dbo].[dim_tabelle2]( [FAK07] [varchar](14)NULL, [FAK08] [varchar](3)NULL, [FAK28] [varchar](30)NULL )ON [PRIMARY] GO SETANSI_PADDINGOFF



LinkBack URL
About LinkBacks
Zitieren



Lesezeichen