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 Skip, Tried performing order by effective date and then update. However it showed updating with different rate. It seems best to follow 1) Group each effective date on descending order 2) Then update rate on group of each effective date descending order with TrDate > = EffectiveDate...

T1.TrDate >= T2.EffectiveDate displays update will be 2130 T2.EffectiveDate >= T1.TrDate displays update will be 1302

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, Found a solution, but query runs slow to give result. Looking for other query option to run faster select t.ItemNbr, SubItem, ItemName, sum(Qty) from TableMtrl, (select max(fldItemNbr) as ItemNbr from tblItem) as t GROUP BY t.ItemNbr,SubItem...

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 dhookom, Thank you - first union then left join to UNION worked. Thank you again.

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 Andrzejek, Thank you, it works. Ken

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 Majp, Data is external. Secondly, forget the days where one will get with some unique primary key. Nowadays, one need to work from the data that is available and find out primary key, create a table, process and provide the output. In this case, yes the table received are as is for product...

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 Stefanhei/fredericofonseca, Thank you for the follow up, SQL works when using 'as' instead of equal sign in Oracle. (e.sal * .1) AS in_amt -> will work in_amt = (e.sal * .1) -> gives same error Conclusion, Oracle 11g will not accept equal sign 'IN_Amt = (e.sal * .1)'. Thanks, Ken

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 Duane, For even getting total the numbers are increased twice due to tSub_Product_Detail has 2 rows for each item. After running below query the counting is twice instead of 1. SELECT SL.LocationName, SPD.Sold_Status, SPD.Payment_Status, Count(SPD.Payment_Status) AS...