Post reply

SQL query

  • December 27, 2011 at 8:04 pm

    #250474

    I have input below format:

    TO_Date FROM_SM TO_SM FROM_BM TO_BM CSC_CODE

    2011-04-09 00:00:00.0000000 Muneer Hussain Anwar Basha M S Rama M S Rama R16001

    2011-06-06 00:00:00.0000000 NULL Dayakar V M S Rama Ramapriyan Mukunthan R16001

    2011-09-22 00:00:00.0000000 Dayakar V Muneer Hussain Ramapriyan Mukunthan Ramapriyan Mukunthan R16001

    2011-10-27 00:00:00.0000000 Muneer Hussain Anwar Basha Ramapriyan Mukunthan Ramapriyan Mukunthan R16001

    --------------

    OUT PUT

    From_Date To_Date SM BM

    2011-04-01 00:00:00.0000000 2011-04-08 00:00:00.0000000 Muneer Hussain M S Rama

    2011-04-09 00:00:00.0000000 2011-06-05 00:00:00.0000000 Anwar Basha M S Rama

    2011-06-06 00:00:00.0000000 2011-09-21 00:00:00.0000000 Dayakar V Ramapriyan Mukunthan

    2011-09-22 00:00:00.0000000 2011-10-26 00:00:00.0000000 Muneer Hussain Ramapriyan Mukunthan

    2011-10-27 00:00:00.0000000 2011-12-28 00:00:00.0000000 Anwar Basha Ramapriyan Mukunthan

  • December 27, 2011 at 10:59 pm

    #1425933

    i don't get exactly what you are try to get here. please elaborate additionally please give same data with create and insert script to get quicker result.see my signature below

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • December 28, 2011 at 1:06 am

    #1425972

    CREATE TABLE Master_Data

    (TO_Date DATE,FROM_SM VARCHAR(100),TO_SM VARCHAR(200),FROM_BM VARCHAR(500),TO_BM VARCHAR(200),CSC_CODE VARCHAR(100))

    insert into Master_Data values('2011-04-09 00:00:00.0000000','Muneer Hussain','Anwar Basha','M S Rama','M S Rama','R16001')

    insert into Master_Data values('2011-06-06 00:00:00.0000000','NULL','Dayakar V','M S Rama','Ramapriyan Mukunthan','R16001')

    insert into Master_Data values('2011-09-22 00:00:00.0000000','Dayakar V','Muneer Hussain','Ramapriyan Mukunthan','Ramapriyan Mukunthan','R16001')

    insert into Master_Data values('2011-10-27 00:00:00.0000000','Muneer Hussain','Anwar Basha','Ramapriyan Mukunthan','Ramapriyan Mukunthan','R16001')

  • December 28, 2011 at 1:18 am

    #1425976

    your required/expected output ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • December 28, 2011 at 2:28 am

    #1425991

    From_Date To_Date SM BM

    2011-04-01 00:00:00.0000000 2011-04-08 00:00:00.0000000 Muneer Hussain M S Rama

    2011-04-09 00:00:00.0000000 2011-06-05 00:00:00.0000000 Anwar Basha M S Rama

    2011-06-06 00:00:00.0000000 2011-09-21 00:00:00.0000000 Dayakar V Ramapriyan Mukunthan

    2011-09-22 00:00:00.0000000 2011-10-26 00:00:00.0000000 Muneer Hussain Ramapriyan Mukunthan

    2011-10-27 00:00:00.0000000 2011-12-28 00:00:00.0000000 Anwar Basha Ramapriyan Mukunthan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply