Home Forums SQL Server 2008 SQL Server Newbies Spiltting columns in sql 2008 RE: Spiltting columns in sql 2008

  • October 5, 2012 at 1:49 am

    #1545922

    Trout (10/2/2012)

    hello i have one column that I need split into two, the colum records age value, and the name of the colum is ageatdeath

    results for eg are:

    51years

    62years

    45years...

    What about infants? Is it always 'years' or does your data include 'months' or 'days'?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden