Norman Maina
asked on
sql computed column
Hello,
I am trying to have a column with a bit datatype to be a calculated column.
what am trying to achieve is to automaticaly change the value of the column to either True or False depending on where a view that checks quantities in another table has zero balances or not.
Thanks in advance,
Norman
I am trying to have a column with a bit datatype to be a calculated column.
what am trying to achieve is to automaticaly change the value of the column to either True or False depending on where a view that checks quantities in another table has zero balances or not.
Thanks in advance,
Norman
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys -I was going that direction but changed my mind.Learnt quite abit about calcu;ated columns though :)
http://cactussoft.com/ITUtopia/?p=36
http://sqlserverpedia.com/blog/sql-server-bloggers/updateable-views-%E2%80%93-how-to-use-them/