Viewing 15 posts - 316 through 330 (of 1,182 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...
April 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...
April 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
...
April 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...
April 25, 2011 at 7:50 am
wware (4/25/2011)
Wondering if anyone can think of a real world example where one might...
April 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...
April 25, 2011 at 7:25 am
For clarification can you post the expected results. 😀
April 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.
April 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...
April 21, 2011 at 7:12 am
Jeff's solutions works if you know the length. **a few assumptions here**
SELECT
LEFT(
STUFF(
...
April 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...
April 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.
April 20, 2011 at 5:39 pm
Sounds like a Salesforce or forceAmp question. Have you contacted support?
April 15, 2011 at 9:42 am
Posting the same question in multiple forums is frowned upon here. 😀
April 15, 2011 at 8:58 am
Sounds like a Salesforce or forceAmp question. Have you contacted support?
April 15, 2011 at 8:56 am
Viewing 15 posts - 316 through 330 (of 1,182 total)