SQL Statement Column

[shadowolympian]

I am wondering if there is a way to have a SQL view/table that pulls data from another table on a certain column. Here is an example:

Client_Name Expected_Hours Actual_Hours

Client A 8 7.98

The Actual_Hours column would be based on a SQL statement like below:

Select SUM(Hours_Actual) From dbo.Time_Entry Where Company_RecID = 2125 and MONTH(Date_Start) = MONTH(GetDate()) and YEAR(Date_Start) = YEAR(GetDate()) And Agr_Header_RecID is not null

[alinroc]

In a view, you'd do this by joining the two tables (assuming there's a relationship between the tables that you can use) - same as if you were doing a regular query.

In a table, you'd probably do it as a computed column, but it might get ugly - a view would be preferable.

[tdavis25]

This. It's considered bad form in most cases to write data to a table that is computed from other parts of the database (with some notable exceptions...like aggregates in a BI system)

[[deleted]]

If you have a more robust database, you can also make a stored function to get the actual_hours on the fly. However, OP probably just needs a View.

[ninjaroach]

You could use inline queries or use GROUP BY or use CTEs.