Need SQL Query

Question

Need SQL Query

chbanub4u

Newbie

Points: 2
More actions
June 18, 2012 at 3:49 am

#260026

Where FieldId and FieldValues are repeating, i need to query sum of field values based on the dates.
EX - select sum(Fieldvalue) from EntityItemDetails where fieldid=21 and ((FieldValue<='12/20/2011' ANd FieldId=19) and ((FieldValue>='12/20/2011' ANd FieldId=19)))

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

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

InvisibleCat Default port Points: 1496 More actions · Answer 1

Hi,

I'm not sure exactly what you are asking but I think you are refering to a 'GROUP BY', check out BOL and see if that's what you are after.

If not then can you clarify in a bit more detail what you are trying to acheive please?

chbanub4u Newbie Points: 2 More actions · Answer 2

plz check below link

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/c2fbd89c-d954-43b1-946b-f66b63efee45

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

You will need to start from here:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

InvisibleCat Default port Points: 1496 More actions · Answer 4

Hi,

Yes, I think you should be able to do this using a GROUP BY, if you are not familiar with that then there are loads of good examples on the internet, and BOL (Books OnLine) will document it as well.

It's pretty much like saying, I have 3 columns (Country, Town and number of people). You would say the following;

SELECT Country,

Town,

SUM(NumberOfPeople)

FROM TableA

GROUP BY Country,

Town

You are just saying, sum the people, by Country and Town.

You just need to change this to work with your table and columns.

If after you've read about it you still need some help then let me know.

Nic