Database

Select a.*, (select count(*) from tableB b Where b.belongsTo = a.title) as WHATEVER
from TableA as a

SELECT a.forumTitle, a.lastPost, a.lastUser, COUNT( b.username) AS count, <br />
FROM tbl_Subforums a<br />
INNER JOIN tbl_Messages b ON a.forumTitle = b.subforum<br />
GROUP BY a.forumTitle, a.lastPost,  a.lastUser

SELECT a.forumTitle, a.lastPost, a.lastUser, COUNT( b.username) AS count, COUNT(c.threadTitle) AS threads<br />
FROM tbl_Subforums a<br />
INNER JOIN tbl_Messages b ON a.forumTitle = b.subforum<br />
INNER JOIN tbl_topics c ON b.subforum = c.subforum<br />
GROUP BY a.forumTitle, a.lastPost,  a.lastUser

munklefish wrote:

SELECT a.forumTitle, a.lastPost, a.lastUser, COUNT( b.username) AS count, COUNT(c.threadTitle) AS threads
FROM ((tbl_Subforums a
INNER JOIN tbl_Messages b ON a.forumTitle = b.subforum)
INNER JOIN tbl_topics c ON b.subforum = c.subforum)
GROUP BY a.forumTitle, a.lastPost, a.lastUser

DataColumn column = dataSet.Tables[string tableName].Columns[columnName]<br />
or<br />
DataColumn column = dataSet.Tables[int tableIndex].Columns[int columnIndex]

public object GetValueInRow(<br />
    DataSet ds, <br />
    int tableIndex, <br />
    int rowIndex, <br />
    string columnName)<br />
{<br />
    return GetValueInRow(ds, tableIndex, rowIndex, columnName, DataRowVersion.Current);<br />
}<br />
<br />
public object GetValueInRow(<br />
    DataSet ds, <br />
    int tableIndex, <br />
    int rowIndex, <br />
    string columnName, <br />
    DataRowVersion rowVersion)<br />
{<br />
    return ds.Tables[tableIndex].Rows[rowIndex][columnName, rowVersion]<br />
}

eric_tran wrote:

How should I start?

CREATE TRIGGER trg_AssignProjectUser ON [dbo].[AssignProjectUser] 
FOR INSERT
AS

INSERT INTO AssignTaskUser (UserID,TaskID)
     SELECT inserted.userid,task.id
     FROM task INNER JOIN inserted on task.projectid = inserted.projectid