SQLTeam.com | Weblogs | Forums

PageCount returning -1

#1

I have a query that is pulling data from a view and was returning PageCount correctly, however I've modified my view to include data from a dynamic view, this is the view that my queried view is pulling from;-

SELECT t1.[Asset Tag], [Census Group] = REPLACE
((SELECT [Census Group] AS [data()]
FROM v_SystemCensus_Services t2
WHERE t2.[Asset Tag] = t1.[Asset Tag]
ORDER BY [Census Group] FOR XML PATH('')), ' ', '|')
FROM v_SystemCensus_Services t1
GROUP BY [Asset Tag];

However since adding this I now get "-1" when querying it via asp classic and using PageCount. Any ideas why this is the case.

0 Likes