Viewing 15 posts - 22,456 through 22,470 (of 26,490 total)
Ivan b (2/15/2009)
Thanks to both of you.I'm sorry for didn't realize that columname means SELECT FROM PersonName WHERE PersonName ...
Well, how do we go from here:
I made some applications in...
February 15, 2009 at 1:01 pm
Jeff Moden (2/14/2009)
Lynn Pettis (2/13/2009)
February 14, 2009 at 8:51 pm
Jeff, I'm not sure if you are right or wrong still. I ran the following and everything ran fine. Can you suggest any other tests I may want...
February 13, 2009 at 9:09 pm
Jeff Moden (2/13/2009)
arun.sas (2/13/2009)
Thanks Lynn Pettisbut if i create the #temp with SLNO identity,then the clustered index realy needed?
ARUN SAS
Absolutely. And, since you can't use an index by name...
February 13, 2009 at 9:05 pm
Lowell (2/13/2009)
you can add a trigger on the VIEW to handle the status column....
rename the original table.
--add a view that has the old table...
February 13, 2009 at 5:52 pm
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
Viewing 15 posts - 22,456 through 22,470 (of 26,490 total)