Search results for query: *

Hi, Its been long now, earlier was using editor for ASP as below. Editplus Visual Studio HTML Editor Is there any better editor, which can be used and develop the site faster. Captain

hi, I have created lots of Code and want Menu to display all the buttons whenever Excel is opened. How to do it. Cap

Hi, Currently using MS Access Query to retreive data from Oracle database thrugh ODBC. The query is retrieves all data for a date range given. Requirement is to retrieve only those data with a date range given. Please help Cap

Hi, How to retrieve data from ascii text file which is having 1,000,000 lines or records and store data at a stretch directly in Oracle using Client to Server. Captain

HI, I currently have 15 users having different PC and acccess one PC having data in a folder. Only 10 are able to access this folder (data is on single Windows XP PC). How do I make the other 5 to access this folder. How to make access a single PC for all 15 to access at a same time Captain

hi, How much time will it take to import 20000 or more records from a text file to Oracle database (Client to server). Want to retrieve fast and than check all the 20000 or more records is correct. How to import such large records in Oracle at a one go. Captain

hi, Through connected Oracle database with Access using ODBC. Using access for queries on oracle through MS Access. Whenever using certain date range query, Access outputs all data of Oracle. How to query through MS Access with date criteria on Oracle Database using ODBC with output of those...

hi, Below are two different code. Doing same task. Which is better to use and effective ? Code 1 rs.Open sql, Adoconn, adOpenDynamic, adLockOptimistic rs.AddNew rs.Fields("ItemCode").Value = "AWI01" rs.Fields("Name").Value = "ABDEOD" rs.Fields("DDATE").Value = Date...

hi, In XP have run error-checking on Hard Disk, USB Sony Giga Vault 40 GB. now it is not accessible. Is there way to correct this and bring all data back. Need help. Cap2010

hi all, I am really do not know how to get this. Tried all types of queries. The requirement is as below itemid maxqty Mdate (date is when the max qty went out) 001 5 5/1/2004 002 2 5/10/2004 The actual table has all transaction data as below. itemid qty date...

hi, Want to count rowid. One row by one row and on each do a calculation and than go to next or previous row. In oracle it is Rowid, wonder how to do in SAS for going by row. e.g. in Oracle Select * from table1 where rowid > rowid+1 Captain2010

hi all, I am really do not know how to get this. Tried all types of queries. The requirement is as below itemid maxqty Mdate (date is when the max qty went out) 001 5 5/1/2004 002 2 5/10/2004 The actual table has all transaction data as below. itemid qty date...

Below is the field in the table as event_uuid type_string trap_name event_time Want to find difference from downtime with uptime i.e. diff. Have to subtract from next row when it has uptime. below sql is not working what is wrong SELECT a.type_string, b.trap_name, CASE...

hi, How to identify row id in SAS. select max(rowid) from db.table. or select name from db.table where rowid > db.rowid Cap2010

Hi, Is there a command "diff" in Oracle 8/8i sql. Where can i find further details. Cap

Below is the sql to extract data of same date for the last 12 months. I need data for all last 12 months with same date and also with +/-3 days data. Need help Cap2010 proc sql; SELECT IM.Area, IM.Location, IT.itemid, IT.date, IT.Qty, IT.Rate...

hi, Below is my code, What I wanted is each month max, min, avg qty delivered. What is happening is it gives me data more than once. How can I get as Required Output dd-mm Date item qty 1-4 1 10 2-4 1 5 3-4 1 0 4-4 1 15 Required Output Item...

hi, Want to update / append SAS data from XL below is the sas command and it gives error Unable to append data in SAS, secondly do I have to sort too after appending data Fields Tname is text Counter is number Sdate is date TTime is time option notes source; FILENAME book1 DDE...

hi Is there any other way to get number of records,below is my sql and want to run without distinct, since per item there is only one record per day. SELECT distinct m1.Mtrl_id, Month(m2.date) AS Mth, Count(Year(m2.Date)) AS TotalCount FROM MasterMtrl m1 INNER JOIN MtrlTransaction m2 ON...

hi What's the error, below SQL finds number of records SELECT distinct m1.Mtrl_id, Month(m2.date) AS Mth, Count(Year(m2.Date)) AS TotalCount FROM MasterMtrl m1 INNER JOIN MtrlTransaction m2 ON m1.Mtrl_id = m2.Mtrl_id WHERE (m2.Status<>"1") AND (Year(m2.date)=2004)) GROUP BY m1.Mtrl_id...