William Plourde (10/28/2009)

---

This seems a little excessive, since all these tables pertain to a given loan id why can't it be :

SELECT ..

FROM loan L

JOIN Borrow B on...

I'd go with Lutz's suggestion.

Converting to character and back involves extra steps that don't need to be taken and tends to be slower over a large number of...

From the information provided:

SELECT [...]

FROM loan L

INNER JOIN borrower B ON B.LoanID = L.LoanID

INNER JOIN property P ON P.LoanID = L.LoanID AND P.LoanID = B.LoanID

INNER JOIN status S ON S.LoanID...

And.... what did you figure out?

I'm gonna hazard a guess here based on the normal thought process that leads to this question and guess that you're saying:

OName = 'C'

works fine, but

OName = 'C,D,E,F'

does not...

I really don't see any reason that you need the grant statement as part of the Stored procedure execution code. You can put it into a header comment so...

Have you looked into Distributed Transactions like I initially mentioned? Here's a KB article:

http://support.microsoft.com/kb/280106

If possible, you should address the actual problem, not create a convoluted work-around.

You can go over 8K if you cast the ' '...

Check the Datalength of that Lowell. I think you need to cast the ' ' inside that replicate to varchar(max) or it'll cap out at 8K.

There is likely a more efficient way... but this may work:

SELECT REVERSE(LTRIM(REVERSE(yourcolumn)))

This is going a bit out of my realm here, as I consider this more of a DBA question, but since nobody else is biting, I'll give it a shot:

A...

I have...

What do you want to do if you have two different ItemNumbers with the highest cost for 1 item?

Take a look at the values in the case statement. They're missing accents/special characters from the copy/pasting. Fix the actual values on your end and see what you...

Check out RedGate's toolset. They've got some really amazing stuff. I can't say whether or not it will perfectly suit your needs, but it's definitely worth looking at....