#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    10
    Rep Power
    0

    How to create in View new row after each next row.


    Hi,
    Is here some way how to create new row after each row in View ?
    Row should have same count of columns and their names and I would like to use conditions to fill them.

    Example:

    row A : 120 2122 bike 20130203 --- row from table from dbs
    row B : 120 4444 012 0 ---new row

    Is it possible?(by procedure or somehow else?)
  2. #2
  3. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,163
    Rep Power
    4274
    UNION query, where the second subselect produces your counts
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    10
    Rep Power
    0
    Originally Posted by r937
    UNION query, where the second subselect produces your counts
    thx a lot

IMN logo majestic logo threadwatch logo seochat tools logo