|
|
Posted by Erland Sommarskog on 05/27/06 00:52
(skosmicki@sfmc-gi.org) writes:
> I need to create an function similar to the "MATCH" function in Excel
> that evaluates a number within a set of numbers and returns whether
> there is a match. I have put the example of what I see in excel in the
> check column. The "0" answer in the result column is in the fourth
> account in the list. Somehow I need to loop through the accounts
> comparing the result to the total and indicate a match in the check
> column. It wouldn't even need to tell me the row number; it could be a
> 0 or 1.
I'm afraid that the MATCH function is unknown to me. I tried to read
about it the Excel Help, but in a hurry I could not make much out of it.
I was trying understand the numbers. I looks bit like credit/debit,
but the names "total" and "result" indicates something else.
So I would suggest that you give a more detailed explaination of your
business problem.
An extra hint is that if you include a CREATE TABLE statment for your
table and INSERT statements with the sample data, you are likely to
get a tested solution.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|