Home Forums SQL Server 2005 Development split single row into four rows. RE: split single row into four rows.

  • April 9, 2013 at 1:35 am

    #1604700

    abhas (4/9/2013)

    Thanks matak.

    I will try this.But my actual requirement is to insert this data into table after selecting from front end dropdown. for example if user selects date like 2012/03/23 and select start time as 7am and end time as 8am then i want to insert this by splitting into four rows.

    Thanks

    Abhas.

    Assuming you want to pass the date and the two times into SQL Server, what datatype are these three variables?

    “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