AnsweredAssumed Answered

How to display text status instead of CurrentStatusID

Question asked by Walter Bednarz on Nov 1, 2011
Latest reply on Nov 2, 2011 by Joy Garon

I have this SQL query:

  

select Filename,CurrentStatusID

from Documents

where

Filename like 'SUM-00%.xml'

and

Deleted=0

 

The results look like this:

Microsoft SQL Server Management Studio_2011-11-01_13-44-45.jpg

 

How do I display the text value of the status instead of the numeric id?

Outcomes