|
|
| |
Terms of Agreement:
By using this article, you agree to the following terms...
1) You may use
this article in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this article (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this article from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the article or article's description. |
Let's think we are having a table with different PEOs for each FirmID.
Table name : tblRanking
FID PEO
----------- -----------
120000331
120000630
120000930
120001231
220000331
220000630
220000930
220001231
To give ranking for PEOs for each CompanyId, add one column, say "Rank" to
the present table and use the following script.
//-------------------
ALTER TABLE tblRanking ADD Rank int NULL
drop table #fid
declare @Start int
declare @FID int
select @Start = 0
select distinct fid into #fid from tblRanking
update t1 set @Start = Rank = case
when t1.fid = @FID then @Start + 1 else 1 end,@fid = t2.FID
from tblRanking t1 ,#fid t2 where t1.fid = t2.fid
select * from tblRanking
//-------------------
FID PEO RANK
----------- ----------- -----------
1200003311
1200006302
1200009303
1200012314
2200003311
2200006302
2200009303
2200012314
| |
Other 3 submission(s) by this author
|
|
| |
| Report Bad Submission |
|
| |
| Your Vote! |
|
See Voting Log |
| |
| Other User Comments |
There are no comments on this submission.
|
|
| Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this article has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular article, please click here.
|
|
