Recent content by dwg23

Hello everyone! got out of the hospital on Sunday and it looks like I will have some challenges, but at least my thinking seems too have cleared up some and I figured out the problem. Thanks for all the help and good wishs!

hello all, sorry i have not gotten back to you and thanks for all the help. all the suggestions have not helped and i have not gotten back as i have been at the doctor all week.found out that my headache was not a sinus infection,, it is a huge brain tumor.i am going in for in for emergency...

Olaf thanks for the help, but I am still getting an error Error executing query: declare @SPC varchar(10) select top 100 i.Item, i.Description, i.SPC, (select isnull(sum(invl.Quantity), 0) from ARInvoiceLine invl where (invl.Item = i.Item and invl.DateAdded >= '01/01/2014' and...

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

RyanEK, Removing the comments is what got me to the point I am at. although you are correct in that before I removed the comments it would error right away. I tried just calling the S/P in Excel by just using the S/P name. It asked for a value for one of the var's once I supplied that it ran...

How would I do this?

We have an Excel spread sheet setup to run query's that I write the connection is already made. This allows users to run query's against the database with no risk they will mess things up. But yes, we make the SQL Connection and then run the script. always before I would create my query in ssms...

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

WOW! Talk about can't see the trees for the forest! Dropping the single quotes worked. The values were just normal date time of when the Invoice was printed and payment received. Thanks!

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

Excellent! that seems to have done it! Thanks!

No, I need to show any price that has 4th digit value greater than 0, so if the 4th digit is 1 or greater I need to show it. If i did the anything to the right of the 3rd digit greater than 0 would not work because if the number was $29.40302 it would show in the results and I would not want...

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

Gmastros, Thanks! That did it! Thanks again, Dwg23

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