Viewing 15 posts - 286 through 300 (of 549 total)
Why should software (like TFS) depend on the collation of the server instance? A collation has no meaning unless used within the context of a database and starting with SS2K...
December 13, 2007 at 1:08 am
If UNION ALL is applicable use that instead of UNION.
It goes a lot faster.
December 11, 2007 at 1:11 am
Here is some VB script which you can easily adapt to ASP. Although the ADO field and file name are passed, they both expect an already existing File System Object.
If...
December 11, 2007 at 12:57 am
Jeff Moden (11/28/2007)
Heh... speaking of "details"... once done and you go to format it, you wanna use commas or periods for the thousand separators? 😀
FYI, in France they use a...
November 29, 2007 at 1:39 pm
It's not a question of T-SQL or VB. It's a question of double precision numbers(1/11/53) not being able to deal with the level of detail you need. I have no...
November 29, 2007 at 11:02 am
Max,
Your code dumps are much, much better.
It seems that you relish living in this twilight zone that sits in the world between 15 and 16 significant digits of double precision...
November 28, 2007 at 9:41 am
max (11/26/2007)
Guys, this is driving me crazy!
Your code dump is driving me crazy too.
It's incomplete.
I don't understand it at all.
Please try to be a little clearer.
Look at my...
November 26, 2007 at 11:18 am
Max,
First of all, I would be curious to know if you can finally get our answer in VB or Excel or SQL Server.
Regarding my philosophical statement on the interpretation of...
November 26, 2007 at 5:46 am
Max,
No offense. It was my idea of a bad joke.
Nevertheless, having a mantissa with all those 1 bits is still a bit unusual.
In the meantime, I also discovered a small...
November 26, 2007 at 3:21 am
Yes... I agree... in DECIMAL math, you would be absolutely correct. But FLOAT does not use Decimal math... it uses BINARY math... and there are many Decimal numbers that cannot...
November 25, 2007 at 11:31 am
Max,
I confirm your results in VB. But I also tried to 'visualize' the math operation you are trying to perform. When you ditch the scientific notation and line 'em up,...
November 24, 2007 at 1:17 am
dgvsbabu (11/21/2007)
using replicate function and u can solve it
What it this replicate function? Is this something specific to SQL Server 2005?
In any case, it is easy to solve making...
November 22, 2007 at 2:33 pm
My curiosity level is very high at this point.
What I meant is that your function is just fine. I'm adapting it to handle weekends at the moment.
November 17, 2007 at 11:26 am
I'm still curious. So here is how I got to the 1/2 output I descriped earlier - see below. And it handles those awful weekends.
What I have found though is...
November 17, 2007 at 11:03 am
Indeed, for a 1000 rows that cross join generates half a million rows and total execution time is 35 seconds dropping by only 5 seconds with a unique clustered index.
On...
November 17, 2007 at 2:23 am
Viewing 15 posts - 286 through 300 (of 549 total)