question

Dave_Green avatar image
Dave_Green 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
formattingsite-admin
5 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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...
0 Likes 0 ·
Dammit all, I've replaced pretty much the entire question text, and it's still barfing.
0 Likes 0 ·
Not sure what you did, but it's now visible - and answered. Thanks @ThomasRushton
0 Likes 0 ·
That's odd. Wasn't showing at all for me. I suspect some dodgy caching going on...
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
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!)
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
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.
0 Likes 0 ·
ThomasRushton avatar image
ThomasRushton answered
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?
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

and the question is back again. Caching gone wrong somewhere?
0 Likes 0 ·
DaveC avatar image
DaveC answered
I'll dig into this and see what I can find. Sorry - been away for a bit but I'm back now.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.