In the SQL syntax SELECT A, B, (C-D) AS E, the "E" is an alias to an existing variable(s) and for that reason an alias in itself cannot be used within the same query as the entity it represents. T_SQL does not support proving variable as column alias in a query. What you can do to achieve the desired result is to use nested tables for your query...a temp table in the script structure can help you loads. Evans ________________________________ From: "skunkworks-request@lists.my.co.ke" <skunkworks-request@lists.my.co.ke> To: skunkworks@lists.my.co.ke Sent: Tuesday, May 15, 2012 1:54 PM Subject: Skunkworks Digest, Vol 27, Issue 124 Send Skunkworks mailing list submissions to skunkworks@lists.my.co.ke To subscribe or unsubscribe via the World Wide Web, visit http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks or, via email, send a message with subject or body 'help' to skunkworks-request@lists.my.co.ke You can reach the person managing the list at skunkworks-owner@lists.my.co.ke When replying, please edit your Subject line so it is more specific than "Re: Contents of Skunkworks digest..." Today's Topics: 1. Re: @iLabAfrica-Google Mobile Boot Camp (victor yegon) 2. Re: Domain Transfer Problem (Steve Muchai) 3. SQL Help (julianne anyim) 4. Re: SQL Help (Christian Ledermann) 5. Re: SQL Help (Rad!) 6. Best prices HWIC 1FE Card - 2800 Series Router (benson maina) 7. Re: @iLabAfrica-Google Mobile Boot Camp (Leonard Kore) 8. Re: SQL Help (Richard Gathogo) ---------------------------------------------------------------------- Message: 1 Date: Tue, 15 May 2012 12:48:30 +0300 From: victor yegon <viktayeg@gmail.com> To: Skunkworks Mailing List <skunkworks@lists.my.co.ke> Subject: Re: [Skunkworks] @iLabAfrica-Google Mobile Boot Camp Message-ID: <CAOtXiXeSUewOEjRh+jNzktgfEhZRA_QmA7uvjnnzMpFi_UnbHg@mail.gmail.com> Content-Type: text/plain; charset="iso-8859-1" I have also trie opening with safari and ie still not working On Tue, May 15, 2012 at 12:45 PM, Wanjohi Ndegwa <andegs2000@gmail.com>wrote:
Sorry guys, it was working upto a minute ago. I now also cant access it.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke ------------ List info, subscribe/unsubscribe http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------
Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- Regards Yegon Victor Web Specialist/Internet Consultant Freelance Webs Specialists http://freelancewebspecialists.kbo.co.ke <http://salient.co.ke/>