InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 15:12:42 GMT20http://www.sqlservercentral.com/Forums/Topic1018353-1495-1.aspxThanks for the question.Wed, 24 Nov 2010 11:44:56 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1018353-1495-1.aspxGood question. Nice extension - Carlo. ThanksThu, 11 Nov 2010 21:23:49 GMTHardy21http://www.sqlservercentral.com/Forums/Topic1018353-1495-1.aspxThanks for the question.One small point, not only did the create for the second table fail, so did the drop. (Though I doubt that would trip anybody up.)Wed, 10 Nov 2010 09:53:17 GMTUMG Developerhttp://www.sqlservercentral.com/Forums/Topic1018353-1495-1.aspxQOD is a very good one, and the extension by carlos was awesome. Good work guys, got to learn something new today.Thanks.Wed, 10 Nov 2010 07:59:00 GMTSuriihttp://www.sqlservercentral.com/Forums/Topic1018353-1495-1.aspxI gift this question fife stars for knot havings type o's and shows correct referance meaterials and knowledge of SQL feartures.I give the extra star to Carl for the post of how a function can include the column data from another table in a computed column.:smooooth:Wed, 10 Nov 2010 07:29:41 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1018353-1495-1.aspxGood question, and to Carlos - great addition. Learned something new form bothWed, 10 Nov 2010 06:08:57 GMTsjimmohttp://www.sqlservercentral.com/Forums/Topic1018353-1495-1.aspxNice question.And thanks to Carlo for the add-on.Wed, 10 Nov 2010 03:23:16 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1018353-1495-1.aspxGood question!I was pretty sure that the first create would fail since the operator ^ isn't described in BOL under arithmetic operators. It never occured to me that it could be a bitwise operator. I just assumed it was an attempt to make me think it was a "to the power of" operator.DOH!Wed, 10 Nov 2010 01:06:58 GMTRune Bivrinhttp://www.sqlservercentral.com/Forums/Topic1018353-1495-1.aspxTo get values from other tables or columns of the same table but different row, you should use a function:[code="sql"]CREATE TABLE [dbo].[a2]([a1ID] [int] NULL,[col3] AS (a1ID^2))GOcreate function get_a2_col3(@a1id int)returns intasbegin return (select col3 from [dbo].[a2] where a1ID = @a1id)endgoCREATE TABLE [dbo].[a3]([a3ID] [int] NULL,[col4] AS dbo.get_a2_col3(a3ID) --(dbo.a2.col3 - 1))GOdrop table [a2]drop table [a3][/code]Wed, 10 Nov 2010 01:06:36 GMTCarlo Romagnanohttp://www.sqlservercentral.com/Forums/Topic1018353-1495-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/T-SQL/70958/">More of computed columns</A>[/B]Tue, 09 Nov 2010 20:27:10 GMTVM-723206