Professional Web Applications Themes

breaking up one column into two columns - Microsoft SQL / MS SQL Server

I have the following table: Name Austin, Frank Cusp, Jack Ross, Mike Smith, Dave Sears, Edward Thompson, Peter Is there a way to write a query that will return the following result set? LastName FirstName Austin Frank Cusp Jack Ross Mike Smith Dave Sears Edward Thompson Peter I would greatly appreciate any help on this matter. Thanks. Derek Ruesch...

  1. #1

    Default breaking up one column into two columns

    I have the following table:

    Name
    Austin, Frank
    Cusp, Jack
    Ross, Mike
    Smith, Dave
    Sears, Edward
    Thompson, Peter

    Is there a way to write a query that will return the
    following result set?

    LastName FirstName
    Austin Frank
    Cusp Jack
    Ross Mike
    Smith Dave
    Sears Edward
    Thompson Peter

    I would greatly appreciate any help on this matter.

    Thanks.

    Derek Ruesch

    Derek Ruesch Guest

  2. #2

    Default breaking up one column into two columns

    Sure!

    try

    select SUBSTRING(FullName, 1, CHARINDEX(',',FullName)-1)
    LastName
    , LTRIM(SUBSTRING(FullName, CHARINDEX(',',FullName)
    +1, LEN(FullName))) FirstName
    from names
    >-----Original Message-----
    >I have the following table:
    >
    >Name
    >Austin, Frank
    >Cusp, Jack
    >Ross, Mike
    >Smith, Dave
    >Sears, Edward
    >Thompson, Peter
    >
    >Is there a way to write a query that will return the
    >following result set?
    >
    >LastName FirstName
    >Austin Frank
    >Cusp Jack
    >Ross Mike
    >Smith Dave
    >Sears Edward
    >Thompson Peter
    >
    >I would greatly appreciate any help on this matter.
    >
    >Thanks.
    >
    >Derek Ruesch
    >
    >.
    >
    Edgardo Valdez Guest

Similar Threads

  1. Column order and dynamically created columns
    By MattB in forum ASP.NET Data Grid Control
    Replies: 2
    Last Post: December 9th, 07:03 AM
  2. Looping through all rows and columns (to get sub-totals for each column and row)
    By Ralph Hartman in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: August 25th, 12:00 PM
  3. Binding Two DataTable Columns to One DataGrid Column
    By quiggle in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: April 2nd, 04:12 PM
  4. Replies: 0
    Last Post: July 2nd, 06:18 AM
  5. add column between two existing columns with ALTER statement
    By Wyatt in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: June 30th, 06:32 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