SQL - SELECT withi a SELECT

I was trying to re-write some of the stored procedures for one of my office project the other day to exclude certain unwanted entries. It was done in such a manner.

SELECT *
FROM [table_A]
LEFT JOIN [table_B]
ON [table_A].column_id = [table_B].column_id
WHERE [table_A].column_c NOT IN
(
SELECT [table_A].column_c
FROM [table_A]
WHERE [table_A].column_c LIKE '%something'
OR [table_A].column_c LIKE '%somethingC'
OR [table_A].column_c IN ('value_A', 'value_B', 'value_C')
)

I tested it in the SQL 2005 Manager Console, and it works fine. I tried it out as well on the actual website, and it does work as well. However, it did a significant drawback that I was not able to notice. This statement will not return anything, or throwing an exception saying "Timeout operation" when it was trying to return a large number of rows.

I can't figure out why it doesn't work when it was executed from another media, i.e. a ASP.NET C# codes, and it's really baffling. The reason why I wanted to do it as the above is because I wanted to have the code clean, and I could just simply copy & paste the sub select code to a new stored procedure. Because of this problem, I have to re-write the code again to exclude the sub select and put in extra conditions under WHERE clause.

I don't really know if it's the SQL problem or it's the .NET Framework problems because my friend told me that it was SQL, but as far as I noticed, if it's SQL problem, then it should throw "operation timeout" as well when it was executed within the SQL 2005 Manager Console, so why it doesn't?

Comments

Post a Comment

Popular posts from this blog

Yahoo! Messenger voice call & video call disabled, why?

Was trying to help my colleague to troubleshoot her laptop, where the Yahoo! Messenger voice chat & video chat are disabled even though the setup of the sound & video are all correctly configured.  Yet, it will still throw the error message "Your computer is not connected to the network", which is quite amazingly considered that the wireless network is working plus the Skype is able to make the call. After several finding on the Internet and on some help site, non of the solutions are able to solve the problem.  Then I recalled the other colleague is also using the same laptop and her Yahoo! Messenger is able to use video call & voice call.  I was guessing the whole time of what could be the possible cause that hers is working but not this one.  Then a thought came to my mind, could it be the firewall? The firewall is correctly configured, so what else inside there that is blocking the connection?  The other security software that's installed is the Trend
Read more

Sport's Injuries - Treatment for bruises

I have a knock on both my legs last Sunday during a Futsal session. I have a knock on my lower right shin, while sprain my left ankle. It is not a pleasant experience at all to have both legs injured. It is very painful and totally immobilized me. What's important right now is to get it treated. I have tried to elevate both my legs in order to not let the blood concentrated at the injured spot, plus put ice at the injured area. I have even consulted with a doctor regarding the injuries, and am thankful that there's nothing wrong with my right shin. Still, it's not healing that well because the swelling has not resided. Since I'm living alone, it will be hard for it to heal because I need to be mobilize all the time. With the help of the Internet, I'm trying to surf for information that could help to provide first-aid treatment. The following are my finding from the Internet and from family tradition treatment: Elevate the injured leg. Apply ice for about 30
Read more

Web Development: Disable, Validate, & Enable Buttons

I bounced into this problem during a Web UI development, of which I'd say it's quite a common issue. Whenever a button is clicked, ideally it would be good to disable it to avoid continuous clicking. Of course, it may not be the case in certain circumstances, i.e. loading of images, of which sometimes clicking the button again would surely making it load faster. However, in the latest development that I involved in, I need to make sure that the button as to be disabled to avoid continuous clicking that would cause some Javascript error that would cause the whole website to stop working. I've no idea why this is happening, and my only explanation should be because the execution time is short & it's AJAX, therefore the continuous clicking would cause some process not able to be executed timely and causing this issue. So after some research on the Internet, I found that in order to disable the button during a button click event that has a postback, the onclick event
Read more