This information is database independent so I cannot use stored procedure s. This information comes in various forms, (DB, text files, excel spreedsheets).
Once I do all the hoops and jumps to gather all the information, I then h ave something to work with and trying to find a good way to work with it. (there are many other fields besides the ones listed, I just didn't want the question to get bogged down). This is going to have to be a Cold Fusion task, cause there really isnt a db only. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder > 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
