Posted by Erland Sommarskog on 07/06/06 22:11

@sh (spam@spam.com) 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@sommarskog.se

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

• Next in forum: Re: 2005: forbidding INSERTs and DELETEs
• Prev in forum: Re: BEGINNER: simple Delete trigger
• Thread view: Re: Odd SQL IN usage?

[Reply to this message]