TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
narasiman rao
NA
519
766.6k
when i execute the query output i snot coming correctly
May 14 2013 10:15 AM
SELECT distinct r.rate as Rate,f.bthid as Batchid,CASE WHEN r.rate = '1' THEN '100' WHEN r.rate = '2' THEN '75'
WHEN r.rate = '3' THEN '50' WHEN r.rate = '4' THEN '25' ELSE '0' END AS Translated_Rate FROM bthfac AS f,batch AS b, faculty AS fa,facfeedback AS r where month(b.examdate)= '9' and year(b.examdate)= '2011' and b.bthid=f.bthid and r.bfid = f.bfid and fa.facname = 'MADHAVAN'
when i execute the above query output as follows;
rate Batchid Translated_Rate
0
13
0
3
13
50
4
9
25
1
8
100
4
14
25
1
6
100
2
24
75
2
12
75
4
4
25
1
13
100
but in the above query, when i change the facname (facultyname) and execute the query,same output is coming for all the faculty.
what is the problem in my above sql server query please help me.
Regards,
Narasiman P.
Reply
Answers (
2
)
cannot able to convert ms access database to sqlserver
how to take database backup without ssms for remote server