I wish to use a stored procedure that queries a database and returns multiple values for the same field. Then with these values i wish to order them into colums and rows. Have you any examples of this.
eg.
Name Date of Birth Address Telephone this is constant
John 4/3/1945 --------- ---------- the procedure runs through the database and returns all the
Steve 27/6/1963 -------- --------- users that satisfy it's requirements.