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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. cfcProgrammer

    getting mulitple records in query result???

    Thank you very much Olaf for your help, your explanation is greatly appreciated and understood. Enjoy the rest of your day!! :) Cfcprogrammer cfcProgrammer
  2. cfcProgrammer

    getting mulitple records in query result???

    Hi OlafDoschke, Thank you very much for your assistance with this issue. I have some experience with SQL but it's not something I do on a regular basis so some of the functionality causes some confusion and joins are one of them. The main table in this query is NOTE and there is only one...
  3. cfcProgrammer

    getting mulitple records in query result???

    Hi, I have a query that I am getting multiple records in my result however, I am only expecting one per id.. I'm unsure why this is happening as there is only one record in each table per id, I just wanted to join the tables so I could access different data from each table. Could someone...
  4. cfcProgrammer

    Microsoft Excel

    Thank you thank you thank you!!!!!!!!! works perfectly... lol :) cfcProgrammer
  5. cfcProgrammer

    Microsoft Excel

    The data from the cells is not being populated into the statement "Insert into nms_mobile_id_event (SERIAL_NUM, IMSI, BILLABLE_MOBILE_ID, EVENT_TYPE_CODE, SDATE, EDATE, USER_ID, EVENT_DT) Values(=""'""&B2&""'"", ""'""&A2&""'"",""'""&C2&""'"", 'TS', TO_DATE('12/14/2009 11:13:46', 'MM/DD/YYYY...
  6. cfcProgrammer

    Microsoft Excel

    Yes you are correct I am trying to create a sql statement but all I am trying to do in this situation is take the data in A2, B2 and C2 cells and put them in the statement I have. I don't have an issue with SQL just trying to get the data from these cells into this statement at this point...
  7. cfcProgrammer

    Microsoft Excel

    Hi I am trying to create a statement using data from excel cells... Here is the statement I am trying to create... all of it is text except for the info I am requesting be replaced by the data in the cells. I have 1000 of these to run so once I get this statement created I will then copy down...
  8. cfcProgrammer

    MAX order number???

    gmmastros Thank you so much, I tried your suggestion and it works perfectly and runs much faster as well!! Thanks again Have a great Day!! [bigsmile] cfcProgrammer
  9. cfcProgrammer

    MAX order number???

    OK.. So I realized I didn't have a group by statement I have added this to the query GROUP BY ma.ARAccountCode,MA.ICCID, MA.CustomerId, IMSI,ord.ExecutionDate,MA.ID,MA.MobileType, MA.Status order by ma.ARAccountCode, MA.ICCID but I am still not getting the max order number, I'm getting...
  10. cfcProgrammer

    MAX order number???

    Hi Everyone, Thanks in advance for any help you can provide. I have a query that will bring back all the orders for a particular serial number but I only need to bring back the last order number and it's execution date. I'm not sure how to achieve this by using MAX(we do not have to use MAX...
  11. cfcProgrammer

    Openquery - Error

    Thank you so much for your help. The query is working and more importantly I understand this concept much better. I appreciate your help, thanks so much again!! [2thumbsup] C cfcProgrammer
  12. cfcProgrammer

    Openquery - Error

    I am very confused now... I am trying to gather data from two different servers and I thought I could access the oracle database from a SQL Server by the linked server STARSRO. Using openquery was allowing me to run a query using all fields from both servers. If this is not possible using...
  13. cfcProgrammer

    Openquery - Error

    I designed the query initially as below and it executes without errors however, because using this syntax the query takes off the where clause and goes out to the oracle database retrieves all the records first then when it brings back to sql server it then applies the where clause to the...
  14. cfcProgrammer

    Openquery - Error

    Hi, I am trying to run a query using open query and a linked server. Here is my query... the error I am getting is that the "FROM keyword not found where expected". select * from openquery (STARSRO,'select NMS.SERIAL_NUM, m.SerialNum as ''Serial Number'', c.ContactCompanyName as...
  15. cfcProgrammer

    Query efficiency

    Hi, I have written a query however when I execute it... the query takes a very long time, I have never let the query complete, it is definitely running over 5 mins as that is the max I allowed the query to run before I cancelled it. I'm unsure why it is taking so long and was hoping someone...
  16. cfcProgrammer

    Simple sql join query

    [smile]Thank You very much... that did the trick cfcProgrammer
  17. cfcProgrammer

    Simple sql join query

    Hi, I am new to sql query. Could someone please take a look at the below query and advise me why I am getting every record from the customer table when all I want is the customer id I have identified in the select statement. I need to have the fields identified in the main select as part of...
  18. cfcProgrammer

    Copy Textbox to multiple fields via button

    Hi I'm looking to copy from one field to another via a button using the code below. But I want the button to copy to more than one field. i.e. copy text from field1 to field2 and field3. <button onclick="document.getElementById('field2').value=document.getElementById('field1').value">Copy...
  19. cfcProgrammer

    IIS Redirect

    Hi, I am new to this environment and need a little help. Currently we have several websites within our company, an ad has gone out without the www in front of our website. The business would like to modify our IIS to allow for this. I thought this would be easy enough... I've tried it two...
  20. cfcProgrammer

    run time error '800a0009' subscript out of range

    This issue has been resolved and is considered closed. cfcProgrammer

Part and Inventory Search

Back
Top