One of a set of tools we're offering as a way of saying thank you for being a part of the community.
SELECT @STR = @STR + ' 		 SELECT '''+DBASE+''' as [DBASE] 				,a.[DET_NOMINALDR] as [Nominal Code] 				,a.[DET_DATE] as [Date] 				,a.[DET_PERIODNUMBR] as [Period] 				,a.[DET_YEAR] as [Year] 				,a.[DET_DESCRIPTION] as [Narrative] 				,a.[DET_NETT] as [D/C] 				,b.[NT_GROSS_CONTRA] as [Contra Entry] FROM ' + DBASE + '.[dbo].[SL_PL_NL_DETAIL] a INNER JOIN ' + DBASE + '.[dbo].[NL_TRANSACTIONS] b ON a.[DET_HEADER_REF] = b.[NT_HEADER_REF] ' From ##tmpUserDBList
Join the community of 500,000 technology professionals and ask your questions.