Professional Web Applications Themes

Bit and Text Columns - Microsoft SQL / MS SQL Server

For bit, you can convert to TINYINT in both SELECT and GROUP BY clauses. Don't understand why you would group by TEXT... you might be better off doing a subquery / derived table. "Merwin12" <pablombumdnj.edu> wrote in message news:0bd501c344bd$e90013f0$a001280aphx.gbl... > I have a sql statement that fails when grouping the > bit and text columns. > > Is there a way to get around this??? > > Thanks....

  1. #1

    Default Re: Bit and Text Columns

    For bit, you can convert to TINYINT in both SELECT and GROUP BY clauses.

    Don't understand why you would group by TEXT... you might be better off
    doing a subquery / derived table.




    "Merwin12" <pablombumdnj.edu> wrote in message
    news:0bd501c344bd$e90013f0$a001280aphx.gbl...
    > I have a sql statement that fails when grouping the
    > bit and text columns.
    >
    > Is there a way to get around this???
    >
    > Thanks.

    Aaron Bertrand - MVP Guest

  2. #2

    Default Re: Bit and Text Columns

    As for grouping on TEXT columns, the only work around I can think of is
    to group on SUBSTRING(<textcolumn>,900). Of course, with this work
    around you will lose a lot of precision.

    Gert-Jan


    Merwin12 wrote:
    >
    > I have a sql statement that fails when grouping the
    > bit and text columns.
    >
    > Is there a way to get around this???
    >
    > Thanks.
    Gert-Jan Strik Guest

Similar Threads

  1. Text across columns
    By Sara_Dehman@adobeforums.com in forum Adobe Indesign Windows
    Replies: 4
    Last Post: August 26th, 02:14 PM
  2. Dynamic text fields. Continuing text over columns
    By gaz f webforumsuser@macromedia.com in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: January 15th, 10:32 AM
  3. text boxes and columns
    By kiaoraFiona webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 2
    Last Post: November 13th, 05:58 AM
  4. Text box into 2, 3 or more columns?
    By TuneRaider2k in forum FileMaker
    Replies: 1
    Last Post: September 7th, 06:32 PM
  5. seperating columns in a text box into multiple text boxes?
    By Greg Doudna in forum Microsoft Access
    Replies: 1
    Last Post: July 9th, 08:12 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