How to create computed column in SQL Server 2008 R2 [closed]

Question

I have a SQL Server 2008 R2 database. This database has two tables called Pictures and PictureUse.

Picture table has the following columns:

Id (int)  

PictureName (nvarchar(max))    

CreateDate (datetime )

PictureUse table has the following columns :

Id (int) 

Pictureid (int) 

CreateDate (datetime )

How to create a computed column in the Picture table which tells me that how many times this picture has been clicked?

If the question was reworded to ask about the strategy to measure resource usage, it might fit better. For what its worth, I feel metrics are a such a distinct concern they shouldn't share the same logical record space as the resource definition. E.g. the metrics would be a separate table and separate set of queries.

bummi · Answer 1 · 2012-11-21 08:50:15Z

You can't create calculated fields which use other tables. You can create a View instead. e.g.

Create View V_PictureUseCnt as
Select p.ID,p.Picturename
,(Select Count(*) from PictureUue u where u.PictureID = p.ID) as cnt
From Picture p

closed as off topic by thorsten müller, gnat, ChrisF♦ Nov 21 '12 at 8:56