Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 User Defined Functions - Ranking

Author  Topic 

Fatalsniper
Starting Member

45 Posts

Posted - 2005-12-26 : 14:08:29
Hi there,

I have a Database, now I have 3 tables that I have to get a rank of them.
I thought of a User Defined Function with a table as input parameter and a table as return...Is this possible?...
Or do I have to use a stored procedure for this? When I have to fetch each record for the rank...maybe this isn't possible in a UDF.

Any Ideas???

Thanks in advance...

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2005-12-27 : 11:09:15
Explain what you mean by "get a rank of the tables".
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-28 : 01:46:20
Also post some sample data and the result you want

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -