Dec 9, 2013 · However, as far as how to get column names, assuming this is SQL Server, you can use the following query: SELECT c.name FROM sys.columns c WHERE c.object_id = OBJECT_ID('dbo.test') Therefore, you can build your dynamic SQL from this query:

Oct 10, 2016 · This method uses a tally table to generate the columns you want to select (in this example, columns 1 through 30, but that can be changed), then generates a dynamic SQL statement to execute against the SData table:

Oct 26, 2015 · I want to generate [Employee Name] dynamically based on other column value. Here is the sample table. I want dt01 value to display as column name 26 and dt02 column value will be 26+1=27. Short answer: It is impossible. Slightly longer: what about distinct values in distinct rows of you "other" column? How this should be handled?

SELECT @SQLText += ( -- Add in column list, with dynamic column names. SELECT 'CONVERT(' + ColDataType + ', Col' + CONVERT(VARCHAR, ColNum) + ') AS [' + ColName + '],' FROM #Names. WHERE [Type] = @Type FOR XML PATH('')

Feb 1, 2025 · Learn how to query tables with dynamic column names using Oracle's UNPIVOT function and dynamic SQL techniques.

May 15, 2018 · loop dbms_output.put_line(j.C009); dbms_output.put_line(l_varpart||to_char((to_number(l_numpart) + i),'fm'||rpad('0',l_digits,'0')));

May 19, 2021 · Yes you can absolutely use a loop & dynamic SQL to do this. BEGIN WHILE SET @COL = (SELECT ColName FROM @Table WHERE ID = @LOOP) DECLARE @SQL varchar(MAX) = '' EXEC (@SQL) SET @LOOP = LOOP + 1 END

Dec 12, 2024 · Dynamic SQL is a powerful feature in SQL that allows developers to construct and execute SQL statements at runtime. This capability is particularly useful when you need to customize column names based on user input or other dynamic conditions.

Jan 8, 2016 · Using UNPIVOT and COALESCE, I can dynamically pull a list of columns from any table and associated column values for any record in a record listing and combine them in a list of column names with values by row.

May 8, 2021 · How do I concat a string and a variable to use it as a column name in an sql query? Based on what Lennart suggested I have this now SET STMT = 'SELECT APPROP' || appropriation || ' pr.earnings into ' || active_appropriation || ' where empnumber = ' || user_number; EXECUTE IMMEDIATE STMT