Bit Data type in a select query or view

[BlackKnight]

Hi folks,

I have a yes/no field which is considered to be a bit type in MSDE (SQL Server 7.0). I have it in a select statement in a view but I get the error that the yes/no field is invalid since it is not included in the GROUP BY clause.

When I include it in the GROUP BY clause it says you can't group on a bit column. When I tried to put the bit column in the select statement in an aggregate function to avoid having to include it in the GROUP BY statement it said you can't use the aggregate function with a bit column.

Thanx in advance.

Have a good one!
BK

 

[ColinM]

You could try changing it to a tinyint?

 

[foxdev]

I find the SQLS limitation in this regard a "bit" awkward myself.

How about adding a CASE statement to the SELECT that converts 0/1 to "Y/N" or some such?

Robert Bradley

http://www.foxdev.com/