Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
display userdetail in gridview& totalcount in dashboard /Lbl
Siddharth Chauhan
Mar 19 2017 3:32 PM
182
Reply
ALTER PROCEDURE [dbo].[pDashboard]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @TotalUSers INT
DECLARE @PendingQuery INT
DECLARE @RepliedQuery INT
SELECT @TotalUSers = COUNT(*)
FROM register
SELECT @PendingQuery = COUNT(*)
FROM USerQuery
WHERE QueryReply is null
SELECT @RepliedQuery = COUNT(*)
FROM UserQuery
WHERE QueryReply is not null
SELECT @TotalUSers as TOTALUSERS,
@PendingQuery as PENDINGQUERY,
@RepliedQuery as RepliedQuery
END
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
How to Call multiple time function in java scrip
How to Call multiple time function in java scrip