How to convert n number row's to columns in sql..?

Question

0.00/5 (No votes)

See more:

SQL

SELECT
   COUNT(TaskID) AS TotalCount
 FROM TaskDetails TD
 WHERE ReciverID = 4

 SELECT
   COUNT(TaskID) AS TodayCount
 FROM TaskDetails
 WHERE ReciverID = 4
 AND ScheduleCheckPend = '15-12-2016'

 SELECT
   COUNT(TaskID) AS PendingTask
 FROM TaskDetails
 WHERE ReciverID = 4
 AND TaskStatus = 1
 AND ScheduleCheckPend <  '15-12-2016'

What I have tried:

how to convert multiple row values into Columns like
Columns1_TotalCount Columns2_TodayCount Columns3_PendingTask

Posted 15-Dec-16 1:33am

venkatesh (chennai)

Updated 15-Dec-16 9:09am

Add a Solution

2 solutions

Solution 1

I suppose no one ever needed such an operation... Google[^]!

Posted 15-Dec-16 1:39am

CPallini

Comments

Maciej Los 15-Dec-16 14:49pm

5ed!

CPallini 15-Dec-16 17:25pm

Thank you.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2016-12-15T09:09:00

Seems, you need to use subqueries[^]. I'd try something like this:

Solution #1

SQL

SELECT  
  (SELECT COUNT(TaskID) FROM TaskDetails WHERE ReciverID = A.ReciverID) AS TotalCount,
  (SELECT COUNT(TaskID) FROM TaskDetails WHERE ReciverID = A.ReciverID AND ScheduleCheckPend = '15-12-2016') AS TodayCount ,
  (SELECT COUNT(TaskID) FROM TaskDetails WHERE ReciverID = A.ReciverID AND TaskStatus = 1 AND ScheduleCheckPend <  '15-12-2016') AS PendingTask
FROM TaskDetails AS A 
WHERE A.ReciverID = 4

Solution #2

SQL

SELECT  A.TotalCount, B.TodayCount, C.PendingTask
FROM (
    SELECT ReciverID, COUNT(TaskID) AS TotalCount
    FROM TaskDetails 
    WHERE ReciverID = 4
    ) AS A INNER JOIN (
        SELECT ReciverID, COUNT(TaskID) AS TodayCount
        FROM TaskDetails 
        WHERE ScheduleCheckPend = '15-12-2016'
        ) AS B ON A.ReciverID = B.ReciverID
    INNER JOIN (
        SELECT ReciverID, COUNT(TaskID) AS PendingTask
        FROM TaskDetails 
        WHERE TaskStatus = 1 AND ScheduleCheckPend <  '15-12-2016'
        ) AS C ON A.ReciverID = C.ReciverID

For further details, please see:
Subquery Fundamentals[^]
Subqueries in SQL Server - Simple Talk[^]