that's my bad...

wondering if I can utilize pivot or something else to do the combination, or do I have to do the join/cross join in this case? thanks.

--------------

CREATE TABLE [dbo].[aspdnsf_Attribute](

[AttributeID]...

Thank you so much Lutz.

here is the table and a couple of test records...

CREATE TABLE [dbo].[aspdnsf_Attribute](

[AttributeID] [int] IDENTITY(1,1) NOT NULL,

[AttributeGUID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_aspdnsf_ProductAttribute_AttributeGUID] DEFAULT (newid()),

[AttributeName] [nvarchar](200) COLLATE...