Search results for query: *

Hello: I have an access 2003 program that reads a sql database, this is accomplished using ODBC connection and produces a very complex report. This report has been running for several years with no problems. Randomly I get an error stating "Network error" or "disk error". I have plently of...

Hello: Here is the problem: I have 4 users that use access 97 on an xp system. When the 4th users adds info to their access database the other three do not see the entries. When users 1-3 add info to their database the 4th users does not see the entries. All four are accessing the same...

Question: Is there a way using ms sql server that I can query a sybase database. Are there settings that I need on sql server that I need to set to point to the sybase database??? so I can use ms query analyzer? Thanks for any ideas.

Question: Can a sybase database be queried using ms sql server. Are there settings that I need to enter on the sybase side or ms sql server side??? Thanks for any ideas.

Hello everyone: I need to answer this if else question in a sql query: if status has changed from leave of absence (loa) to active what is the enddate of the leave of absence (loa). My MS sql database contains two table ebase and eemploy there is one record for every employee in ebase and...

CASE WHEN EETERMDATE IS NULL THEN ' ' ELSE CONVERT(CHAR(10),EETERMDATE,101) END as TerminationDate, --(28) In the statement above the following if statement is coded if eetermdate is null then blanks else convert eetermdate to a date format What if I wanted to code the...

Hello Everyone: Here is my problem I have a field that is numeric and the contents are 86.68000000000000007 field name is emhoursperpay. In order to find hours worked per week my formula is the following round(((emhoursperpay * 24.00/52.00),2) as hoursworkedperweek The formula above...

Hello Everyone: Is there a way in sql when you have a field that has date time stamp to extract the mmddyyyy and formatted into mm/dd/yyyy and forget about the time area? Any ideas are welcome. Thanks. Rick

Hello Everyone: Short question how do I copy a char array to another char array or swap elements from one array to another. I tried to use pointers but with no success. My array's are defined as alphadata [10] [15]. Any ideas are welcomed. Thanks.

I have a small project and I do not know where to start Here are the specs. A program that will allow the user to enter a shopping list of up to ten items. The user will enter the item name, qty, and aisle # where the item is located. The user will then be able to select either of two options...

Hello Everyone: Just a short question how do I pass the parameters entered in a query to a report so I can print it on the header? It is the starting date and ending date that the op. enters in the query and I need these dates to be printed on the report. Any ideas. Thanks. epnico

Hello there: Is it correct that Adaptive server anywhere does not support cursor for statements?? If true what can I do? Thanks.

Hello: Giving the following query: SELECT M. POLICY_ID, EXRTCD= ( CASE WHEN COUNT(DISTINCT M.STATE_ID) > 1 AND COUNT(DISTINCT M.ACTION_CODE_ADJ_VALUE_INPUT) > 1 THEN '3' END) FROM WCPS.PERIOD_ACTION_CODE AS M GROUP BY M.POLICY_ID; I get an error stating there is...

Hello: I have a query that I wrote in MS SQl 7.0 when I transfered to Sybase it has a big problem with the case statement for some reason it does not like the "AND" is this a restriction in Sybase? Here is the sample Query: select m. policy_id, ExRtCd= case when count(distinct...

Hello Everyone: Just a general question has anyone used SQL to create the famous NCCI(National Council on Compensation Insurance) Electronic file for policy reporting. If you have I just wanted to get some feedback as to your approach on the problem? Thanks.

Hello Everyone: Here is my sql query, I'm MS SQL 7.0 accessing a sybase database. I need the result of my query to be by location_number but anytime I try to place the order by command SQL does not like it. Any ideas as to how I can get the resulting set of the union by location number...

Hello: I found a 9 inch mono SVGA monitor with a small keyboard that was used on a computer register system. The keyboard works fine on my AST BRAVO LC 5133 all I have loaded on this sytem is DOS 6.22 for some legacy programs that I use in development. I would like to use the monitor...

Hello Everyone: In using the Interactive SQL that comes with Powerbuilder 7. I'm a bit confused about the output statement. Here is my sql statements. output to test1.txt; begin select * from wcps.policy where wcps.policy.policy_no = '1234567'; end In running the above first I get an...

Hello: Here is my MS-SQL statements in dealing with the timestamp field: select * from wcps..wcps.policy_header_phrase where ncci_transaction_code = "01" AND updt_dt_tm = '20011011' the field updt_dt_tm is a timestamp field. When I run the above query I received...

Hello: In MS SQL version 7.0 is there a way to query a timestamp field so I can get an an exact date? In my research for this I found a Teck-tip that mentions that you cannot query a timestamp field? Thanks for any ideas.