>I have a table that will have a variable number of records. This is a Bed table. The facility may have 1-30 (or more) beds. I am wanting to create a stored procedure that returns a table, with the beds as columns, and each row will represent a day. So when passed the date say of 5/1/2011, they query would return a recordset that had a column for the date and then 1 column for each bed.
>
>
>DATE BED1 BED2 BED3 BED4
>05/01/2011
>05/02/2011
>05/03/2011
>...
>05/31/2011
>
>
>The bed table simply has the BedID,BedDesc, IsActive (bit) as fields.
>
>Thanks for any suggestions
>
>Kirk.
Celko's comment on this topic
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/20cd49f3-ca50-4dbc-a3b1-700e7c87ff69
If it's not broken, fix it until it is.
My Blog