Search results for query: *

I have a table holding information on data sent: CREATE TABLE DataSent (SENDERKEY int, RECEIVERKEY int, SIZE int, PROCESSDATE datetime, ... other irrelevant fields ...) I need to generate a report showing the total quantity of data sent or received by a particular account, within a date...

I have a dynamically built query that returns monthly sales totals grouped by product sold, location and salesman. If the customer asked for results from 1/1/2006 to 2/15/2006, the query would look something like this: select n.location,d.salesman_num, d.item_description, (select...

I have a view: CREATE VIEW ViewForCustom867Download AS SELECT h.customerkey, d.REF02_SL_SALESMANNUM as salesman_num, d.PID05_F_ITEMDESC as description, convert(int,d.QTY02_39_SHIPPEDQTY) as qty,d.LIN_UA_UPCCASECODE as upc, convert(datetime,h.DTM02_035_DeliveryDate) as DeliveryDate...

I'm trying to clean up some highly inefficient ColdFusion code which loops through a long list of databases, running dynamically built SQL queries on each one. I'm considering moving the entire process into a stored procedure and would like to do something like the following: /* simplified...