Little help required with T-SQL

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

Use the Group BY clause

-- sum of each ID for all yrs

Select ID,SUM(X) as Total from table Group BY ID

-- sum of each ID yr wise

Select ID,SUM(X) as Total from table Group BY ID,Yr

"Keep Trying"

Saravanan_tvr SSCarpal Tunnel Points: 4558 More actions · Answer 2

I cant understand your expectation,

anyhow use this example

select id,sum(x) from table_name group by id

Mr J Hall of Fame Points: 3595 More actions · Answer 3

Cool thanks, thou I've just found out that views can not contain aggregates functions or Group by 🙁

So looks like it back to the drawing board for me.

Thanks for all your help 🙂

Remember
Without Change something sleeps inside of us that seldom awakens, the sleeper must awaken!!

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 4

Mr J (3/4/2009)...I've just found out that views can not contain aggregates functions or Group by ...

That is not true; they can have both.

ChiragNS One Orange Chip Points: 26137 More actions · Answer 5

You can use group by in views. Check out the example in BOL. It contains group by.

"Keep Trying"