>>This distributor wants a listing of locations to be delivered by day
>>
>>

>>Sunday  Monday Tuesday   etc
>>loc a       loc b       loc d
>>loc j        loc k        etc           etc
>>
>>

>>the table contains the daynumber Sunday =1, and the location,
>>
>>Can it be done in one query?
>
>Sure, look into PIVOT syntax in SQL Server.
>
>You may find this blog post interesting as well
>
>http://blogs.lessthandot.com/index.php/datamgmt/datadesign/understanding-sql-server-2000-pivot/
>
>E.g.
>
>

>declare @t table (id int identity (1,1), location varchar(10), DayNumber tinyint)
>
>insert into @t (location, DayNumber)
>values ('Loc1', 1), ('Loc2', 1), ('Loc3', 2), ('Loc4',2), ('Loc5', 1), ('Loc6', 1)
>
>select ISNULL(min(case when DayNumber = 1 then Location end),'') as Sunday,
>ISNULL(min(case when DayNumber = 2 then Location end),'') as Tuesday
>
>from (select *, row_number() over (partition by DayNumber order by Location) as Rn
>from @t) X
>GROUP BY Rn

Thank you, Naomi.

I'll look at it