raghuldrag (9/10/2012)

---

alter procedure Goals_history
(
@stuid nvarchar(22),
@startyear nvarchar(22),
@endyear nvarchar(22),
)
as
begin
select name,class,noofsubject,rank,test from @tab1
union
select name,class,subject,rank,test from @tab2
where rank is not null
and studentname=@stuid
and accodomicyear>=@startyear
and accodomicyear<=@endyear
end

OUTPUT:
class noofsubject rank test name
2 5 1 revision ravi
2 5 - monthly raju
2 5 3 midterm ravi
6 4 - monthly somu
2 5 - revision ravi

expectin outputrank is null means show first)
class noofsubject rank test name
6 4 - monthly somu
2 5 - monthly raju
2 5 - revision-II ravi
2 5 1 revision ravi
2 5 3 midterm ravi



:NOTE
\ null values ve print first row of output.....
not null is ve to print with space.... how to define

raghuldrag (9/11/2012)

---

hey friend
i am executing dis qury on sql server 2000 only...its not server 2008

raghuldrag (9/11/2012)

---

hey friend
i am executing dis qury on sql server 2000 only...its not server 2008