Selecting rows as columns in SQL Server

Question

I have 2 tables in database

tblServices:

serviceID    
serviceName

tblDomains:

domainID  
domainName  
Parent

Now I want to select

serviceID serviceName domainID domainName1 domainName2 domainName3 ...

i.e I want to select all the domainName as rows where parent == serviceName

So if somebody adds a row to one of the tables, you want one more column? — jarlh, Feb 19 '15 at 09:57
Don't handle this in `SQL`, let your application perform the `PIVOT`. — mheptinstall, Feb 19 '15 at 09:58

score -1 · Answer 1 · edited May 23 '17 at 11:57

-1

One Example Here. Efficiently convert rows to columns in sql server

edited May 23 '17 at 11:57

Community

answered Feb 19 '15 at 10:01

A_Sk

2

please don't simply post links, at least offer some explanation as to how this can be applied. if those links move or change, this answer will be useless. – Tanner Feb 19 '15 at 10:42

1 Answers1