Sergiy,

There are two things you said recently which intrigue me and which lead me to believe that you need to explain better you fascination with the Round() function.

You said:

"ROUND gets...

Mmmhhh, if, as the link says, 64 bit uses bits 0-51 for the mantissa or significand then I wonder why SQL server lets you specify float(53). I thought double precision was...

If you think that last digit is ambiguous try the following:

declare @n float(53)

set @n=0.65

select @n

set @n=0.65000000000000001

select @n

set @n=0.65000000000000002

select @n

set @n=0.65000000000000003

select @n

set @n=0.65000000000000009

select @n

This will get you:

0.65000000000000002

0.65000000000000002

0.65000000000000002

0.65000000000000002

0.65000000000000013

Very ambiguous indeed.

I think maybe...

Have been getting this error sporadically for years on a large SS2K site. Fortunately, it does not happen that often. But, in my case, it is mostly associated with something that goes through...

I agree that when you have a number in varchar format you can do BR perfectly using just string manipulation, i.e.  finally we are back to WYSIWYG.

But most of the...

And the winner is... drums rolling...

Tomm,

How about showing us that TruncTime function. I know it's easy and thus all I will do is just open up a can of worms as to how efficient or inefficient...

I guess this refers to remote SERVERS connecting to this server (not remote clients connecting to this server).

All this connection stuff where you mix 2000 with 2005 on both the...

Can you explain this 'alias' thing.

I tried to break Sugesh's suggestion, i.e. in Management Studio I right click on the instance then properties then connections then unclick 'Allow remote connections...

And keep that COLLATE phrase handy. Because for every cross-database query you write that compares, say, varchar fields you need to use it. For example, if you have a table...

Started to play around with SQL Server 2005 Express the other day.

It would be useful to know how (with what) you are trying to connect from the remote clients.

In any...

It seems to me that the approach below is what you are looking for, unless I misunderstood the problem. For the data shown, it produces

2007-06-14 18:15 15

2007-06-15 18:30 30

Thus 18:15...

I guess that being a local administrator doesn't give you everything under the sun. And in the process of digging into this, I discovered the complexity of the Windows file/folder...

You will need

1. a table of time intervals that you cross join to your data table

2. an function which, for 2 datetime interval pairs, calculates the amount of overlap

This is a great piece of writing and hits the nail on the head.

But let's get back to johnsql's real life problem. In particulare, let's take his query and see...