Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Ken
  • Order by date
  1. Ken

    Why ADO hangs after 3000 records while inserting or updating ?

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

    UPDATE SQL - shows updating more then required record?

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

    UPDATE SQL - shows updating more then required record?

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

    UPDATE SQL - shows updating more then required record?

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

    Is there a way to assigned constant value instead of entering prompt in SQL ?

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

    Is there a way to assigned constant value instead of entering prompt in SQL ?

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

    I need to display each product per row and compare number side by side

    Hi dhookom, Thank you - first union then left join to UNION worked. Thank you again.
  8. Ken

    I need to display each product per row and compare number side by side

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

    Array in T-SQL

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

    How to search a string in a cell and paste founded value in next cell ?

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

    How to use SQL to get multi-row to single column output

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

    How to use SQL to get multi-row to single column output

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

    How to make SQL sub query work in Oracle, getting error ?

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

    How to make SQL sub query work in Oracle, getting error ?

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

    how can we filter on yyyymm in proc sql ?

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

    user prompt in proc sql with parameter

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

    How to save Excel file from English to French or other language

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

    How to export sql result to excel,csv,mdb,pdf ?

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

    Listing wrong number of items sold and paid - need help

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

Part and Inventory Search

Back
Top