Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

This issue has been resolved and is considered closed. cfcProgrammer