June 22, 2005 at 12:21 pm
I have a simple table of two columns (PaxID, PaxName). How can I generate a view to show the ID and all pax names with the same id in one row e.g If ID '1' has two names i need to create the following:
ID Pax Name
1 the two pax names
June 22, 2005 at 12:24 pm
Why would the id wouldn't be unique???
anyways :
IF Object_id('ListTableColumns') > 0
DROP FUNCTION ListTableColumns
GO
CREATE FUNCTION dbo.ListTableColumns (@TableID as int)
RETURNS varchar(8000)
AS
BEGIN
Declare @Items as varchar(8000)
SET @Items = ''
SELECT
@Items = @Items + C.Name + ', '
FROMdbo.SysColumns C
WHEREC.id = @TableID
AND OBJECTPROPERTY(@TableID, 'IsTable') = 1
ORDER BYC.Name
SET @Items = LEFT(@Items, ABS(DATALENGTH(@Items) - 2))
RETURN @Items
END
GO
Select dbo.ListTableColumns(Object_id('SysObjects'))
--base_schema_ver, cache, category, crdate, deltrig, ftcatid, id, indexdel, info, instrig, name, parent_obj, refdate, replinfo, schema_ver, seltrig, stats_schema_ver, status, sysstat, type, uid, updtrig, userstat, version, xtype
DROP FUNCTION ListTableColumns
June 22, 2005 at 12:32 pm
This is because the id is a link field to a different master service table and that is why I need to generate pax list for that master service table
June 22, 2005 at 12:35 pm
k... just making sure that the design wasn't flawed.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply