tsql help

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  February 24, 2005 at 2:14 pm

  #163484

  My table has one row each of id = '1111'and '222'but is there a way i could display 3 rows as output

  using script

  select *

  From lookup_vw(nolock)

  where cod = 'oac'

  and acc_id in ('1111', '222', '222')

  tia

• rhunt

  SSCertifiable

  Points: 5868

  More actions

  February 24, 2005 at 2:16 pm

  #544020

  From your post I guess you are trying to duplicate ID = '222', but not '1111', right?

  How about:

  select *

  From lookup_vw(nolock)

  where cod = 'oac'

  and acc_id in ('1111', '222')

  UNION ALL

  select *

  From lookup_vw(nolock)

  where cod = 'oac'

  and acc_id in ('222')