calculating 2 fields

[missbusiness]

hi,
im trying to divide two fields in a database like this: crterm=bal/pi but im not sure how to write it in sql. any suggestions?

[urtrivedi]

update mytable set  crterm=bal/pi where somecolumn='my condition'

[Brian Swan]

This is by no means a complete answer (that will depend on your exact scenario), but it should get you started:

CREATE TABLE [dbo].[Table_2](
	[Num1] [decimal](18,9) ,
	[Num2] [decimal](18,9) ,
	[Quotient] AS CAST(Num1/Num2 AS [decimal](18,9))
)

This should allow you to do this:

insert into Table_2 (Num1, Num2) values (1,2)

(The Quotient column will have the value of 0.5)

Note that this doesn't protect against division by zero.

Hope that helps.

-Brian