Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 set default column to count rows where condition?

Author  Topic 

cwfontan
Yak Posting Veteran

87 Posts

Posted - 2009-07-29 : 13:41:00
set default column to count rows where condition?

table has parent and child rows want to set a count column to count how many child rows for each parent

in default binding:? something like this?
SELECT COUNT(id) where parentID = ??this columns ID?? ( i can hard code this if its not possible)
   

- Advertisement -