Home Forums SQL Server 2008 SQL Server 2008 - General Adding text to Rank RE: Adding text to Rank

  • May 15, 2013 at 9:08 am

    #1615483

    Hi guys, please i need another help. Please how can i use this particular data:

    Insert into TestTable(AdDate, AdTime, Fk_StationId)

    Select 2013-04-01,07:52:00,A1

    Union All Select 2013-04-01,07:52:43,A1

    Union All Select 2013-04-01,08:05:06,A1

    Union All Select 2013-04-01,08:20:45,A1

    Union All Select 2013-04-02,20:12:38,A1

    Union All Select 2013-04-02, 20:13:10,A1

    Union All Select 2013-04-02, 20:13:10,A1

    Union All Select 2013-04-02, 20:14:00,A1

    Union All Select 2013-04-01,06:00:00,A10

    Union All Select 2013-04-01,06:03:12,A10

    Union All Select 2013-04-01, 06:19:01,A10

    Union All Select 2013-04-01,06:32:31,A10

    Union All Select 2013-04-01, 06:43:36,A10

    Union All Select 2013-04-02, 08:08:54,A10

    Union All Select 2013-04-02, 08:08:54,A10

    Union All Select 2013-04-02, 08:58:46,A10

    Union All Select 2013-04-02, 08:58:46,A10

    To get something like this

    For the first day e.g 1 of 4, 2 of 4 for each Fk_stationId

    Then for the second day also 1 of 4, 2 of 4

    But on running it, its giving me 1 of 8, 2 of 8 since they all belong to the same Fk_StationId

    Please how can i resolve this

    Thanks

    Tim