Viewing 15 posts - 316 through 330 (of 1,183 total)
You are asking for an integer result by dividing and INT by an INT.
Try forcing a conversion to numeric during the calculation by adding a decimal to one of the...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 26, 2011 at 12:21 pm
I'll concede that the use of the word Guarantee was not the correct word.
But I will again state, that the purpose was to spark conversation.
My appologies to everyone who...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 25, 2011 at 3:41 pm
One more time. 🙂
Can you agree that both of these code snippets SHOULD do the exact same thing! (Delete a random set of 9 rows)
CREATE TABLE #t
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 25, 2011 at 8:27 am
SanDroid (4/25/2011)
bitbucket-25253 (4/24/2011)
Oh well, another question that does not rely on the workings of the database engine, but rather english comprehension.
I would say you comprehended just fine.
I would...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 25, 2011 at 7:50 am
wware (4/25/2011)
Wondering if anyone can think of a real world example where one might...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 25, 2011 at 7:30 am
It is a question of semantics. You are guaranteed to have ANY of those values and NONE of them at the same time. There is no guarantee, and yet there...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 25, 2011 at 7:25 am
For clarification can you post the expected results. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 22, 2011 at 11:35 am
Check the article linked in my footer and please provide DDL and sample data.
..and I agree with Dan.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 21, 2011 at 8:32 am
Jeff Moden (4/21/2011)
ChrisM@home (4/21/2011)
David Burrows (4/21/2011)
Jeff Moden (4/20/2011)
If we don't know the length, then we can force the max length for positive BIGINTs and simply remove all spaces afterwards.
Also if...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 21, 2011 at 7:12 am
Jeff's solutions works if you know the length. **a few assumptions here**
SELECT
LEFT(
STUFF(
...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 20, 2011 at 6:16 pm
polichlorek (4/20/2011)
Pages you mentioned do not exist anymore, so could you please write it? Thank you.
And just as SQLKiwi said, you might get faster results by trying your search in...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 20, 2011 at 5:41 pm
polichlorek (4/20/2011)
Pages you mentioned do not exist anymore, so could you please write it? Thank you.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 20, 2011 at 5:39 pm
Sounds like a Salesforce or forceAmp question. Have you contacted support?
http://www.forceamp.com/support.htm
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 15, 2011 at 9:42 am
Posting the same question in multiple forums is frowned upon here. 😀
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 15, 2011 at 8:58 am
Sounds like a Salesforce or forceAmp question. Have you contacted support?
http://www.forceamp.com/support.htm
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 15, 2011 at 8:56 am
Viewing 15 posts - 316 through 330 (of 1,183 total)