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 ...
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

C# DataSet

I have this experience in C# that although an object is not NULL, if it's an array or a string, it doesn't mean that the length is equivalent to 0. In C# NULL and 0 length are 2 different conditions and both have to be deal with. Because of the above, I've tried to check on DataSet to see if the same would happened. I'm using Stored Procedure and Microsoft Practice Pattern Enterprise Library to get the DataSet. At first I thought that if there are no matching result, than the DataSet should be NULL instead. Then I have a hunch that might not be the case because of the experience that I mentioned above. So I do a check by having the Stored Procedure to check for a result that does not return a matching result. My guess is that although it's empty result, the DataSet will still be instantiated/created by the method. The test result proves my guess, because the DataSet is created/instantiated, and it has a 0 row count. Note that it happens with the Enterprise Li...
Read more