Re: Odd SQL IN usage?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 6 Jul 2006 22:11:44 +0000 (UTC)
@sh (spam@xxxxxxxx) writes:
Got an odd SQL string that I need to produce that is most probably
simple to construct but with it being hot in our office, I simply can't
get my head around it....!!
It must also have been hot in the office when this was desiged:
CampaignID, CampaignName, CampaignHotelIDs
1 Test Campaign 1,4,5,7,9
2 Test Campaign2 1,2
UserID, UserName, UserHotelIDAccess
1 Test User 1,6,7
2 Test User 2,7
If you are on SQL 2000, this is very painful to work with. If you are on
SQL 2005, it's slightly less painful.
Before I go, which version of SQL Server do you actually have?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Odd SQL IN usage?
- From: @sh
- Re: Odd SQL IN usage?
- References:
- Odd SQL IN usage?
- From: @sh
- Odd SQL IN usage?
- Prev by Date: Re: BEGINNER: simple Delete trigger
- Next by Date: Re: 2005: forbidding INSERTs and DELETEs
- Previous by thread: Re: Odd SQL IN usage?
- Next by thread: Re: Odd SQL IN usage?
- Index(es):
Relevant Pages
|
