Viewing 15 posts - 22,456 through 22,470 (of 26,484 total)
Oh well. Not much more we can do here then I guess.
February 13, 2009 at 4:28 pm
Couldn't the status column also be changed to be a calculated column using the same logic as that used in the view?
February 13, 2009 at 3:57 pm
Michael Valentine Jones (2/13/2009)
Roy Ernest (2/13/2009)
Michael Valentine Jones (2/13/2009)
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspx
I don't know about that. Here's a thread...
February 13, 2009 at 3:54 pm
Well, I have to bail at this point. You haven't been able to provide me with enough information to really help. No DDL for the tables and views...
February 13, 2009 at 3:51 pm
Mike Levan (2/13/2009)
I think union all is always beter than union.UNION ALL looks for and discards duplicate rows in the result set, whereas the UNION statement does not.
Actually you...
February 13, 2009 at 3:40 pm
Try this in your WHERE clause in place of what you currently have:
Cycle_Cutoff_DT > dateadd(mm, datediff(mm, 0, getdate()) - 1, -1) and
...
February 13, 2009 at 3:38 pm
I am not sure what your criteria really is here. What are you trying to return with the query? If February, you what all data for the past two...
February 13, 2009 at 3:35 pm
Here is some date manipulation code for you to play with as well:
select
getdate(),
dateadd(mm, datediff(mm, 0, getdate()), 0),
...
February 13, 2009 at 3:22 pm
george sibbald (2/13/2009)
February 13, 2009 at 3:17 pm
Okay, using the original query, change your equality statement to a less than statement, then run the query again.
February 13, 2009 at 3:12 pm
You have to tell us if it is right or wrong. Does it provide you with the results you are expecting and are those results correct?
February 13, 2009 at 3:09 pm
Mike Levan (2/13/2009)
ALTER VIEW [dbo].[Budget]
AS
Select *
from Budget_R
union all
select *
from Budget_PA
ACtually in my query vwBud and Budget are the views, you can check the view above.
What happens if you change the...
February 13, 2009 at 3:04 pm
Did you do this for me yet?
Do this: select dateadd(mm, datediff(mm, 0, getdate()), -2)
Note the return value, then do this: select Cycle_Cutoff_DT from TIPTest02
What was the results?
February 13, 2009 at 3:01 pm
Ivan b (2/13/2009)
No, column names are PersonID, PersonName, etc.
A* is criteria for searching data in Access query.
I know that I should create View, select...
February 13, 2009 at 2:56 pm
Roy Ernest (2/13/2009)
Michael Valentine Jones (2/13/2009)
Ninja's_RGR'us (2/13/2009)
... and in the "you're screwed category", the award goes to : http://www.sqlservercentral.com/Forums/Topic656268-357-1.aspx
I don't know about that. Here's a thread with links to...
February 13, 2009 at 2:49 pm
Viewing 15 posts - 22,456 through 22,470 (of 26,484 total)