Search results for query: *

I have this query select t1.*,t2.opr,t2.resource_id,t2.PrevOp,t2.NextOp from (select w.type, w.base_id, w.lot_id, w.split_id,w.sub_id, w.desired_want_date,w.user_7 from work_order w where w.type = 'w' and (w.status = 'F' or w.status = 'R' or w.status = 'U') and w.base_id like 'AG%')t1 join...

I need help analyzing if this can be done. I have a table of ops, each having a resource, each resource takes so many days to perform. I have a resource table that shows how many days it takes to complete 1 op, 2 ops, 3 ops etc. of each resource. I have a completion date for the ops. I want to...

I have a view CREATE view [dbo].[AGV_WO_OPR_AND_UDFS] as SELECT [PROGRAM_ID] as id ,[DOCUMENT_ID] as doc ,case when [id] = 'UDF-0000086' then [string_val] else null end as Machine ,case when [id] = 'UDF-0000087' then [string_val] else null end as Prog_Ready ,case when [id] =...

I have a sql statement to gather statistics from an Access table: Select Top 10 yymm,sum(ScrapAero) As AeroScrap,sum(ScrapVendor) as VendorScrap, sum(CompletedQty) as Completed ,(100*(sum(ScrapAero)+sum(ScrapVendor)))/sum(CompletedQty) as [Scrap%] from MonthlyCompletedNMCARsbyPart N where...

Is is possible to create an ADO recordset from tables in 2 different databases (1 a SQL DB accessed through sqlole.db.1 and 1 a non-SQL db accessed through MSDASQL.1)? I want to do a union query on the tables which have the same structure. I want to load the data into a flexgrid.

I have 2 queries, the first SELECT O.WORKORDER_BASE_ID as O_BASE, O.SEQUENCE_NO AS O_SEQ, COALESCE(OP_R.RESOURCE_ID,O.RESOURCE_ID) AS O_RES , FROM OPERATION O LEFT OUTER JOIN OPERATION_RESOURCE OP_R ON O.WORKORDER_BASE_ID = OP_R.WORKORDER_BASE_ID AND O.SEQUENCE_NO = OP_R.SEQUENCE_NO...

I am trying to make a column from 5 other columns of data each 50 rows long. I think I need to code a subroutine or macro but I'm not sure how to get started. Here's the set up: Each column is filled with data or "#value!" (when there is no data). Once the #value! is encountered that's the end...

I am using MSQuery to access data in a SQL database. I am trying to combine a parameter use (from a cell in the workbook) with the Cast statement: My statement SELECT WORKORDER_BINARY.WORKORDER_BASE_ID, CAST(CAST(WORKORDER_BINARY.BITS AS VARBINARY(8000)) AS VARCHAR(8000))...