J
J Jones
I have 400 rows in the TRAIT_NOTES tabel but my sp. returns just 87 records
any idea why that may be?
ALTER PROCEDURE dbo.GetTraits
AS
SELECT
1 AS TAG
,NULL AS PARENT
,NULL AS 'TRAITNOTE!1!'
,NULL AS 'Result!2!CONDITION'
,NULL AS 'Result!2!NOTE'
UNION
SELECT
2
,1
,NULL
,[CONDITION]
,[NOTE]
FROM TRAIT_NOTES
FOR XML EXPLICIT
RETURN 0
any idea why that may be?
ALTER PROCEDURE dbo.GetTraits
AS
SELECT
1 AS TAG
,NULL AS PARENT
,NULL AS 'TRAITNOTE!1!'
,NULL AS 'Result!2!CONDITION'
,NULL AS 'Result!2!NOTE'
UNION
SELECT
2
,1
,NULL
,[CONDITION]
,[NOTE]
FROM TRAIT_NOTES
FOR XML EXPLICIT
RETURN 0