How to solve this Query Easily
HiHow to solve this Query using Sql Server only
CREATE TABLE Titlepay
(
ID INT PRIMARY KEY IDENTITY(1,1),
TITLENAME VARCHAR(50)
)
CREATE TABLE Detailpay
(
ID INT PRIMARY KEY IDENTITY(1,1),
TITLEID VARCHAR(50),
PAYAMOUNT DECIMAL(18,2),
EMPID INT
)
--iNSERT INTO Titlepay VALUES('Hra'),('Da'),('Ca'),('Pf'),('Lic')
--Insert into Detailpay values(1,100,1001),(2,250,1001),(3,350,1001),(4,450,1001),(5,600,1001)
--Insert into Detailpay values(1,101,1002),(2,251,1002),(3,351,1002),(4,451,1002),(5,601,1002)
-- I need output like this
-- EmpID Hra Da Ca Pf Lic
-- 1001 100 250 350 450 600
-- 1002 101 251 351 451 601