Hi Luk,

I've had a similar problem once, this was caused by a migration from SQL Server 2000 to SQL Server 2005. Assuming that this is not the case in you're...

I agree with John that the execution plan would be very informative, and that the temp table shouldn't be necessary.

Have you tried rewriting the query using an exists clause instead...

Hi,

I'm not sure if this is what you're looking for but i would imagine this SP could look something like this:

create procedure name

(

parameters

)

as

begin

declare @errorno as...

Hello Henk,

I would say that you need to make sure that:

1: The data remains unchanged after changing the data types

2: The client application keeps working with the modified database.

As for...

Hi Nic,

I'm certainly not an expert on the area of CLR, but I have used and deployed it in a production environment (not a clustered environment though) and these are...

OK, suppose table X has an FK to table project, and table Y has a FK to table X

First you copy project, and retrieve the identity value of the new...

Jeff, Thank you for correcting me, while posting my reply I suddenly remembered having this problem with identity values a while back so I thought it be worth mentioning. I...

You don't need a cursor to make this work, if you copy the project (insert into project (columns except identity column) select (columns except identity column) from project where projectID...

You could create an SP with a cursor on the table,

and for each row determine the order number as:

if parent is null, then the xorder would be the...