PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.