Query Criteria question
I am designing a query. One of the fields in the query is "department". In my form there is a pull down menu with about 20 departments. In my query, I am making the department field have a criteria so that when you run the query, it asks for which department. However, if you do not type the...
I am designing a query. One of the fields in the query is "department". In my form there is a pull down menu with about 20 departments. In my query, I am making the department field have a criteria so that when you run the query, it asks for which department. However, if you do not type the...
5 pts.
Oracle Query: Return a date eg 29 February 2008
Hi How can I return the last day of the second month of the current year in Oracle Thanks in advance
Hi How can I return the last day of the second month of the current year in Oracle Thanks in advance
AS400 Qry - Is there a way to trick qry into treating blanks as null?
The data I need to sort on is in either field A or B depending on the transaction type. It could be accomplished by using the "value" expression if qry would consider a blank field as null. Any ideas?
The data I need to sort on is in either field A or B depending on the transaction type. It could be accomplished by using the "value" expression if qry would consider a blank field as null. Any ideas?
Difficult SQL query, is this possible?
Two tables, First Table --FN---LN----Reasons John | Doe | 6 | Jane | Doe | 2 | ----------------- That's the end of the first table. Second Table ---Reason----Reason Detail----- 2 | Invalid SSN 4 | Invalid Date Of Birth...
Two tables, First Table --FN---LN----Reasons John | Doe | 6 | Jane | Doe | 2 | ----------------- That's the end of the first table. Second Table ---Reason----Reason Detail----- 2 | Invalid SSN 4 | Invalid Date Of Birth...
How to make a single row in SQL
Dear all, Please help me I am not good in sql queries. I have a view like this. SNo Employee title Cdate IN TIME OUT TIME 258 john accountant 27/01/2008 7:28:12 258 john accountant 27/01/2008 7:28:30 258 john accountant 27/01/2008 16:03:42 258 john accountant 27/01/2008 16:03:48...
Dear all, Please help me I am not good in sql queries. I have a view like this. SNo Employee title Cdate IN TIME OUT TIME 258 john accountant 27/01/2008 7:28:12 258 john accountant 27/01/2008 7:28:30 258 john accountant 27/01/2008 16:03:42 258 john accountant 27/01/2008 16:03:48...
a query
I have query of Placement. as fallow: client OpenedDate ClosedDate 1 1/2/05 1/20/06 1 2/05/06 3/2/06 1 4/2/07 2 1/2/06 I want to add another field to this query to tell me each time how long a take this client to open again. and another field...
I have query of Placement. as fallow: client OpenedDate ClosedDate 1 1/2/05 1/20/06 1 2/05/06 3/2/06 1 4/2/07 2 1/2/06 I want to add another field to this query to tell me each time how long a take this client to open again. and another field...
oracle multi-field row query with more than one row
I have a table that specifies the year, and a quantity for each month, in the same row. I need to get a 12 month rolling average, which involves particular fields from one row, and addition fields from another, based on the sysdate. There are several tables that need to be joined to ensure I have...
I have a table that specifies the year, and a quantity for each month, in the same row. I need to get a 12 month rolling average, which involves particular fields from one row, and addition fields from another, based on the sysdate. There are several tables that need to be joined to ensure I have...
MS Access Query
I have a table that has item information by store. I am looking to get back the top 25 items in each store. I can't figure out how to run this. If I use the "Top 25" tag I only get the top 25 through all stores, not by store. Anyone have any suggestions?
I have a table that has item information by store. I am looking to get back the top 25 items in each store. I can't figure out how to run this. If I use the "Top 25" tag I only get the top 25 through all stores, not by store. Anyone have any suggestions?
Query Criteria
Hello. I have a report with multiple subreports. User enters date range when prompted from query in main report. I want to refer the subreport date criteria to the date range the user enters for the main report, via the query. I used this in the query criteria under the date...
Hello. I have a report with multiple subreports. User enters date range when prompted from query in main report. I want to refer the subreport date criteria to the date range the user enters for the main report, via the query. I used this in the query criteria under the date...
SQL Query that only Returns the Newest Invoice date for an ITem
I am try to write a query that will give me a list of ITems that have a a quanity of greater than 0 on hand and only latest date and Item was invoiced. Here is what i have come up with so far SELECT IV00101.ITEMNMBR, IV00101.ITEMDESC, IV00101.CURRCOST, IV00102.QTYONHND,SOP30200.SOPNUMBE,...
I am try to write a query that will give me a list of ITems that have a a quanity of greater than 0 on hand and only latest date and Item was invoiced. Here is what i have come up with so far SELECT IV00101.ITEMNMBR, IV00101.ITEMDESC, IV00101.CURRCOST, IV00102.QTYONHND,SOP30200.SOPNUMBE,...
Scheduling queries in AS/400
What is the easiest way to schedule several queries to run several times throughout the day??? Will the Advanced Job Scheduler accomplish this or would writing a simple CL program be easier? Or is there any other methods?
What is the easiest way to schedule several queries to run several times throughout the day??? Will the Advanced Job Scheduler accomplish this or would writing a simple CL program be easier? Or is there any other methods?
Sql Query - Unique item with latest date of entry
Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are tuples which show multiple entries for single itemN, for example. item 1 has...
Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are tuples which show multiple entries for single itemN, for example. item 1 has...
Julian to Gregorian Date Conv. in DB2 Web Query
I have a julian dates stored in the format YYDDD numeric, 5 positions, zero decimal. How do I convert to a true Gregorian date in DB2 Web Query for iSeries?
I have a julian dates stored in the format YYDDD numeric, 5 positions, zero decimal. How do I convert to a true Gregorian date in DB2 Web Query for iSeries?
Oracle table column names starting with a number
Hello, I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work. Is there any way to...
Hello, I just finished creating MANY tables that have column names starting with a number. I didn’t realize it was an issue until I started trying to select data from my tables using the column names in the where clause. Inserts work. Selects without where work. Is there any way to...
How to write the query
How to write the query from one table.(i don't want first row and second row)
How to write the query from one table.(i don't want first row and second row)
