سلام
فرض کنید جدول زیر را داریم

CREATE TABLE [dbo].[test3](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Date] [date] NULL,
[Name] [nvarchar](50) NULL,
[Price] [int] NULL,
CONSTRAINT [PK_test3] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]


GO



و داده های زیر را داخل ان وارد کرده ایم

insert into [dbo].[test3] values('2016-05-01','a',100)
insert into [dbo].[test3] values('2016-05-02','a',100)
insert into [dbo].[test3] values('2016-05-03','a',100)
insert into [dbo].[test3] values('2016-05-01','b',100)
insert into [dbo].[test3] values('2016-05-02','b',100)
insert into [dbo].[test3] values('2016-05-03','b',100)
insert into [dbo].[test3] values('2016-05-01','c',100)
insert into [dbo].[test3] values('2016-05-02','c',100)
insert into [dbo].[test3] values('2016-05-03','c',100)
insert into [dbo].[test3] values('2016-05-01','d',100)
insert into [dbo].[test3] values('2016-05-02','d',100)
insert into [dbo].[test3] values('2016-05-03','d',100)
insert into [dbo].[test3] values('2016-05-01','e',100)
insert into [dbo].[test3] values('2016-05-02','e',100)
insert into [dbo].[test3] values('2016-05-03','e',100)
insert into [dbo].[test3] values('2016-05-01','f',100)
insert into [dbo].[test3] values('2016-05-02','f',100)
insert into [dbo].[test3] values('2016-05-03','f',100)
insert into [dbo].[test3] values('2016-05-01','g',100)
insert into [dbo].[test3] values('2016-05-02','g',100)
insert into [dbo].[test3] values('2016-05-03','g',100)
insert into [dbo].[test3] values('2016-05-01','h',100)
insert into [dbo].[test3] values('2016-05-02','h',100)
insert into [dbo].[test3] values('2016-05-03','h',100)
insert into [dbo].[test3] values('2016-05-01','j',100)
insert into [dbo].[test3] values('2016-05-02','j',100)
insert into [dbo].[test3] values('2016-05-03','j',100)

حال من کوئری می خواهم که جواب زیر را به من برگرداند

2016-05-01 a 100 b 100 c 100 d 100 e 100 f 100 g 100 h 100 j 100
2016-05-02 a 100 b 100 c 100 d 100 e 100 f 100 g 100 h 100 j 100
2016-05-03 a 100 b 100 c 100 d 100 e 100 f 100 g 100 h 100 j 100



البته تعداد Name ها هردفعه تغییر می کند و تعدادمشخصی ندارد
باسپاس

نمایش ستونها بصورت یک سطر