do you want Education column to be updated to the same value?

can you post the table structure and some matching sample data for the other table ?

there are a lot of ways to do things without cursors, it depends on what exactly are you trying to do?

you can use the NZ function in MS access

Nz ( YourVariable, [ value_if_null ] )

or

Nz (YourVariable)

will return 0 or empty string if variable is null

Right-click on the database in SSMS object explorer, select TASKS --> IMPORT DATA ....

You wont be able to include the table in replication if you only have a unique non-null key, and not a PK.

Are you allowed to create SSIS packages using BIDS?

You could setup a Security Schema with explicit deny permissions on the tables you dont want them to access.

Give them a login/logins to access this schema.

how are you dropping it?

if by right-clicking, try dropping it in sql code

Use Master

go

Drop Database [YourDB]

go

COALESCE is the ANSI compliant way, and offers multiple alternate values if the previous one is null.

ISNULL is arguably very slightly faster

Have a look at the 'Rules of Nulls' Article on here for an explanation

http://www.sqlservercentral.com/articles/Advanced+Querying/fourrulesfornulls/1915/

I recommend the WROX Professional SQL Server 2005 - Series,

I bought all three (programming, Integration, reporting)

from Amazon for the price of one:)

while not free they are well worth it..

yes, you can use 2005 import/export wizard to point to a sql 2000 database

I'm sorry i thought you had an issue with duplicates in your table.

It is hard to work out what is happening with your query without seeing the table defs ...

here is one way, might not be the most efficent but will work

declare @Tmp as Table

(col1 char(10),col2 char(10),col3 char(10),col4 char(10)

,col5 char(10),col6 int, col7 int)

insert into

you havent declared a lot of your variables.

@mstat

@bCdCheck

@bck

@mstat

this part has an extra ')'

IF Len(@MId) > 0 AND len(@Pform)) > 0

also you should try to use more...