Hall of Fame

1. aneeshatti...207,659
2. angelIII168,309
3. rrjegan17148,901
4. acperkins145,774
5. ralmada122,320
6. RiteshShah108,193
7. chapmandew84,361
8. myrotarycar73,059
9. Sharath_...72,285
10. EugeneZ65,994
11. matthews...65,195
12. reza_rad64,404
13. mark_wills56,214
14. Bodestone53,350
15. HainKurt47,288
16. mwvisa139,284
17. CGLuttrell39,208
18. pcelba36,607
19. tigin4435,869
20. MikeWalsh30,580
21. zadeveloper28,518
22. GDG_DBA24,964
23. tickett24,800
24. sameer2...21,656
25. Thomasian20,000

1. angelIII12,962,149
2. aneeshatti...6,258,352
3. acperkins5,165,888
4. ScottPletc...4,590,513
5. chapmandew3,465,489
6. arbert2,245,195
7. Lowfatsp...2,184,250
8. EugeneZ1,998,680
9. imran_fast1,485,025
10. rafrancisco1,460,132
11. BrandonG...1,357,912
12. rrjegan171,320,538
13. mark_wills1,305,891
14. nmcdermaid1,271,761
15. matthews...1,255,004
16. Hilaire1,221,775
17. Nightman1,158,168
18. bhess11,118,487
19. Mr_Peer...1,087,815
20. ptjcb1,074,620
21. dtodd1,034,228
22. appari922,901
23. RiteshShah842,646
24. adathelad836,908
25. Sirees776,352

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.4

SQL - Sub Selects

Asked by dalewright in MS SQL Server

Tags: sql

First time i have ever had to do a nested select statement using sql and guess what? i have hit a problem. Had a look around to see if i can get any pointers, but not doing very well.. so thought i would ask the experts...

Here goes..

Have a recordset returned with xxxx of records... I want to be able to filter these records down by finding the partentID of the records, done this, with no problems. Now i want to be able to search the returned recordset that has been filtered, however, hitting one of two problems...

This is my code....

Sql = sql & "SELECT * FROM LiveView1_Page_Data WHERE p_parent_id = 219 OR p_parent_id = 228 OR "
      Sql = sql & "p_parent_id = 236 OR p_parent_id = 220 OR p_parent_id = 229 OR p_parent_id = 237 OR "
      Sql = sql & "p_parent_id = 221 OR p_parent_id = 230 OR p_parent_id = 238 OR p_parent_id = 222 OR "
      Sql = sql & "p_parent_id = 231 OR p_parent_id = 239 OR p_parent_id = 223 OR p_parent_id = 232 OR "
      Sql = sql & "p_parent_id = 240 OR p_parent_id = 224 OR p_parent_id = 233 OR p_parent_id = 241 OR "
      Sql = sql & "p_parent_id = 224 OR p_parent_id = 233 OR p_parent_id = 241 OR p_parent_id = 225 OR "
      Sql = sql & "p_parent_id = 234 OR p_parent_id = 242 OR p_parent_id = 226 OR p_parent_id = 235 OR "
      Sql = sql & "p_parent_id = 243 OR p_parent_id = 227 "
      Sql = sql & "( SELECT * FROM LiveView1_Page_Data WHERE p_title Like '%" & srchVal & "%')"

As you can see, i have all of the parentID records filtered, but i then want to be able to search those results.. So if i type..Paul, the result set will return paul... Any ideas what i am doing wrong here.?

Cheers

View the Solution FREE for 30 Days

20100315-EE-VQP-143

SQL - Sub Selects

Asked by dalewright in MS SQL Server

Tags: sql

About this solution