- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more
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' ) )
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.