Search results for query: *

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...

Can i join tables from different server. I am trying to do something like this. Gives me error. select e.jobnumber, baandb.dbo.ttisfc001201.t_pdno, baandb.dbo.ttisfc001201.t_mitm, baandb.dbo.ttiitm001201.t_dsca from dfb_erp.baandb.dbo.ttisfc001201 , dfb_erp.baandb.dbo.ttiitm001201 ...

I want to get in and out time for each emp for each day. My data is somthing like this. id seq Date Time tothrs 5058 1 6/30/2003 7:13:00 AM 713 null 5058 2 6/30/2003 0 0 null 5058 1 6/16/2003 7:02:00 AM 702 null 5058 2 6/16/2003 3:28:00 PM...

MYDATE = 2003616 and MYTIME is not always 4 digits. My data looks something like this 2345,715,1234. Thanks Ann

I tried all different ways still get the same error. I tried to write this way declare @temp_date varchar(20) select @temp_date = (mydate + ' '+ substring(right(('000' + mytime),4), 1,2)+ ':' + substring(right(('000' + mytime),4), 3,2))from varreport update varreport set tc03_date =...

I am writting this query to update TC03_date col. update varreport set tc03_date = convert(datetime,mydate + ' '+ substring(right(('000' + mytime),4), 1,2)+ ':' + substring(right(('000' + mytime),4), 3,2)) tc03_date col is datetime, datatype and mydate and mytime is varchar. Getting this error...