December 2, 2008 02:01am pst

1. chapmandew 2,689,701
2. angelIII 2,178,535
3. mark_wills 736,481
4. BrandonG... 628,339
5. aneeshatti... 577,951
6. momi_sa... 452,147
7. mwvisa1 407,434
8. ee_rlee 324,111
9. acperkins 276,758
10. dtodd 276,539
11. brejk 266,994
12. EugeneZ 254,835
13. DanielWilson 252,119
14. PedroCGD 216,372
15. rickchild 212,240
16. bashka_... 188,518
17. ptjcb 180,291
18. dportas 178,392
19. dqmq 178,138
20. tedbilly 173,890
21. ScottPletc... 172,778
22. appari 169,977
23. matthews... 159,093
24. Thomasian 157,542
25. jgv 149,585

1. angelIII 3,458,726
2. chapmandew 2,689,701
3. aneeshatti... 1,143,056
4. mark_wills 736,481
5. BrandonG... 628,339
6. ptjcb 545,683
7. Yveau 539,545
8. dtodd 487,544
9. momi_sa... 453,847
10. dqmq 449,486
11. mwvisa1 407,434
12. appari 406,124
13. PFrog 404,802
14. acperkins 372,097
15. imitchie 350,938
16. ee_rlee 324,111
17. DanielWilson 317,909
18. EugeneZ 291,544
19. matthews... 288,760
20. ScottPletc... 276,445
21. brejk 266,994
22. tedbilly 242,229
23. Lowfatsp... 235,725
24. nmcdermaid 227,023
25. PedroCGD 222,372

09.06.2008 at 11:23AM PDT, ID: 23709031

	[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!

8.5

Problem with query containing IN clause

Asked by WTCarr in SQL Server 2005

Tags: Microsoft, SQL, 2005

I am having a tough time with a ms-sql 2005 query that uses an IN clause. I have a real estate database, and I want to find all homes that are in a certain high school area. I have a table of our sellers, and one field contains a comma delimted list of the high schools that comparable homes can be found in.

When I use this field in the IN clause, it returns zero records. But if I hard code in a high school, it returns the correct records.

Here is my query that doesn't work:

SELECT TOP (100) PERCENT dbo.vParagonImportAllRecords.*, dbo.Sellers.SellerID
FROM dbo.vParagonImportAllRecords CROSS JOIN
dbo.Sellers
WHERE (dbo.vParagonImportAllRecords.Status IN ('ACT', 'BC', 'RRC', 'HD', 'TA', 'CC')) AND
(dbo.vParagonImportAllRecords.ParagonHighSchoolName IN (dbo.Sellers.SellerHighSchools)) AND (dbo.Sellers.SellerID = 16)

But this does:
SELECT TOP (100) PERCENT dbo.vParagonImportAllRecords.*, dbo.Sellers.SellerID
FROM dbo.vParagonImportAllRecords CROSS JOIN
dbo.Sellers
WHERE (dbo.vParagonImportAllRecords.Status IN ('ACT', 'BC', 'RRC', 'HD', 'TA', 'CC')) AND
(dbo.vParagonImportAllRecords.ParagonHighSchoolName IN ('WREN HIGH', 'PALMETTO HIGH')) AND (dbo.Sellers.SellerID = 16)

with the only change being the hard coded high schools.

Any ideas what I'm missing....

Thanks for your help.Start Free Trial

Keywords: Problem with query containing IN clause

	Title
1	percent increase/decrease calculatio…
2	PerCent of PerCent
3	MAPI with multiple Recieptient, Cc, Bc
4	Accepting CC's
5	schooling
6	getting Views Text with where claus

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Problem with query containing IN clause

Asked by WTCarr in SQL Server 2005

Tags: Microsoft, SQL, 2005

About this solution