Looping in Sql to insert data in to table

Question

I have a SQL statement:

select 
    tms.Team, Count(tms.MSApprovedNPC) as JulyNPCResults 
from 
    tmsorder2 tms
where 
    Msapprovednpc not in ('N/A','No') and Month(Month) = 11 and Year(month) = '2013'
group by 
    tms.Team

these results are for a specific month of July 2013.

Now I want to load the results in a table NPRData for other months in to one table which has columns like

TEAM, JulyNPRResults, AugNPRResults, SepNPRResults, OctNPRResults

How can I loop the above query to insert data for other months?

Thanks in advance

As i have multiple months to insert in to NPRData i need to Loop the above query for all the months rt? — SqlLearner
– SqlLearner, Commented Apr 14, 2014 at 20:00

Hart CO · Accepted Answer · 2014-04-14 20:04:02Z

2

I would advise against storing your data in a denormalized format. It would be better to have a table like:

NPRData (Team,YearMonth,Results)

But you can do this without looping via a conditional SUM() or COUNT():

SELECT tms.Team
     ,SUM(CASE WHEN MONTH(Month)=11 and YEAR(month) ='2013' THEN 1 END) As NovNPRResults
     ,SUM(CASE WHEN MONTH(Month)=12 and YEAR(month) ='2013' THEN 1 END) As DecNPRResults
FROM tmsorder2 tms
WHERE Msapprovednpc NOT IN ('N/A','No') 
GROUP BY tms.Team

answered Apr 14, 2014 at 20:04

Hart CO

34.9k6 gold badges52 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Looping in Sql to insert data in to table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related