SQL Query

Hi All, I have 2 tables ConfigurationTable and Data table. I require combine value like below output Source tables: Target Output: Sql Scripts: CREATE TABLE CONFIGTABLE(Productcode V...

Analysis Services

analytics

Business Intelligence

rodgerkong

Mar 26, 2025

Combine two values is easy, but I don't know how to order result like your sample.

SELECT 
	C.Productcode +':' + C.Linkedvalue AS [Combine Of Productcode and Linkedvalue], 
	K.FIELDVALUE + ':' + V.FIELDVALUE AS [VALUE]
FROM CONFIGTABLE C
LEFT JOIN DATATABLE K
	ON C.Productcode = K.NAME
LEFT JOIN DATATABLE V
	ON C.Linkedvalue = V.NAME

rodgerkong

Iron Contributor

Mar 26, 2025

Combine two values is easy, but I don't know how to order result like your sample.

SELECT 
	C.Productcode +':' + C.Linkedvalue AS [Combine Of Productcode and Linkedvalue], 
	K.FIELDVALUE + ':' + V.FIELDVALUE AS [VALUE]
FROM CONFIGTABLE C
LEFT JOIN DATATABLE K
	ON C.Productcode = K.NAME
LEFT JOIN DATATABLE V
	ON C.Linkedvalue = V.NAME

BADDULA

Copper Contributor

Mar 31, 2025

Thank you rodgerkong for the quick response.

Forum Discussion

SQL Query

Resources