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...

You could try something like this as well:

update table1 set

    col5 = s.colsum

from

    table1 t

    inner join (

        select

            s.col1,

            s.col2,

            s.col3,

            sum(s.col4) as colsum

        from

            table1 s

        group by

           ...

Wouldn't have figured that one out from BOL, it doesn't show the round function accepting 3 parameters.  Curious where you found this info.

We are starting a Data Warehouse project, and will be using SQL Server 2005, SSIS, SSRS, and hopefully SSAS.  we are also using WSS v3 (x64) to support our development...