ie.

SELECT ParentTable.*, MAX(CAST(ChildTable.bitcol1 AS smallint)), MAX(CAST(ChildTable.bitcol2 AS smallint)), MAX(CAST(ChildTable.bitcol3 AS smallint))......

Hi,

unfortunately there are 3 columns on my child table i want to summarize so that query would get pretty cumbersome. I think casting the bits will probably be a more...

ParentTable

------------------------------------------------------

ParentIDCol SomeDataCol

------------------------------------------------------

1 information

2 ...