کار نکردن مقدار خروجی COUNT(1) AS CountOfID

[fakhravari]

با سلام
SELECT TOP (2) NewsID, Title, Abstract, Contents, AddDate, img,
(SELECT COUNT(1) AS CountOfPostID
FROM Comments
WHERE (PostID = TBLNews.NewsID)) AS Comments,
(SELECT SUM(Rating) AS SumOfRating
FROM RatingPost
WHERE (PostID = TBLNews.NewsID)) AS Rates,
(SELECT COUNT(1) AS CountOfID
FROM RatingPost AS RatingPost_1
WHERE (PostID = TBLNews.NewsID)) AS Rates
FROM TBLNews
ORDER BY NewsID DESC
اما قسمت های COUNT(1) AS CountOfPostID و SUM(Rating) AS SumOfRating و COUNT(1) AS CountOfID در برنامه نویسی به مقدار های as آنها دسترسی ندارم.
دوستان به چه شکل عمل کنم:متفکر:

[fakhravari]

دوستان کسی نبود

[Abbas Amiri]

جداولتان را آپلود کنید تا بهتر مشخص شود.

[fakhravari]

با سلام
من 3 جدول دارم.

1)جمع نظرات.
2)جمع امتیاز و تعداد افراد رای دهنده.
3) جدول اخبار
شما برای این جدول چه کدی مینویسید

[Abbas Amiri]

در فایلتاناثری از جدول TBLNews نبود

[fakhravari]

بله اسمشو اشتباه زدم NewsID گذاشتم .:اشتباه:
NewsID میشه TBLNews.
حالا با توجه به جداول شما چه کدی مینویسید:متفکر:

[fakhravari]

با سلام
جواب بدست اوردم.

ALTER PROCEDURE dbo.RatingAmar
AS
begin
SELECT TOP (6) NewsID, Title, Abstract, Contents, AddDate, img,
(SELECT isnull(convert(nvarchar(50),Count(1)),'0')
FROM Comments
WHERE (PostID = TBLNews.NewsID)) AS CountOfID,
(SELECT isnull(convert(nvarchar(50),Sum(RatingPost.Rating) ),'0')
FROM RatingPost
WHERE (PostID = TBLNews.NewsID)) AS SumOfRating,
(SELECT isnull(convert(nvarchar(50),Count(1)),'0')
FROM RatingPost AS RatingPost_1
WHERE (PostID = TBLNews.NewsID)) AS CountOfPostID
FROM TBLNews
ORDER BY NewsID DESC
end;


:بوس: :لبخند: