Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 need help to built query

Author  Topic 

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2010-05-19 : 08:18:32
gre

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-05-19 : 08:28:54
select
ProductID,
CategoryID,
sum(Sales) over (partition by CategoryID) as Sales
from #Product



No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-05-19 : 09:03:07
gre?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-05-19 : 09:03:50
gre = ffg

see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=144808


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -