Do you mean drop the table or delete the data within it?

To delete the data try:-

truncate table

Regards,

Andy Jones

You could add another datetime field to your existing table for the end date of the range and put the start date of the range into the existing datetime column.

Regards,

Andy...

What is happening in the block? Can you post the code.

Regards,

Andy Jones

Checking the destinations, are the insert(s) actually taking place?

How are you checking for null? See the following article to see if it is behaving as you are expecting.

http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp

Regards,

Andy...

Does anything happen in the ELSE block?

Regards,

Andy Jones

Hi, I think Greg's link in the above post will help.

Regards,

Andy Jones

You have 9 stored procedure parameters but only 8 in ADO your parameters collection, I think you are missing a parameter corresponding to @strType.

Regards,

Andy Jones

Hi, you could use: -

use db1

insert table1

(

layer_id

,table_name

)

select

layer_id

, table_name

from db2.owner.table2

where layer_id not in

(

select

layer_id

from

table1

)

Alternatively you could use a 'not exists' instead of a 'not in'

Regards,

Andy Jones

What is it you want to achieve? If the primary key exists do you want to not do anything, insert the record with a different primary key, delete the orignal...

Maybe try re-starting it?? I had problems with populating full-text catalogs which were solved by simply re-starting the full text service.

Regards,

Andy Jones

Is the Sql Server Agent service running?

Regards,

Andy Jones

Have you tried attaching the datafiles to the server?

Regards,

Andy Jones

No, but you can use user-defined datatypes.

Regards,

Andy Jones

Does month period correspond to 12 months integers 1 to 12? If so: -

select

cp_Name

,sum(case MonthPeriod when 1 then Headroom else 0 end) as MonthPeriod1

,sum(case MonthPeriod when 2 then Headroom...

I like default parameters to specify default behaviour. If a default value needs to change (customer requirement etc..) this change only has to be made in one place, whereas if...