Recent content by annub

well, when i import files i do where date = 20040315.

Is there a way i can create DTS package where i can get files from previous day. I am doing this process manually through IEW everyday. I want to schedule this package so that it can run on its on and i can get files from previous day. I am using sql 8

I am using VB 6 with SQL 8.I want to update 2 col on my table. I am doing something like this .. Gives me syntex error. I am not sure if i can use alias in update statment , Is it possible to update 2 col at same time ... update laborefficiency l set l.itemno = b.itemno from baandirecthrb19...

I am doing something like this in my select statment Query -1 SELECT Indirectlabcode.Labcode, emplhrdtltest.shiftnumber, emplhrdtltest.jobnumber, SUM(emplhrdtltest.totaltime) AS Expr1, emplhrdtltest.[date] FROM Indirectlabcode INNER JOIN emplhrdtltest ON...

Hello, I am using VB 6.0 with SQL 8.0. Everyday i need import file from different database. I want to write a query so that i dont have to go through this wizard everyday. I always get previous day file. I need to ignore some of the fields while i get data through IE - i dont know how...

I am using VB,SQL and CR 8.5. I want to export my reports to Excel sheet, i am able to do that but when i export data in excel sheet i get one extra raw in between 2 raws. HOw do i fix this problem. Thanks.

I can't change EMPNO field as numberic, coz i get row data from scanner with PQ in front in empno fields, that way i know its not empno & its product qty.

I am using VB 6.0 with SQL 8.0. I want to convert string to number one of my field in table. I am doing something like this. EMPNo is string in table, i want it to be numeric. "select jobnumber,substring(empno,3,8)as empno,shiftnumber,line,date " & _ "From empldtllab &quot...

I am sorry not to provide all the information. I am using VB6.0 with SQL 2000. This is my code to find the record. May be some one can help me now. Private Sub cmdfind_click() Dim Eno As Long 'Dim vbmousepointer As MousePointerConstants rs.Close rs.Open "select...

Hello, I want to give some status or progress bar to user while they are searching the records.

I am getting syntex error 'Missing operator' in this query SELECT DISTINCT dbo.ttdilc101201.t_clot AS Lot, dbo.ttdilc101201.t_cwar AS Warehouse, dbo.ttdilc101201.t_cprj AS project, dbo.ttdilc101201.t_date AS ItemDate, dbo.ttdilc101201.t_item AS Item...

I have 3 tables A,B,C. I have item common col in each table. I need to display all the items form table A and B after where conditions. i am doing something like this. SELECT dbo.ttdilc101201.t_item, dbo.ttdilc101201.t_cwar, dbo.ttdilc101201.t_loca, dbo.ttdilc101201.t_clot...

I want to show users some kind of text or search bar while it search through the records from database. Any examples? Thanks

One of the col in my table is nvarchar datatype & data is something like this. PQ1234,PQ34566,PQ1111. I want to remove PQ's from data. How do i update this col. Thanks

I am joining 5 tables. I get the result but few have dulicate entries not sure why. Please look at my query and tell me whats wrong. select v.tc03_date,e.date,e.empno,v.total_hrs,sum(e.totaltime)scannerhrs,e.labcode,l.description,t.tc01_name,r.dept from varreport v,emplhrdtltest e, timeemp...