Viewing 7 posts - 1 through 7 (of 7 total)
Hi
create FUNCTION mon_allstat(@sdate datetime)
RETURNS TABLE
AS
RETURN
(
SELECT distinct month(shpdate)as ddate from allstat where
[allstat].shpDate=@sdate
)
Neetu Sharma
June 26, 2012 at 10:06 pm
Thanks all, it has helped me to certain extent.
Neetu Sharma
March 29, 2006 at 5:25 am
Ur valuable suggestions based on ur experiences are appreciated.
Share ur thoughts !!!
Nice article. Keep it up.
Neetu
Neetu Sharma
December 26, 2005 at 3:59 am
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...
Neetu Sharma
November 8, 2005 at 10:43 pm
Who say's SQl does not contain queries, as the name suggest SQL-Structured Query Language.
This language is for querying.
Neetu Sharma
September 22, 2005 at 4:02 am
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...
Neetu Sharma
September 16, 2005 at 5:58 am
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...
Neetu Sharma
September 16, 2005 at 3:37 am
Viewing 7 posts - 1 through 7 (of 7 total)