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
768.4k
how to blank row in stored procedure
Mar 11 2015 2:38 AM
select * from tb_courseelg_settings where coursename = 'MFA' or coursename = 'AFF'
When i run the above query output as follows
Coursename Eligibility
MFA EFA
AFF FPFF
First query as follows
select distinct Course = case cr.cpm_pkg_id WHEN '' THEN cr.cmn_minor_code else cbm.cmn_minor_code end
from course_registration cr, batch_course_registration bcr, co_batch_master cbm where bcr.cr_bill_no = cr.cr_bill_no and cbm.cbm_batch_id = bcr.bcr_batch_id and cr.cr_active = 'A' and cr.stud_id = '9917'
When i run the above query output as follows
Course
MFA
AFF
Second query as follows
select distinct a.pm_prof_code as Code,a.sp_cert_no as Certificate_No,
a.sp_issu_authority as Issue_Authority, convert(char(14),a.sp_issu_dt,106) as Issue_Date from student_professional a,tb_courseelg_settings b
where a.pm_prof_code= b.courseelg and b.coursename ='MFA' and a.stud_id = '9917'
When i run the above query output as follows
Code Certificate_No Issue_Authority Issuedate
EFA B174/11 HIMT 16 Jul 1999
I want to combine the above First query and second query and output as follows
Code Certificate_No Issue_Authority Issuedate
EFA B174/11 HIMT 16 Jul 1999
FPFF
Note: Because MFA eligbility is EFA and AFF eligbility is FPFF.
For AFF no record is there in the tb_courseelg_settings.
So i want to add blank row.
for that how can i do in asp.net using c#.
Regards,
Narasiman P.
Reply
Answers (
2
)
when i run the stored procedure show error
how to insert a empty row using sql server