Posted by Ken Post on 10/25/05 04:39

Simple stupid mistake! Never mind.

Had a table UDF, not Scalar UDF for the function that returned the
address number and some messed up thinking.

Here's what I've got now, and it works just fine.

SELECT
Possibles.*,
dbo.udf_ReturnAddress(FoundPersonID, 1) AS FullAddr1,
dbo.udf_ReturnAddress(FoundPersonID, 2) AS FullAddr2
FROM
dbo.udf_ReturnPossibleDupsForAPerson(@PersonID) Possibles

WAYYYY simpler now.

So, for those of you who may have found this by searching for crosstab,
there's a way to create a crosstab, with no temp table, but with a
FIXED number of columns, not dynamic. (not that this is a unique
solution, there's lots of other postings on it too...)

• Next in forum: too many connections
• Prev in forum: User Defined Functions, passing parameters from another udf's results (end result=Crosstab)
• Thread view: Re: User Defined Functions, passing parameters from another udf's results (end result=Crosstab)

[Reply to this message]