Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date and Time Comparion
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...- BaneNeo
- Post #7
- Forum: Microsoft SQL Server: Programming
-
Having stored procedure output go to excel document w/ Parameters
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. )=- BaneNeo
- Post #5
- Forum: Microsoft: Office
-
MS Query criteria for no range excluding one number
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...- BaneNeo
- Post #10
- Forum: Microsoft: Office
-
Having stored procedure output go to excel document w/ Parameters
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.- BaneNeo
- Post #3
- Forum: Microsoft: Office
-
Date and Time Comparion
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...- BaneNeo
- Post #4
- Forum: Microsoft SQL Server: Programming
-
MS Query criteria for no range excluding one number
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- BaneNeo
- Post #7
- Forum: Microsoft: Office
-
Having stored procedure output go to excel document w/ Parameters
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...- BaneNeo
- Thread
- Replies: 6
- Forum: Microsoft: Office
