Aligning two tables two datasets when side by side

• Johnny D

  Ten Centuries

  Points: 1030

  More actions

  December 5, 2008 at 5:11 am

  #383521

  Hi,

  I have two tables which provide data from two separate datasets and I would like them to align horizontally. This is when they are placed side by side. Is this possible? I cannot seem to find anyway to do this. An example is:-

  Table 1

  id Name Age

  1 Tom 21

  2 Ed 33

  3 Jo 23

  Table 2

  Time Score

  17:33 5

  12:21 3

  09:10 9

  I would like the first row in Table 1 to align with the first row in Table 2 and the 2nd row in Table 1 to align with 2nd row in Table 2 etc.

  So it would look like this:-

  id Name Age Time Score

  1 Tom 21 17:33 5 <-- Alignment this way

  2 Ed 33 12:21 3

  3 Jo 23 09:10 9

  These are in two separate tables and two separate datasets. How can I align them at the moment they are all over the place even though the tables cells are set to the same size in height and width.

  Any help would be appreciated.

  Thanks in advance.

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  December 5, 2008 at 1:06 pm

  #908626

  Above is a duplicate post

  resolved in this post

  http://www.sqlservercentral.com/Forums/FindPost614656.aspx

  SQLServerNewbieMCITP: Database Administrator SQL Server 2005