Search results for query: *

AlexCuse: The point of WHERE DATEPART(yy, tblActivity.EndTime) = DATEPART(yy, GETDATE()) and DATEPART(mm, tblActivity.EndTime) = DATEPART(mm, GETDATE()) and DATEPART(dd, tblActivity.EndTime) = DATEPART(dd, GETDATE()) and Is to compare the year, month, and day of the EndTime...

The problem with this is that my query when typed out requires the use of two unions to do it in one query. And since unions can not be represented graphically in MS Query I couldn't use parameters. I tried it and it threw the same error as with the stored procedure. )=

Well between should be inclusive of the end points as a control you could try to split of the between like this (PRODDTA_F4211.SDLTTR >= '620' And PRODDTA_F4211.SDLTTR <= '999') Which is essentially the same thing. If it is possible could you post what the row for '620' should look like...

The Parameters selection is greyed out so I can't select it. I checked while selecting a cell in the output and while selecting a cell outside an output with the same result.

quick question did you get rid of this: GETDATE() < tblActivity.EndTime Before adding that new code. Because that may be the problem. If not what is wrong with the output (too many records, too little) can you pin point what records were excluded/included and what were their...

Just jumping in here it looks like your problem is with your last 'OR' Change that to 'AND' and you should be good. NOTE: take out the '' Adrian

To preface my question I searched this forum up and down for about an hour to try and find the answer to this question and while I found other people asking the same thing I couldn't find the solution so any and all help is appreciated greatly. This question is for accessing a SQL server in...