Annie Powell

[DataConnection.HandleError]:

Query:
SELECT TOP 5 * FROM
(
SELECT *, ROW_NUMBER() OVER (ORDER BY NewsDate DESC) AS CMS_ORN, ROW_NUMBER() OVER (PARTITION BY DocumentNodeID, NodeLinkedNodeID ORDER BY CASE WHEN DocumentCulture = @DocumentCulture THEN 1 ELSE 2 END) AS CMS_C FROM View_leighday_latestnews_Joined WHERE NodeSiteID = @NodeSiteID AND (AssociatedProfiles is not null and 305 in (select splitValue from dbo.split(AssociatedProfiles,'|'))) AND (Published = @Published AND (NodeAliasPath LIKE N'/News/%') AND DocumentCulture = @DocumentCulture)
)
AS SubData
WHERE CMS_C = @CMS_C ORDER BY CMS_ORN

Caused exception:
Invalid object name 'dbo.split'.