Search results for query: *

I'm sure this is easy but I've been banging my head on it for a while and can't come up with the proper solution, I have two tables maintaining transaction records for items, whscosthdr [whh_cdate,whh_username,whh_trans_no,whh_tsource,whh_from_loc,whh_to_loc,whh_pct_incr] whscostdtl...

I have a query that totals up sales at retail and cost by Group/Location. Up to this point I have been just ordering my results by group name (alphabetically) and by location. I need to now sort by results by the Group with the most sales. So if my results before were like the following, CHILD...

I need to make a join between 3 tables, where the 3rd table is dependent on the join of the first two. Here's an example to elaborate, Table A A.col1 A.col2 ... A.colN Table B B.col1 B.col2 B.col3 ... B.colN Table C C.col1 C.col2 C.col3 ... C.colN I need col1 from table A, col2 from table B...

I need to write a query selects all items from an inventory table 'MenuItem' that have sold since a user specified date. The sales table 'Custinv' has a record for every item sold by date and location (quite a large amount of records). I'm not really sure how to proceed, should I be joining...

Whenever I try to enable a secondary display on my laptop it detects the monitor but then all it does is flash the desktop and then go black, like it's stuck in this auto-detect loop or something. I have tried multiple monitors and get the same thing. What's even funnier is that it worked the...

I am running ubuntu server 9.10 with Tomcat 6, using java-sun-jdk. Tomcat is running but throws an error when I'm trying to start the openreports webapp, here's the error: SEVERE: Exception sending context initialized event to listener instance of class...

I'm having some problems coming up with a "Top N Of Group" query. I've googled it as well as gone through this forum but cannot come up with anything that works. Here's my situation, hopefully someone might have some tips to point me in the right direction. I have 3 tables needed in the query...

I have written a query, although provides the correct results, I'm wondering if my limited sql skills have made it a bit disorganized. I was wondering if someone can have a quick look and possibly punch some holes in the way I am doing things. First I'll explain the tables being used, syloctn...

I have a table that contains a set of ranges. Is it possible in one query to create a summary of a column from another table by range? So I guess something like this Select SUM(detail_table.f1) FROM detail_table GROUP BY detail_table.f2 This would be similar to a group by date range, but the...

Is there any way of creating a temporary table from a partitioned table? I do not require the partitions for the temporary table, just the table structure. Mysql gives me the error "Cannot create temporary table with partitions" using the command CREATE TEMPORARY TABLE tmp_tbl LIKE tblname...

I'm trying to do a join between two tables, one with no more than a couple of hundred records and one with about 4 million. My issue is that mysql is ignoring my index on the large table thus making the query extremely slow. Here's my query, select...

I have a table that contains sales summaries by item and date period. The date field is actually a 7-digit Clarion representation of a date (ie., 74563). The sales summaries are saved for each week/month/year period. I need to write a sales query off this table that will compare sales between...

I developed a report in Crystal 8.5 connecting to a SQL Server (well the MSDE engine). The report is actually using a stored procedure. The stored procedure takes only a 4 or 5 seconds to run but the report takes forever reading in the records (can be upwards 50000 records). It seems to read...

This query will probably not make much sense but is there a way to select a single record from a table but have the record show up x number of times (x specified by parameter at run-time). This would be the same as doing a union all on multiple copies of the same query, ie., SELECT field1 FROM...

I have a query that is working but runs extremely slow so I'm trying to re-write it to improve performance. My query involves 3 tables. SYINVHDR and SYINVDTL store item detail information by category and location while SYINVHIS stores sales summary information. My query gets a set of items...

I have three tables that I need to left join and I'm having some problems getting the results I need. 'promo_items' is a table containing a list of items on promotion 'syinvdtl' contains item detail information, by location 'syinvhis' contains sales information for items by location & date I...

I'm trying to copy some files from a network path from within a servlet. I realize that I cannot use drive letter mappings as they are profile specific. Instead I'm trying to use the unc path. I'm getting the following error when I read the error inputstream from the process: Command: xcopy...

I need to loop through a set of commands in a dos program via script. Bascially I need a script to do the following: 1. Launch DOS App Loop N times 2. Enter text in window 3. Send "Enter Key" (x2) 4. Enter text 5. Send "Enter Key" (x3) Exit Loop 6. Sent "F5 Key" (x2) 7. Send "Enter Key" Is...

I'm trying to modify some columns using an sql script. The columns are part of the primary key or indexes of the table. How can I do this with a script, I know I can do it with Enterprise Manager. When I use the following: alter table master alter column [ID] varchar(3); I get the following...

I have a txt file that I need to import regularly into a database. The fields are separated by '|' but the problem is that there can be whitespace after the field and the length of this whitespace can vary. The reason being is the txt field is created by a report engine that pads any field data...