May was a big month for new releases from Linux Academy! Take a look at what our team built recently in our blog. You can access the newest releases from our blog.
CREATE TABLE #temp ( [Inquiry Number] NVARCHAR(255), [CPO Number] VARCHAR(50), [SO Number] VARCHAR(50) ) CREATE nonclustered INDEX ix_InqNum ON #temp ([Inquiry Number]) include ([CPO Number]) INSERT INTO #temp ( [Inquiry Number],[CPO Number] ) SELECT distinct PRA.inq_num,[PO Number] FROM [LocalDB].dbo.ps_requests_asr PRA with(nolock)left join [RemoteDB].[DBName].dbo.CPOA with(nolock) ON cast(Inquiries as NVARCHAR(450)) = '[' + PRA.inq_num + ']' WHERE PRA.inq_num is not null UPDATE #temp SET [SO Number]= CUST.[SO] FROM #temp INNER JOIN [RemoteDB].[DBName].dbo.CPOA CPON WITH(NOLOCK) ON cast(CPON.Inquiries as NVARCHAR(450)) = '[' + #temp.[Inquiry Number] + ']' INNER JOIN [RemoteDB].[DBName].dbo.BI_CUSTMON CUST WITH(NOLOCK) ON CUST.[Customer PO] LIKE #temp.[CPO Number] + '%' select * from #temp
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.