Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
SELECT @DynamicQuery = ISNULL(@DynamicQuery+' UNION ','') + 'SELECT CONVERT(varchar(max),'+COLUMN_NAME+') as varColumnName, '+@VarCusHeaderID+' as fk_Header_ID, '+@varProviderID+' as fk_ProviderID, '+@varCurIndex+' as PositionIndex, '+@varIsStatus+' as IsStatus FROM '+@TransactionTable+ ' y' +ISNULL(' WHERE '+@TableWhere,'') FROM INFORMATION_SCHEMA.COLUMNS WHERE (table_name = @TransactionTable AND COLUMN_NAME IN ( 'Text1', 'Text2', 'Text3', 'Text4', 'Text5', 'Text6', 'Text7', 'Text8', 'Text9', 'Text10' ) ) ORDER BY SUBSTRING(COLUMN_NAME,5,2)
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!