selecting a rowcount where it doesn't exist.

• nobody666

  Grasshopper

  Points: 10

  More actions

  March 13, 2003 at 4:28 pm

  #101406

  I want to do a select that will pull all four rows in a table of two columns (a and b) but tagged on the end is a rowcount. For example:

  select * from table:

  a b

  ---- -----

  ca cal

  wa was

  fl flo

  or ore

  Desired select returns:

  a b xcount

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

  ca cal 1

  wa was 2

  fl flo 3

  or ore 4

  without cursors or temp tables does anyone know how to do this?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 14, 2003 at 3:35 am

  #451082

  Be carefull of duplicating your posts. See/leave replies in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10597&FORUM_ID=8&CAT_ID=1&Topic_Title=selecting+a+rowcount+where+it+doesn%27t+exist%2E&Forum_Title=T%2DSQL