Combined Address
I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address.Someone suggested that I create a calculated field. I tried this but all that it is doing is pulling...
Answer Question
| May 12 2008 5:29 PM GMT
| asked by
Thuzinec
SQL, Query, Microsoft Access
Is there a query to search text of all SQL Server database objects that reference a specific table/instance?
We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?
View Answer
| May 7 2008 3:49 PM GMT
| asked by
SQL Server Ask the Experts
Query, SQL Server migration, Database objects
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...
Answer Question
| Apr 24 2008 12:08 AM GMT
| asked by
Jena
Query
Oracle Query: Return a date eg 29 February 2008
HiHow can I return the last day of the second month of the current year in OracleThanks in advance
View Answer
| Apr 24 2008 11:45 AM GMT
| asked by
Csshahie
Oracle, Query
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?
Answer Question
| Apr 23 2008 7:42 PM GMT
| asked by
Sands
AS/400, QRY, Query
Difficult SQL query, is this possible?
Two tables,First Table--FN---LN----ReasonsJohn | 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--------------------------------------That's...
View Answer
| Apr 16 2008 11:37 PM GMT
| asked by
David Phillips
SQL, Query, Query tuning
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...
View Answer
| Feb 20 2008 6:31 AM GMT
| asked by
Binu.emiliya
Query, SQL queries, SQL
a query
I have query of Placement. as fallow:client OpenedDate ClosedDate1 1/2/05 1/20/061 2/05/06 3/2/061 4/2/072 1/2/06I 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 to tell me...
View Answer
| Feb 5 2008 5:26 PM GMT
| asked by
Kconnolly
Query
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...
View Answer
| Jan 31 2008 5:38 PM GMT
| asked by
Seashellm
Oracle, SQL, Query
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?
Answer Question
| Jan 30 2008 4:03 PM GMT
| asked by
Hollouise
Microsoft Access, Query
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...
View Answer
| Jan 14 2008 7:24 PM GMT
| asked by
Bec
Query, SQL
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 farSELECT IV00101.ITEMNMBR, IV00101.ITEMDESC, IV00101.CURRCOST,IV00102.QTYONHND,SOP30200.SOPNUMBE,...
View Answer
| Jan 11 2008 5:44 PM GMT
| asked by
Ken Foster
SQL, Query
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?
View Answer
| Dec 28 2007 11:22 PM GMT
| asked by
Johnny5
Scheduling, Query, Advanced Job Scheduler
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 three...
View Answer
| Dec 17 2007 6:44 PM GMT
| asked by
SmurkyIS
SQL, Subquery, Distinct
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?
View Answer
| Nov 7 2007 4:22 PM GMT
| asked by
Screechtx
DB2, iSeries, Query
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 keep the...
View Answer
| Nov 2 2007 0:56 AM GMT
| asked by
Jaime
Oracle, PL/SQL, Query
How to write the query
How to write the query from one table.(i don't want first row and second row)
View Answer
| Oct 26 2007 11:10 AM GMT
| asked by
SQL Server
SQL Server 2000, Query
