.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

can this possible?

Posted By:      Posted Date: September 19, 2010    Points: 0   Category :Sql Server
 
CREATE TABLE X (OrgLevel VARCHAR(100), OrgValue VARCHAR(100))
INSERT INTO X VALUES ('SITE', 'SITE - 001')
SELECT * FROM X

above table has below output with 2 columns "OrgLevel" and "OrgValue"....

/*********************
OrgLevel	OrgValue
 SITE    SITE - 001
**********************/

can anyway to do where OrgLevel = SITE will become column and OrgValue = SITE - 001 will become value for column SITE like below,

/*********************
 SITE
SITE - 001
**********************/



View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend