Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jul 14, 2010 11:53 AM by Hong-Gang Chen - MSFT
Jul 09, 2010 04:57 AM|LINK
I want to return the count of a tag in a sub routine that corresponds to single result set like so.
SELECT sys_Objects_Tags.TagID, sys_Tags.TagName,
INNER JOIN sys_Tags ON sys_Objects_Tags.TagID = sys_Tags.TagID
WHERE sys_Objects_Tags.SystemObjectID = @BlogID
GROUP BY sys_Objects_Tags.TagName
) Count // <- this column here need to be called "Count" I just need the count here of how many times the tag occures
INNER JOIN sys_Tags ON
sys_Objects_Tags.TagID = sys_Tags.TagID
WHERE sys_Objects_Tags.SystemObjectID = @BlogID AND
sys_Objects_Tags.SystemObjectRecordID = @BlogEntryID
AND sys_Objects_Tags.TableName = 'Blog'
GROUP BY sys_Objects_Tags.TagID, sys_Tags.TagName
Jul 09, 2010 11:32 PM|LINK
Hi Sir ,
can give us a schema about the fields those you're working on .
Jul 14, 2010 11:53 AM|LINK
Please refer this areticle, I think it can help you solve this issue,