Adding dummy data to a column in SQL Server
<p>I need to add/display dummy data in a column when there are no rows in the output.</p>

<p>Ex: I have written a query which sometimes returns data. But if there is no data, I wan to display one of the column as "No Data Available".</p>

<p>Here is the initial query I am using:</p>

<pre><code>select CaseNumber,[Description]
from table1
</code></pre>

<p>I tried using:</p>

<pre><code>SELECT CaseNumber,
       CASE
         WHEN CaseNumber IS NOT NULL THEN [Description]
         ELSE 'No Data Available'
       END AS [Description]
FROM   table1 
</code></pre>

<p>It is not working. Please help.</p>

<p>Thanks</p>