79719839

Date: 2025-07-30 11:05:37
Score: 1
Natty:
Report link

If you want to use a field from the returned table in a local variable you can use the following:

SELECT Top 1 @Name=[Name] from [dbo].FN('Some text')

I have a similar problem in that I have a TVF that takes a latitude and longitude and returns a location as an Easting/Northing pair and I need to extract each value in turn. This is how I solved accessing the individual fields.

Reasons:
  • Blacklisted phrase (1): I have a similar problem
  • Blacklisted phrase (0.5): I need
  • Whitelisted phrase (-2): I solved
  • Whitelisted phrase (-1.5): you can use
  • Has code block (-0.5):
  • Me too answer (2.5): I have a similar problem
  • Low reputation (1):
Posted by: Rarius