Professional Web Applications Themes

refer to a SELECT statement twice - Microsoft SQL / MS SQL Server

newbie question again;) Here i designed a view like this: SELECT ******** UNION SELECT ******** (I cannot put the two SELECT into one because I am using very different way of calculation in the two SELECTs) Both the first and the second SELECT statement refer to an another very complex SELECT statement as it's FROM source. So I wrote: SELECT **** FROM VERY_COMPLEX_SELECT_STATEMENT UNION SELECT **** FROM VERY_COMPLEX_SELECT_STATEMENT is there a way to avoid writing the VERY_COMPLEX_SELECT_STATEMENT twice?...

  1. #1

    Default refer to a SELECT statement twice

    newbie question again;)

    Here i designed a view like this:

    SELECT ********
    UNION
    SELECT ********

    (I cannot put the two SELECT into one because I am using
    very different way of calculation in the two SELECTs)
    Both the first and the second SELECT statement refer to
    an another very complex SELECT statement as it's FROM
    source. So I wrote:

    SELECT **** FROM VERY_COMPLEX_SELECT_STATEMENT
    UNION
    SELECT **** FROM VERY_COMPLEX_SELECT_STATEMENT

    is there a way to avoid writing the
    VERY_COMPLEX_SELECT_STATEMENT twice?
    Zhang Guest

  2. #2

    Default Re: refer to a SELECT statement twice

    > SELECT **** FROM VERY_COMPLEX_SELECT_STATEMENT 

    You could save the reusltset to a temporary table and use the temp table
    later.

    --
    Dejan Sarka, SQL Server MVP
    FAQ from Neil & others at: http://www.sqlserverfaq.com
    Please reply only to the newsgroups.
    PASS - the definitive, global community
    for SQL Server professionals - http://www.sqlpass.org


    Dejan Guest

  3. #3

    Default Re: refer to a SELECT statement twice

    "Zhang Weiwu \(family name first\)" <com> wrote in message news:<047201c35188$ce15c080$gbl>... 

    If the two VERY_COMPLEX_SELECT_STATEMENTs are exactly the same you
    could put them into another view.

    Create view VWComplexSelect
    as
    VERY_COMPLEX_SELECT_STATEMENT
    go

    SELECT **** FROM VWComplexSelect
    UNION
    SELECT **** FROM VWComplexSelect

    hope this helps.

    Kind regards,
    Bart Holthuijsen
    Bart Guest

Similar Threads

  1. help with SELECT statement
    By Chris Hohmann in forum ASP
    Replies: 2
    Last Post: August 19th, 05:10 PM
  2. Need help with select statement
    By Don in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 23rd, 04:53 AM
  3. possible to run a select with an if statement in it?
    By Jim in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 17th, 04:48 PM
  4. Need some help on a SELECT statement
    By Sydney in forum Microsoft SQL / MS SQL Server
    Replies: 5
    Last Post: July 16th, 01:42 PM
  5. Select Statement Help Please
    By Bob in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 14th, 02:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139