Hi

create FUNCTION mon_allstat(@sdate datetime)

RETURNS TABLE

AS

RETURN

(

SELECT distinct month(shpdate)as ddate from allstat where

[allstat].shpDate=@sdate

)

Thanks all, it has helped me to certain extent.

Ur valuable suggestions based on ur experiences are appreciated.

Share ur thoughts !!!

Nice article. Keep it up.

Neetu

Hello,

actually i wanted to say that in our Table B.

the data is present in this way:-

Ref_No        Pro_No

1                 11

1                 22

1                33

1                 44

2                33

2                  44

2                 22

2                 11

3                  44

3                  55

3                  33

3                   22

Now data is in...

Who say's SQl does not contain queries, as the name suggest SQL-Structured Query Language.

This language is for querying.

Thanx 4 sending me code but my query was to view  top 5 states(which u have solved) and for each state their 2 top schools also. I have to present...

Top 5 states are selected on the basis of the overall marks(all schools, all students of that particular state) of individual states. 

If question comes of choosing between 5th and...