Search results for query: *

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

Ok, I am now officially an idiot! just realized that I was joining to the wrong column! Thanks for all the help, really was a good education in the datetime.

To all, I have to say an excellent education on the use of datetime, but unfortunately it did not help with the problem, still getting dates with the 2010. Olaf, the only way to make the join is with the Left(tx.TxNumber,8) this is the first 8 digits of the transaction number which...

If I use tblapVoucher.InvoiceDate as my date I get no results. Seems strange as both columns have info in them.

gmmastros, it is a datetime field. Thanks, dwg23

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