How to run a query in SQL and get the result back in a SharePoint Field?

See more:

SQL

SharePoint

SharePoint2010

Hi,

I have a query in SQL that will add 1 to the current rank of "contractors"(table column) and put that in a new column. Those new updated values will need to be bring back to SharePoint. Once I create a new Item in a SharePoint list, it needs to know the current "rank"(table column) of the contractors so I can choose contractors based on the actual rank. Every time I create/saved a new Item the rank needs to be incremented by 1 in the SQL Table.

The SQL part is OK.

Now I need to complete the SharePoint part that like I said needs to keep record of the current rank for the selection.

Thanks.