Excellent observation, Jonathan. thanks for passing it along. 🙂

andrew gothard (8/12/2008)

---

Well - usually in QA once it's written. Prototype in MS - then you get that sinking feeling when a colleague comes up to you baffled that...

You created it in the wrong Master schema. It has to be in the SYS schema.

Functionally, its only benefit is if you...

Glad I could help.

K. Brian Kelley (8/14/2008)

---

It's by object. You can right-click on the database and choose Tasks | Generate Scripts. When you get to the Script Options screen, you'll need to set...

I'm still trying to figure out the point of IM'ing! :w00t:

It makes about as much sense to me as getting a DSL/Cable/Fiber service and then trying to run my...

JBANKO (8/14/2008)

---

Also have wrapped raw_data with TRIM so there aren't any space issues. I'm still leaning towards the COALLATION issue because I just got off the phone with one of...

The obvious supporting views:

--====== add some views

Create View vwBookTags as

Select BookID

, TagID

, Min(Tags.Label)

, Count(UserID) as TagCount

From BookTagUsers

Join Tags ON BookTagUsers.TagID = Tags.TagID

Group...

Well, this is how I would start; The straight-forward relational way:

/*

User table, Author and Book tables and an AuthorBookLink table.

Instead of giving each book a single category,...

As Gus alluded to, this constraint...

I agree with Lowell, I know lots of ways to write a pseudo-random number generator but I am not going to bother until I understand what the real constraints are...

This should work:

Select * From (

Select A.Material, A.Maint_status,

CASE When CharIndex(Substring(A.Maint_status,1,1), B.Maint_status) > 0

Then ''

Else Substring(A.Maint_status,1,1) End

+CASE When CharIndex(Substring(A.Maint_status,2,1), B.Maint_status) > 0

Then ''

Else Substring(A.Maint_status,2,1) End

+CASE When CharIndex(Substring(A.Maint_status,3,1), B.Maint_status) > 0

Then ''

Else...

Questions:

1. Can the characters (K, C, V, D, B) be in any order in both tables?

2. should we worry about records in Table A that have no matching Material value...

I would suggest checking your master procedure.