Search results for query: *

Hello all, I have been asked to modify this query and add the vendor name to it, the only problem is that when I put it into SSMS to work with it I get the error of incorrect sytntax near the keyword as and when I take out ass I get an incorrect syntax near the key word 'from' any help would...

Hello, I have a query that works for me in ssms but when I run it in Excel I get the error of "An expression of non-boolean type specified in a context where a condition is expected, near 'Location' Please help me figure out what is wrong. Declare @UserId VARCHAR(20) = NULL, @PrintId...

Hello, I am attempting to get the number of days between two dates. I have used the datediff function to do this and keep getting the "Conversion failed when converting date and/or time from character string" Error. Both fields are a datetime field and I have looked for bad data in all of the...

Hello, I am being asked to write a query that shows all unit prices where the 4th digit is greater than 0. for example a price of $29.4032 would show in the results because the 4th digit after the decimal is a 2. a price of $29.4030 would not show in the results. I have no idea of where to...

Hello, I need to update the Description Column in the Item table on my server from the Futura table. I have written the below code and it continues to fail. from what I can see it should all be good but it is not. Here is the code. UPDATE tblimItem SET [tblimItem.Description] =...

Hello, I have written the below query which works really great with the exception that it returns information from the year 2010 instead of 2015. I have tried removing everything in the where clause except the => '04/01/2015' and still get 2010 info. any ideas? Thanks, dwg23 Select distinct...

Hello, I am getting the above error from the below code and don't understand why. Can someone please enlighten me? Thanks in advance. DWG23 Select Tx.TxSource, Tx.TxType, Tx.TxDate, Tx.SourceTxReference From tblglTxHistory Tx Inner Join tblapVoucher On Tx.SourceTxReference =...

Hello, we have an old access data base that we use to keep track of build jobs and production schedules. It was written in Access 2003 and now after opening it in 2013 one of the reports is broken. when you click on the report to run it a box pops up asking you to input a Parameter Value, In...

hello, i am trying to recode an old ASP Site and am having a problem with a calculation. i am attempting to divide games played by total wins with the below code. the problem is when I dim help and do the calculation for help and then try to display the result i get the ADODB.Recordset error...

Hello all, The results in my columns is text but the text has weird information both in front of it and after it. I believe it is the formatting and font information. For example: {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Microsoft Sans...

Hello, I am trying to write a query that will show blanket orders in the system to include Item, Quantity,Remaining Quantity and a few other things. I have been able to show everything with the exception of the remaining quantity. the Sales Order Table shows the original S.O. and the type as...

I have been given the task of finding out which of our customers have not bought from us in 6 months and have no outstanding sales orders. The information is contained in two tables: customers and sales The customer number is common to both tables and I need to pull the customer number and...

Hello, I have written the below query and am stumped as to why some part numbers return a result and others don't. all have the same information in the tables the only difference is in the item numbers. item number 02fa10a gives this result. Item Location Bin QtyOnHand Qty In Fab 02FA10A...

Hello, I am writing a Query that I almost have complete but am having a problem with. When I run the below query everything runs fine and I get the results that I am looking for. but when I add , Sum(tblarInvoiceLine.Quantity) As 'Total Quan Used' to the query I get duplicate lines rather...

Hello, I have two different tables that I need to pull information from. Table One has rows like this. CustomerNumber CustomerShipTo 123 456 The only field in table two that id close to matching is called ParentReferance which has the CustomerNumber and the CustomerShipTo...

Hello, I am attempting to pull information from two different tables. one of which has the date an item was ordered. What I am trying to do is get just the Item number, schedule Id, Customer Number, customer name and the last invoice date. All of the prior are in table 1 with the exception of...

I am running the below statement and getting The following error and am not sure why. Ambiguous column name 'item'. select dci.item, dci.scheduleID, dci.customer, c.name, vw.invoicedate from tblsoDiscountCustomerItem as dci inner join tblarCustomer as c on dci.customer = c.customer JOIN...

Hello, I am attempting to modify the below query so that the rec.DateReceived shows all of the dates received, not just the "Max" date. When I remove the "Max" part I get the error of "SubQuery Returned more than 1 value. This is knot permitted when the subquery follows =, != etc... if I...

I am trying to pull information from a table based on the second character of a string. for example I have information that is listed as. MM11 MT9 FC4 FT12 I am trying to pull only information that has a T in the second position. Any ideas?

I have a Access program that pulls info from an old Novell server and populates tables in the program. Then the program goes out to a SQL Server on our website removes the information from the tables and inserts the updated info from the Access tables. The problem comes in when the program is...