No one has followed this question yet.
How to store the result in Temp Table from EXEC command ?
How to execute powershell script from sql server stored procedure?
T-SQL: Stored proc with temporary table
I have a report which will pull the data from this stored procedure.But dropdownlist in the report is showing NULL in the middle of other datas(Alphabetical order).I want NULL as first value in the drop downlist(so that easy for selecting)