Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Column Data Conversion when calling Select Statement
amarnath reddy ambati
Sep 14 2014 4:15 PM
734
Reply
Dear All,
Can you help me below task:
I have a table with Ename nvarchar(50), Desig nvarchar(50),Status nvarchar(50)
Table Data is:
id
Ename
Desig
Status
1 Amar Admin 0
2 Sai TL 1
3 Vishal PM 0
When calling with Select Statement
Status
Column
I
want to show shows
0
is
Not Available 1
is
Available 2 Working
Please Help Me
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Column Data Conversion when calling Select Statement
Stored Procedure