Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

How can we write the columns set as rows set?

This is a discussion on How can we write the columns set as rows set? within the SQL Server forums, part of the Databases category; With Out Using The Temporary tables(# tables)....

Geeks Talk > Databases > SQL Server How can we write the columns set as rows set?

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   04-23-2008

nageshkota Junior Member   Join Date: Apr 2008 Location: Hyderabad Posts: 24 Thanks: 1 Thanked 4 Times in 2 Posts

How can we write the columns set as rows set? With Out Using The Temporary tables(# tables).

Sponsored Links

#2 (permalink)   04-23-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,371 Thanks: 7 Thanked 123 Times in 111 Posts

Re: How can we write the columns set as rows set? You can try that using case statment.

#3 (permalink)   04-23-2008

nageshkota Junior Member   Join Date: Apr 2008 Location: Hyderabad Posts: 24 Thanks: 1 Thanked 4 Times in 2 Posts

Re: How can we write the columns set as rows set? Quote: Originally Posted by debasisdas You can try that using case statment. If we know the columns set then only we can use the case statement, if did not know the column set then what is the way to get?

#4 (permalink)   04-23-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,371 Thanks: 7 Thanked 123 Times in 111 Posts

Re: How can we write the columns set as rows set? If you want to do it dynamically better to use Procedure for that .

#5 (permalink)   04-29-2008

dinesh_b5 Junior Member   Join Date: Apr 2008 Location: chennai Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts

Re: How can we write the columns set as rows set? Hi all i am new to this forum ...

Geeks Talk > Databases > SQL Server

« Database Access | MS SQL Enterprise support Interview Questions »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Identify Rows columns in datagrid control	kanta	QTP	8	07-31-2008 04:11 PM
Rows to columns and vice-versa	tanya_j	Data Warehousing	1	03-25-2008 05:49 AM
Write a SQL to print the rows horizonatally	Geek_Guest	SQL	1	07-17-2007 04:54 AM
How to convert rows into columns in Teradata	rashnyo	Data Warehousing	0	07-12-2007 12:52 AM
How do I transpose Rows into Columns?	Anasuya1031	SQL	2	07-09-2007 04:37 AM

All times are GMT -4. The time now is 10:47 PM.