Search results for query: *

Hi, Any help would be appreciated. I have a netbook (Toshiba NB305 Windows 7). It stopped booting a few weeks back. On startup, machine powers, HDD starts reading then nothing - however fan still runs, keys light up etc. I tried the usual restarts, battery out, reset RAM etc. No avail. On...

Hi, Have been messing around with this for a while and thought I would go to the experts rather than banging my head against the wall any further... I have a name field that stores name in the format of Surname,Firstname 2ndname 3rdname etc in a char(70) field eg Smith,John Edward I have the...

Hi hope someone can help. I am trying to create an olap cube using the query wizard in MSQRY32, and am hitting an issue when connecting to password protected access databases. I have tried connecting directly, however it errors for permissions when connecting, prompts for the user/password...

Hi, After a search of this forum, I have seen the question discussed, but no real resolution. I am building a powerpoint presentation that will use a hyperlink/url to a Cognos web output generated from report studio. The link works fine, triggers the report, however I want to bring the chart...

This might be one of those ‘is it worth trying to do?” questions… I need to write some sql to produce a dataset that really makes no sense – however it is a supplied format that we have no control over (legislative requirement). Aside from the other 20+ columns of data, we have been asked to...

Hi, Asking on behalf of someone else... Due a near death of a laptop (happily running XP) a new laptop running Vista was purchased. Version 10 MYOB is not supported on Vista – only version 16. We had purchased the upgrade pack of version 16 not the full install. This is fine except we...

Hi, I need to get a plsql script to clean up a dataset that I have... I have 2 tables, the first is the main dataset and the second a lookup table (location/region). The first table has data that looks like: TYPE EMP_ID CODE START_DT END_DT 1 177 DEP1 04-OCT-01 07-NOV-01 1 177 DEP1...

Hi, I have been given a series of Excel sheets that need to be modified, combined etc. The 'gifted' individuals who have provided the extracts have left a '*' character at the end of a bunch of date values (about 6 columns of dates, 20k+ rows and about 60% have the asterisk). I realise I can...

Hi, Looking for a quick way to convert a date from say '2006-10-15' to a format of 'Oct-06'. Is there any way to do this without tedious case statements? Using UDB for z/OS390 Version 7... I am Sure there is a more elegant way than this: SELECT CHAR(CASE MONTH(CURRENT DATE) WHEN 01 THEN...

Hi, Writing a query that needs to evaluate some values to determine which to bring back. Have 2 tables (trimmed down for clarity) Table 1 Operator_ID Classcount primary_class Table 2 Operator_ID operclass The first table is the parent record. For each user (operator_ID) there is a...

Hi, I have a problem with an extract file that I am trying to use in another application. The file wraps rows of data extracted from a database table that has a 'long' field with carriage returns. What I need to do is to join up the errant rows so that I can then use the file to import. (I...

Help!!! Upgraded (clean install) a PC over the weekend from 98SE to XP home (Sp2). After many frustrating hours....I finally got the modem working, but cannot get any connectivity on the ethernet card. I have uninstalled and re-installed the connectivity (networking services) pulled the...

Hi, Using DB2 Command Centre (UDB 7.1) and need to get rid of carriage returns in my results. Carriage returns are held in 'long' fields - causing a problem with wrapping of text in the results. I have tried replace and translate options but this is not stopping the wrapping - might be my...

(This is a cross posting from the PeopleSoft forum) Hi, Looking at creating some reports in crystal 9 - using the base tables in my database. I have created the ODBC and can connect ok but cannot access all of the tables. I am getting some of the transactional tables (approx 1500), then the...

Hi, Looking at creating some reports in crystal 9 - using the base tables in HCM8.9 rather than just accesing the queries. I have created the ODBC and can connect ok but cannot access all of the tables. I am getting all of the app tables down to the PS_GPNZ... then I get the tools tables...

Hi, I have a large dataset that I need to change to suit a client - and doing it manually is too cumbersome. I have a 30k+ row spreadsheet that has multiple rows of data per person - ranging between 1-25 rows per ID, with a simplified structure like: ID date_from Date_to level etc 1...

Hi, This should hopefully be a quick one - if I knew how to do it. I have a dataset that needds to be cleaned up by inserting a blank row when the ID number in the first column changes. There is no consistent row count for each ID. Looks like ID date attribute1 attribute2 etc 123...

Hi, Having one of those days (and not enough familiarity with date manipulation in Oracle). What I need is a query that will allow me to search for people who will have a birthday within a date range - for example between August 1 and August 15 (irrespective of year). Table Columns: ID...

Hi, I have written a query that looks courses and the course sessions that occur in the next 'x' period. I have added a left outer join to the session enrolment table so that I can look at the number of enrolled students for any session - or courses that have no enrolments This is ok -...

I know this should be easy(!) but it is a little late on a Friday... I need to identify age in whole years as at run date for a query I am writing. Can anyone provide the sql syntax. (been working on sql server and DB2 too much lately.) Have emplid, birthdate, need to derive age in years...