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 @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.
|How to use Recordset, returned from a SPROC as the recourdsource of a form.||24||51|
|Powershell error using sql agent job||24||37|
|SQL - Result of a formula to decimal (not integer) value||7||22|
|Sql group by orderdate and ordertotal||3||8|
Join the community of 500,000 technology professionals and ask your questions.