but does your check account for the second type of description, where i'm checking for the word WAV or MP3 in the following string?  'for the WAV...

Error: Invalid length parameter passed to the substring function.

Incoming ProductDescription is:

'These fully-orchestrated royalty free music tracks invoke the spirit of some of...

Interesting approach.  Let me ponder that and try it.  never thought about doing it this way.

ok, I'll also work on changing it as well to see if I can still figure this out on my own but for sure if you think you can help,...

re-looking at this, actually it's not going to give me what I want.

I think you are assuming that a description is either all WAVs or all MP3s which is not...

Thanks Adrian.

But for a description like this incoming, I don't think your check will check for the 'WAV</a>' right?

‘These  music tracks invoke the spirit<br><br><span class='product-name-no-link'>You can also purchase the...

Adrian,

Thanks a lot.  I guess I have a few qustions.

I don't understand this line:

PATINDEX('%for the WAV version of this track%',@ProductDescription) > 0

so basically I think this is saying ensure...

Jeff, why do you bother replying then.  And why do you take that so personally.  It was to help you and I get to a and b.  I was giving...

Actually it happened to be a SQL 2000 bug.  I had to drop and recreate the stored proc since it was still trying to reference an old DB ID.

Related articles:...

I think there is no problem actually after testing more.  I think that it is returning the identity of the second insert since the  Scope_Identity was placed after the second...

Yes, both tables have an identity

Users.UserID - identity column of DB1.Users table

InstantASP_Users.UserID - identity column of DB2.InstantASP_Users table

both databases are on the same server.

Refresh, i had posted the wrong code, now look at what I originally had.  I tried putting an Identity_scope right after the second insert and it still took the first.

>>>IDENT_CURRENT

I know that, I don't want this though, that's too risky.  I want only in this scope.  There could be another process that performs an insert on that table...

That's exactly what I did, but it's still taking the identity of the first insert!!!

      INSERT INTO Users (AspNetUserID, Active, CreateUserID) VALUES (@NewUserId, 1, 0)

            IF...

>>I noticed in the ID/ParentID hierarchy that the first record's ParentID = 1. Is this column nullable

I put 1 because I thought that would be better than just a null...anyway,...