Thank you for help.

I studied and ran it but got an error:

Msg 325, Level 15, State 1, Line 4

Incorrect syntax near 'PIVOT'. You may need to set the compatibility level...

I think that the problem is in my code below:

.Parameters.Add(New SqlParameter("@Comments", SqlDbType.VarChar, 255)).Value = _comments

I set @comments as 255 but in SQL table is 8000

After modified registry data (delete all for SQLExpress), it works in SQL authentication mode.

Thank all of you.

You are right. Before install 2008 R2, I uninstall 2008 express version but it look like not complete uninstall.

How to complete uninstall express version?

I did the same way as you said but got an error: 233.

provider:Shared memory provider, error:0-no process is on the other end of the pipe

I knew this script but how to make the small date (earlier date) be smaller Auto_ID?

Very big table, there are 4,806,509 records

I create a function as below.

It is working but I do not think it is the best way.

create FUNCTION [dbo].[GetFirstDayOfMonth] ( @myDate DATE )

RETURNS varchar(20)

BEGIN

declare @tempdate varchar(20)

set @tempdate= convert(varchar(20),...

Yes, I want to force all data from table B to 20 char length

The problem is all records stored in old table are the length about 20 but set as 255.

Cast is working.

Thanks

Thank all of you.

How to use DDL and DML?

There is a [Member ID] column will be set as primary key.

There may have duplicate [Member ID] in A but I only need to select one.

"Could you supply DDL for your tOrder please?"

Can you teach me more how to supply DDL?