This might be useful...

http://www.sqlteam.com/item.asp?ItemID=2955

Post the update in the first post...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=274064

...please don't create a new thread in this situation.

Duplicate post...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=275152

Same question here...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65167

...and here...

http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.programming&mid=1d1c9b96-a748-4a6f-8f2b-9bf2e55be244

No clarification of the problem on any of them yet...

Something like this?

--data

declare @door table (door_id int, door_status bit)

insert @door

          select 1, 0

union all select 2, 0

union all select 3, 1

union all select 4, 1

union all...

Hi Phil (and Vladan),

Vladan's solution looks good to me (I actually did it the same way and then saw that he had beat me to it!).

I'm not sure the result...

Hi Minh Vu (and all),

It looks like your example isn't a sufficient representation of your problem. Can you 'enhance' it for us please?

Here's one trick that might be useful (it's...

Hi all,

For my own amusement, I took a look at some end points for a few of the methods...

--data

declare @t table (d datetime)

insert @t

          select '20060424...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=65115

Yes, it's possible. e.g.

select

    id,

    case when id between 1 and 7 then

                case when id = 1 then 'one' when id = 2 then 'two'...

Objective view you say?...

create view objective as select 'poor joke' as 'objective view'

You have to list all the columns. You can just type them out, but I'm guessing it's that you want to avoid.

There...

Hi Jawad,

Here's one way. Note that it does not cope with ties. Let us know if it needs to.

--data

declare...

Was there something wrong with what I posted? Here, I'll make it easier for you...

I agree with Noeld that it's better to put...

Pieter - As I say, I can't get my head around your situation without some sample data. I guess if it's working for you, then don't worry.