Viewing 15 posts - 451 through 465 (of 1,473 total)
William Plourde (10/28/2009)
SELECT ..
FROM loan L
JOIN Borrow B on...
October 28, 2009 at 2:20 pm
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...
October 28, 2009 at 2:15 pm
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...
October 28, 2009 at 2:00 pm
CooLDBA (10/28/2009)
There is no trigger.I figure out.
Thanks for replying.
And.... what did you figure out?
October 28, 2009 at 11:52 am
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...
October 28, 2009 at 11:38 am
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...
October 28, 2009 at 11:33 am
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.
October 28, 2009 at 11:25 am
Lowell (10/27/2009)
ahh your right...you can change to varhcar(max), and make things bigger than 8000, but only in 8000 chunk bites.
You can go over 8K if you cast the ' '...
October 27, 2009 at 9:02 am
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.
October 27, 2009 at 8:05 am
There is likely a more efficient way... but this may work:
SELECT REVERSE(LTRIM(REVERSE(yourcolumn)))
October 27, 2009 at 7:51 am
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...
October 27, 2009 at 7:44 am
Silverfox (10/26/2009)
You should try working with sage then, the tables and colums are just a jumble of the alphabet, the main reason sage consultants get paid so much 😀
I have...
October 26, 2009 at 9:17 am
What do you want to do if you have two different ItemNumbers with the highest cost for 1 item?
October 23, 2009 at 10:09 am
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...
October 23, 2009 at 8:04 am
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....
October 22, 2009 at 8:18 pm
Viewing 15 posts - 451 through 465 (of 1,473 total)