Select data from one table & then rename the columns based on another table in SQL server

SharpCoder

I have two tables. TableOne which contains two columns (name & value). TableTwo can contain N no. of columns. Number of rows in TableOne will be equal to number of columns in TableTwo.

see the below image for more information.

enter image description here

What I want:

When I run select query on TableTwo, the result-set should pick the column names based on value column of TableOne. We need to match column name of TableTwo with rows available in TableOne and perform transform.

So the output should look like this:

ColumnOne | ColumnTwo | columnThree | ColumnFour

 1           1            1             2015-05-08 15:28:22.630
 2           2            2             2015-05-07 15:28:22.630
 ................
 ................

Sam Abushanab

You can use dynamic sql to generate the query to execute based on the values in the first table. Here is an example:

Declare @dynamicSQL nvarchar(200)

SET @dynamicSQL = 'SELECT ' + (SELECT stuff((select ',' + name + ' AS ' + value from Table1 for xml path('')),1,1,'')) + ' FROM Table2'

EXECUTE sp_executesql @dynamicSQL

SQL Fiddle: http://sqlfiddle.com/#!6/768f9/10

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-03-29

Comments

0 comments

Filtering data values in one column based on another column and then inserting values into different columns in same SQL Table

select data from one column based on another column's condition in the same table and insert that resulting data to another table

TOP Ranking

Article

Select data from one table & then rename the columns based on another table in SQL server

Select data from one table & then rename the columns based on another table in SQL server

pump.io port in URL

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

How to import an asset in swift using Bundle.main.path() in a react-native native module

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

Using Response.Redirect with Friendly URLS in ASP.NET

Can a 32-bit antivirus program protect you from 64-bit threats

Double spacing in rmarkdown pdf

How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?

3D Touch Peek Swipe Like Mail

Bootstrap 5 Static Modal Still Closes when I Click Outside

Assembly definition can't resolve namespaces from external packages

Vector input in shiny R and then use it

Emulator wrong screen resolution in Android Studio 1.3

Svchost high CPU from Microsoft.BingWeather app errors

Graphics Context misaligned on first paint

Python connect to firebird docker database

Is this docker-for-mac password dialog legit?

How to save models trained locally in Amazon SageMaker?