SQL Server 2000, Create View question

• washingtonen

  Old Hand

  Points: 370

  More actions

  December 13, 2008 at 4:13 pm

  #195035

  Hi, I need your help!

  I need to create a SQL Server 2000 view with this format:

  SELECT

  case when failed = 'N' then

  (select * from aaa)

  else

  (select * from bbb)

  end

  FROM

  dimstatus

  The command succeed but when I try to execute I get this message:

  Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

  I also tried to create it with an IF statement, but I figured out that the IF is not allowed, can you please help me?

  Thanks SO much in advance,

  Joe.

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  December 13, 2008 at 5:20 pm

  #912121

  Please do not cross-post.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• washingtonen

  Old Hand

  Points: 370

  More actions

  December 13, 2008 at 5:26 pm

  #912126

  Sorry, first time here.