Create Function to Group Column and display as single column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Create Function to Group Column and display...

Create Function to Group Column and display as single column

Rate Topic

Display Mode

Topic Options

Author

Message

londhe.kunal

Posted Wednesday, July 28, 2010 11:12 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 28, 2011 12:09 AM
Points: 6, Visits: 31

Hi
Consider table Exhibitor

Exhibitor Table name
ID Column name
Name Column name
StallNo1 Column name
StallNo2 Column name
StallNo3 Column name
StallNo4 Column name
StallNo5 Column name

i want a generic function it accept ('tablename','Column order min ','Column order max') it return group of Column as single column.

when i used this function in select query it gave me group of value for Group Column.

Waiting For Replay........................

Post #960485

Stewart "Arturius" Campbell

Posted Thursday, July 29, 2010 2:21 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 3,129, Visits: 4,312

Please provide us with an example of what you have already tried.

also, are you in a position to normalise the table?
e.g.

Create table dbo.Exhibitor (
ID DataType
Name DataType
...
)
Create Table dbo.Stall
StallNo DataType
Exibitor DataType CONSTRAINT FK_Exibitor FOREIGN KEY REFERENCES dbo.Exibitor(ID)
....

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #960542

« Prev Topic | Next Topic »

Permissions