Search results for query: *

Hi, The table has more then 1,000,000 records. The ado hangs for 2 - 5 minutes after update or insert 3000 record. Only option is to move those updated or inserted record, then it runs fast. Field datatype - Text - length 50 Why does ado hangs after 3000 record with table having more then...

Hi to all, How to make sure below SQL is updating right price ? Need to update only 1000 transaction with correct price, on or after effective date. There are 1000 transaction and on running below SQL query, message shows updated 2130 transaction record. Update TransactionTbl T1 INNER...

Hi, Want to have a constant value stored in a variable or field and then use it in every different queries to avoid prompts ? e.g. 1) Created a table with constant value Example: Table: tblItem and field: fldItemNbr with a value item1001 2) Below query gives error...

Hi, There 2 tables with same Product name with different numbers. Need compare side by side as below or . Table1 Table2 ProductName Qty ProductName Qty Diff (Table1-Table2) 1) A 5...

Hi, I am trying to get list of unique values from each column with number of records. E.g. A table with 10 columns, then will be writing 10 times to get unique values and number of records as Select distinct field1, count(field1) from table1 group by field1 Is it possible to do...

Hi Experts, Need your help/feedback in how to find a value in a cell. After finding store it in next column. 1) Source file (array) ItemId I1001 I1005 I1004 I1993 I3940 2) Target file (Sheet1) Column A Column B Column C Date CustomerId...

Hi, Can only use Access SQL for below tables and after trying different queries, like crosstab giving different result. One crosstab result appears with unique row with separate columns for itemref. Select distinct cust_email, Item_ref from UserList UL right join Product P on...

Hi, Trying to find out whether below SQL Server - SQL style works in oracle. On testing SQL in Oracle, it gave Error: Ora-00923 from keyword not found where expected SQL Server code: Select aid, sum(amount) from ( Select t.aid, t.isbn, amt = (t.price * r.royalty) from...

Hi, Wanted to filter on variable YrMth, that store value as yyyymm (datattype as number). On using proc sql with condition as WHERE YrMth = 201505, the result returns 0 rows. How can we use filter that has value stored as yyyymm and return rows instead 0 row ? Thanks, DaiChi

Hi, searching for sql with a prompt to user for entering input may be date or character. Is there any example available to review for proc sql with a prompt ? I searched, unable to find one. Thanks, Techit

Hi All, Recently, created excel file in English. But want to send this file in French. Wanted to know how to save/send file in French ? as have users in French. Thanks, TechIT

Hi, Is there a link or simple code to export the sql server result without using Import / export wizard. Planning to export result in either excel,csv,accdb,mdb,pdf format TechIt

Hi, Trying find number of item sold and paid. There are 3 tables and taking value from each table for the result. Tables: 1) tProduct_Sold 2) tSub_Product_Details 3) tStore_Location e.g. tProduct_Sold PK Item_id date 1 1/1/2015 2 1/2/2015 3 1/3/2015 4...

Hi All, Want to convert below Namelist in matrix form Tab: NameList Column A Column B Names Status Derek Agent Acton Team Lead Ukrit Manager Eamon Agent Earl Agent Tab: Matrix how to convert in matrix as Column B Column C Column D Agent Team Lead Manager...

Hi All, I want to add 2 columns: Hr and Half_Hr and update these column. Table B: Hours Hr, Half_Hr, Time_Start, Time_End 0, 0.1, 12:00:00 AM, 12:30:59 AM 0, 0.2, 12:31:00 AM, 12:59:59 AM 1, 1.1, 1:00:00 AM, 1:30:59 AM 1, 1.2, 1:31:00 AM, 1:59:59 AM 4, 4.1, 4:00:00 AM, 4:30:59 AM 4, 4.2...

Hi All, By using REST VBA API with a parameter, need to query website and download data in either text delimited or csv file and perform this operation 2000 times. Did little research on REST API, all I found was documentation on REST API with hardly any REST VBA API examples. what needs to...

Hi, When using DSUM in query to get running total, it works. Problem is without dsum getting error. Error is 'Tried to execute a query that does not include the specified expression 'Total_Amt' as part of Aggregate function' SQL having error: select a.YrMth, sum(a.Total_Amt) as aTotalAmt...

Hi, Is it possible to create array of 4 dimension. Array values in one line, with changing sheet name and range Question 1: assigning arrays values in one line ? Question 2: giving value using below worksheet code ? . sheet, range, sheet, range Arry(1) = "Sht1", "A2:D4"...

Hi, Below is the code for creating table from data queried by prompting user to enter customer id. If Customer exist, create data history of customer. Planning to run this query via VBA using ADO or VBA coding with already provided customer id through a variable assigned from excel cell...

Hi All, Using VBA code, trying to open website in Internet Explorer browser, fill data form from excel to web and then save it. Most of the task is done like opening asp website. Trouble is selecting particular tabs on asp website and saving data after updates. Below is the code for IE Sub...