I have a function that covnerts IPv6 into IPv4 and I need it to loop through each row in the table to perform the conversion.
The pertinent columns in the proxy table are
[ClientIP] -- this contains the IPv6 entries
[IPv4] -- I added this column in order to host the converted values.
What is the best method to accomplish this? Please note that my TSQL programming is only of a fundamental level!
I have attached the function and I can retrieve an output for single values such as:
SELECT [proxy].[dbo].[fnIpAddressToText] (
this obviously only accomplishes one conversion and I need it to loop through all the entries in a relatively large table (hundreds of thousands of rows).
We are using SQL Server 2008R2.
All help appreciated!