Kind of a vague question... Whenever I am returning summaries of data, I tend to do most of my calculation in Transact-SQL (Aggregate Functions, Etc.) -- usually in a stored procedure -- and allow SQL Server to do the work, then use CF to spit it out. However, I don't know if you are using SQL Sever, or what database you are using at all.
If you want to be a little more specific, I might be able to help ^_^ -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 8:32 PM To: CF-Talk Subject: Sorting and Condensing Suggestion This is a tough one to ask... I am trying to find a 'simple' way to do the following: I have a set of data (qty, owner, description) I am getting the data by going through databases and getting bits and pieces of information to create this big list of data.. Where I was heading was to create a query (QueryNew) and giving each of these bits of data their own column. All well and good .. but the end result is to Group all the owners and SUM all their quantities .. but this self built Query won't allow me to do this... Does anyone have any recommendations on how I would slam all this data from different places, group it together so I can see the TOTAL quantity of Each OWNER/DESCRIPTION value? (Owner and description go hand in hand). Thanks in advance. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
