Sorry, I dont know if this is documented anywhere, but I doubt it.

This seems to be a very special edge case to me.

They probably have not changed the behaviour on...

There is no problem doing what you really want.

Try this:

drop table test1

create table test1(d datetime, n int)

insert into test1 values ('99991230 23:00', 2), ('17530101', -1), ('20100101',1)

select

CASE

WHEN CAST(d as NUMERIC(38,10))...

Something like this:

select * from (

select row_number() over (order by object_id) rownum, *

from sys.objects

) dt

where rownum%5=0

I suspect that what is happening in the original select is that sql server is trying to compile the case expression, and during compilation it encounters the overflow while trying...

I dont understand what you mean.

Please be more clear.

I think the script below will solve your problem.

By the way, next if you time post CREATE TABLE and INSERT statements it will be much easier for people to help.

DROP...

You can also use

select * from sysindexes

or you can create a join with sys.allocation_units, sys.partitions, sys.indexes and sys.objects to create very detailed information about each partition.

/SG

Try adding IIDON to the clustered index, like this:

CREATE CLUSTERED INDEX [IX_t_temp] ON [dbo].[t_temp]

(

[obd] ASC,

[AID] ASC,

[LS] ASC,

IIDON

)

This might help depending on the distribution of data in the table.

/SG

It is still not really clear what you want.

Assume that in database A, table X has the following columns: c1, c2, c3 and in database B, table X has the...

Jeff Moden (4/18/2010)

---

With a bit of egg on my face (a whole omelette, actually), it would appear that IDENTITY is, in fact, the culprit and not the 3 way CROSS...

kjkeyan (4/18/2010)

---

HI,

Thanks for your suggestion ,but i have tried this query

SELECT StartTime

FROM TicketTransaction

WHERE

convert(datetime,StartTime) <= '12:30 PM'

...

Well, on my machine I...

But if you are running with FULL, SELECT INTO is fully logged, so...

What is your recovery model ?

And did you...