Search results for query: *

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

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

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

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

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

I'm getting an error "run time error '800a0009' subscript out of range", the only explanation I can see is that the array is out of range... but this doesn't seem to be the case. Can anyone help with an explanation for this by reviewing the snipet of code I've included? The line that is...

Hi, Please be patient. I am still fairly new to this world. I come from an RPG AS400 background, so this is a little different. I am trying to calculate a field from a record set that I loaded into an array(repArrRS). Here is the calculation I had originally. <%TotalSgFor = TotalSgFor +...

Hi, I have a query that is a little confusing but for the expert it may not be too bad. What I am trying to do is break down my data by fiscal year and display. I have some logic not right in my query and I've looked at it so long now that I can't seem to figure out where the issue lies...

Hi, I have been playing around with this for a little while now... can someone help me try to figure out if this is even possible and if it is... the correct syntax... I need to do a sum of a field that is defined as varchar... the field does hold a number so I am converting to numeric...

Hi, I am still fairly new to ASP so I need a little help. I need to start off by first saying that I do not agree with what I am about to ask you about. I have argued and am sure there are a million other ways for this to be coded but I have been told that this is the way it is to be done...

Hi, What I am trying to do is calculate the different types of hours per month. When I try to get the weekend hours, the result I get is the total weekend hours for all months but in each row. ??? Month Flights Day Hrs Night Partol Transit Weekend 1 22 54.00 37.80 74.02 17.75 340.06 2...

Hi, I am trying to create a report using asp/html calling a stored procedure to get the data. One of the columns needed is gathered using this sql statement. select distinct mn as "Month",s.name as "Name" from flt f join mission m on f.mseq=m.mseq join edt e on e.mseq = f.mseq join species...

Hi Everyone, I'm not sure if this is even possible to do within a sql statment but I thought I would throw it out to all of you SQL experts to see what you might come up with. What I need is report that will display how many times each employee signs on per month. Simple right??? wrong... :)...

Hi, I am calling a stored procedure from an ASP page, in the stored procedure I have to run a select statement using a union to another select statement. What I thought I could do was create a view and then just query the view and send the data back to a result set and display the data back on...

Hi all, I've looked at several posts and googled this.. but I can't seem to get this to work for me. I am calling a stored procedure from an ASP Page passing in a date. In my stored procedure I have @FromDate and @ToDate defined at varchar(10), the dates passed in will be in mm/dd/yyyy format...

Hi Could someone please help me figure out what my error is in this code. I am new to this and am unsure what it is that's causing me issues. Here is a copy of the connection code. <%@ Language=VBScript %> <% ' VI 6.0 Scripting Object Model Enabled %> <!-- #include...

Hi All, I'm having an issue with a swp file, I'm trying to modify an existing asp page. When I went into the directory which holds the source, I noticed a swp file created. I tried to open the source for the asp page and recieved a message stating that the page is newer that the swp file. I...