Search results for query: *

Thanks mate for the effort. As you said the columns have been hard coded so one has to go back each time to update the script when there is a new staff. I will be sticking to your idea for the time being until I can find better solution. Thanks once again frank

Hi all, my query lloks like this -: DEPT COURSE STAFF WEEKLY_HRS HHB A2ACCO Paul G 2 SAM A2BIOL Lois L 5 SAM A2BIOL Alph A 10 HHB A2BUSS Kizito A 3.5 ELE A2COMS Lorr G 3 ELE A2COMS Isabelle P 2 APM A2DNCE Rebek H 3.5 I would like it to be like this:-...

Hello Guys Is it possible to script the sql statement of a view or a table from sql plus command line ? I am working on an ODBC via Access and I need to see the sql statement of this view. Help will be much appreciated. thanks frank

Thanks I have got it working now.. frank

Dear guys. I am trying to covert a string to date format. this field is suppose to be a date field but it is a char. this is what I did..... to_date(max(date_last_seen)last_att values in the field are eg. 01/02/05 this is the error msg I get "ORA-01843: not a valid month" can anyone help. thanks

Hi sem, I did try your suggestion and it is working beautifully thanks a lot frank

Hello everyone. I am have a tough time here and need some help. I am trying to find the diff between 2 times and display result in hrs or min - but I am not getting the result. Here is eg. of my query select to_number((finish_time)-(start_time)) if finish_time is 15:30 and start_time is 14:00...

Thank you very much Mr Abdulla it's working beautifully. farnk

dear all how can i number my report list; eg 1. xxxxxxxx xxxx 2. xxxxxx xxxx 3. xxxxxx xxxxxx etc thanks frank

Hi, how can i present a verical information in horizontal format. eg.see format below id name course 10 John Eng 10 John Maths I would like to present this report as: id name course 10 John Eng,Maths so that every person on more than a course appear just once any ideas...

Hi Guys, How do you write a script to copy all values from one column to another column. For example I have two columns EnquiryDate and ActionDate in a table. The ActionDate is have Null values at the moment. I would like to copy dates in each of the enquiryDate field to its corresponding...

HI YOU CAN SET IT UP THROUGH ENTERPRISE MANAGER... GO TO MANAGEMENT then SQL SERVER AGENT then JOBS. If you havnt used this tool before you need to read about it before you can find it useful.

Hi try this script..... SELECT distinct tbl_document.* FROM tbl_document WHERE document_id NOT IN (SELECT document_id from tbl_document_group_intersect WHERE document_id is not null) UNION SELECT distinct tbl_document.* FROM tbl_document WHERE document_id NOT IN (SELECT document_id from...

Hi Guys, I am using DTS to migrate a large data to SQL2000. We wish to change all PK's to computer generated no.keys during migration. How can I also change all the FK's to match the new prim keys. I mean is it possible or I have to stick with the old primary keys to ensure referential...

Hi Guys, We are doing a major project on data migration from a UNIX based database to SQL2000. I intend to use DTS tool as most books recommend but the project manager disagrees with me. He thinks the best way is to gather all the field names and records in one big flat file (text file) and then...

Hi Everyone I am trying to use 'select into' statement to copy a table and its contents to a new table This is the error message I got " Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option." Can you help me. Thanks