how to blank row in stored procedure

narasiman rao

11y1.1k

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

narasiman rao11y ago
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 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 combine the first adn secodn query as follows

select First.course,second.Certificate_No,second.Issue_Authority,second.Issue_Date
from
(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') as first
left join
(select distinct b.courseelg,b.coursename,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 first.course = b.coursename and a.stud_id = '9917' ) as second
ON(second.coursename=first.Course)

I share my output as follows

Code Certificate_No Issue _Authority Issuedate

EFA B174/11 HIMT 16 Jul 1999
FPFF
0
Vithal Wadje11y ago
what type of output you want can you share
0