My suggestion is probably more work than it's worth, but here you go:

Set up a virtual machine with XP SP 2, and install BOL on there.

The other option I can...

If you don't have a Numbers table, now's a good time to build one (it's easy). It will help with this problem.

This is a standard "string parsing" problem. ...

Steve Jones - Editor (5/20/2008)

---

sorry to be late getting back, but I think IN reads better, especially when other people will see the code. Easy to make mistakes with OR.

If...

mtassin (5/20/2008)

---

Lynn Pettis (5/20/2008)

---

I disagree with statement #2. SQL is a programming language. Yes, it is a Data Manipulation Language, but so is COBOL, FORTRAN, Pascal, Modula-2, Ada,...

I've only used two versions of SQL Server (2000 and 2005), but it does seem to keep getting better. And as I keep learning more, I find it easier...

lfmn (5/20/2008)

---

GSquared (5/20/2008)

---

If you build the string this way, you don't even have to remove a final comma.

declare @String varchar(max)

select @string = coalesce(@string + ',' + cast(ModuleID as varchar(10)),

...

I think your foreign key may be backwards.

It looks like your UserGroups table has an FK to your UserGroupsOrgs table. Does it? If so, that will block the...

I could be wrong, but I think that'll have to be dynamic SQL. Build the select command as a string and execute it.

Numeric(3,2) is any number between -9.99 and 9.99, with up to 2 digits after the decimal place. Not sure what that maps to in C#, but it's a pretty...

ybol, all things considered, you might want to submit this one to thedailywtf.com. It seems like a valid candidate to me.

Matt Miller (5/20/2008)

---

GilaMonster (5/20/2008)

---

GSquared (5/20/2008)

---

My thought was just put this logic in the proc that otherwise inserts into this table, and bypass the whole trigger and insert thing...

GilaMonster (5/20/2008)

---

GSquared (5/20/2008)

---

My thought was just put this logic in the proc that otherwise inserts into this table, and bypass the whole trigger and insert thing completely. ...

GilaMonster (5/20/2008)

---

Indeed. Is most intriguing...

Personally, I'm thinking that an instead of trigger might be a better idea, as it allows the insert to not actually be run, removing the...

As an aside, I'd not use Varchar(1) for this. Sure, it works for single-digit numbers, but it won't work for anything bigger. And, if you know before-hand that...

If you build the string this way, you don't even have to remove a final comma.

declare @String varchar(max)

select @string = coalesce(@string + ',' + cast(ModuleID as varchar(10)),

...