In general : never make an assumption about the sequence in which data will be returned from a query.

An alternative is, if the bit values do not change to 'often' use a view and a trigger that will redefine the view when a bit is flipped. Assumption: often...

If possible can you post some of the data and structure

Suggestion: replace the word WHERE with AND, and check if it makes any difference.

Which SQL(7,2000)

Hi, a5xo3z1, after reading the two posts it made me think of some maintenance work done awhile back where the business rules got a bit lost after multiple mods and...

Different horses for different courses.

In the run off the mill databases one do not see such level of dynamics very often.

If you do not switch columns on/off to often I...

Any other documentation for maintenance purposes, business rules, etc. ?

Problem similar to the paging requests of an ASP page through a recordset. Other words want records 100 to 109, then 110 to 119 or backwards 90 to 99, etc.

How about a startup proc to create an entry in a table with a start_column = getdate() and with a sheduled job running every 5 min updating the last row,...

Start looking at Query Analyzers templates.

Haven'nt used it myself, but one can specify templates in QA.

Left Join,Inner Join, Right Join

No help to solving your problem

http://dbforums.com/arch/70/2002/11/549598

Maybe one them have found a work around.

Some relevance :

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=482&lngWId=5

See

http://www.sqldts.com/default.aspx?6,104,210,0,1

How about a scheduled job that can get activated on request?

Belov thanks for the example.

Mdamera look in C:\Program Files\Microsoft SQL Server\MSSQL\Upgrade