redJu(홍주)

커뮤니티에 약간 자주 String Concat, String Group By가 올라와서.., USE AdventureWorks GO SELECT c.Name ID, s.Name INTO #t FROM Production.ProductCategory c JOIN Production.ProductSubcategory s ON c.ProductCategoryID=s.ProductCategoryID SELECT * FROM #t Bikes Mountain Bikes Bikes Road Bikes Bikes Touring Bikes Components Handlebars Components Bottom Brackets Components Brakes Components Chains Components Cranks..