Best way to think about it is this: It acts like a cursor, and you have them nested, each of the 600K rows has the potential of running through all...

It would help to see the DDL for the table(s) and what you have currently tried to do to solve your problem so far.  There really isn't enough information in...

Not sure, it has been a while since I had this issue, but you may need to reinstall the client tools on the server.  I had this happen at a...

And hopefully, this is also followed immediately with a full backup.

Try this query:

select

    *

from

    dbo.tblCandidates

where

    (@Candidate = 0) or

    (ID_Kandidat = @CandidateID)

As these databases are on your development PC, the first thing I would do is change the recover mode from full to simple.  This will allow SQL Server to truncate...

Vladan,

Normally, I don't use the same table alais inside the derived table and and the derived table.  I guess I was working on autopilot when I was working on it. ...

Try this:

/*

t1 (1,2,3)

t2(3,4,5)

t3(1,7,8)

t4(3,4,9)

*/

create table dbo.t1 (

    id int

    )

create table dbo.t2 (

    id int

    )

create table dbo.t3 (

    id int

    )

create table dbo.t4 (

    id int

    )

go

insert into dbo.t1 values...

Try this:

create table dbo.RegionDesc (

    RegionId int,

    RegionDesc varchar(25)

    )

create table dbo.RegionLevel (

    Level1Region int null,

    Level2Region int null,

    Level3Region int null,

    Level4Region int null

    )

create table dbo.RegionsNamed (

    Level1Region...

Just curious, but what have you come up sp far in solving this problem?  It would help to know where you are have a problem.

You need to drop the default constraint first:

ALTER TABLE [dbo].[Invoices] DROP CONSTRAINT constraint_name

GO

ALTER TABLE [dbo].[Invoices] ALTER COLUMN [TotalFees] [money]

GO

ALTER TABLE [dbo].[Invoices] ADD CONSTRAINT constraint_name DEFAULT (0) FOR [TotalFees]

GO

Hope that helps.

Not wasting my time, just curious.  I cut and paste directly from your post to QA and it ran no problem.  There could be differences in how our systems are...

I'd need to see your code, mrpolecat.  I just tested my code in both SQL Server 2000 and SQL Server 2005, and didn't get any errors.  I have used derived...

create table bigger (

    col1 int,

    col2 decimal(10,2),

    col3 varchar(25),

    col4 datetime,

    col5 int,

    col6 int

    )

create table smaller (

    col1 int,

    col2 decimal(10,2),

    col3 varchar(25),

    col4 datetime

    )

insert into...

Rounding to the nearest even number is an accounting trick (I think it is also called a bankers round).  Accountants us it to keep numbers so that they add up...