asked
Question content vanished?
Hello, I note question [
http://ask.sqlservercentral.com/questions/113673/how-to-use-between-and-operator-for-negative-value.html][1] has not got any content. However, manually editing the URL to go to the edit page works, and I can see the content. I note this looks very similar to an [issue we had last year][2] where the formatting was hiding question content. Could they be related? @DaveC did indicate that the initial issue had been resolved at the end of November. [1]:
http://ask.sqlservercentral.com/questions/113673/how-to-use-between-and-operator-for-negative-value.html [2]:
http://ask.sqlservercentral.com/questions/107776/is-the-new-site-formatting-hiding-question-content.html
And you have to know what the URL is to actually *get* to the edit page too, as you can't even see that option...
Dammit all, I've replaced pretty much the entire question text, and it's still barfing.
Not sure what you did, but it's now visible - and answered. Thanks @ThomasRushton
That's odd. Wasn't showing at all for me. I suspect some dodgy caching going on...
Happened again - on
https://ask.sqlservercentral.com/questions/133709/stream-aggregate-operator.html
Hmm. I'm trying to fix the question itself so we can answer it. For reference, the original text was: we had one table, one of column contains negative and positive values, how can we get required data by using BETWEEN ... AND Operator. Example: we are using below syntax, select * from FactTable where Lats between 5 and -5 (Hopefully this will survive, and not break this question!)
Well, that survived. Maybe there's a problem with the question's metadata that we can't see that's causing the question to barf. I've retyped the whole text, even tried putting it all on one line, and it still barfed.
and I tried stripping out all the text but a few words freshly typed, and it *still* failed; also, changing the tag from operator to between, and it still failed.
As indicated, it has just happened again on a different question Original question was: Just Trying to understand about this operator and it is consuming 40 percent of the cost when looking at the excution plan. Here is the replica of the query that I am using: select
Final_res.id, (select id_desc from lookup_table where id =
Final_res.id ) as Desc ( select * from (select * from (select *, rownumber as rn from table1 ) where rn=1) R1 inner join (select * from (select *, rownumber as rn from table2 ) where rn=1) R2 on
R1.id=
R2.id) Final_res Actual execution plan says there is stream aggregate on top of lookup_table (table scan) What is this operator and is there a way we can get rid of it?
and the question is back again. Caching gone wrong somewhere?
I'll dig into this and see what I can find. Sorry - been away for a bit but I'm back now.
16 People are following this question.
