So you have already installed SQL?

Yes, I already installed SQL. The name is MYPC

You want to add a new instance of SQL called SQLEXPRESS or do you want your existing...

In ORDER1

ORDERID---DATE

111---------2/5/2012

222---------3/8/2012

333---------8/5/2012

In ORDER2

ORDERID---CITY

111----------LONDON

333----------NEW YORK

444----------PARIS

FINAL:

ORDERID---DATE------CITY

111---------2/5/2012--LONDON

222---------3/8/2012

333---------8/5/2012--NEW YORK

444---------------------PARIS

Because I do not know which way to join these two tables.

Thank you.

Sometime when I modify a very longer store procedure I want to quick back to the position of store procedure where I read.

I added line number now to go...

Thank you for help.

I did the way you are showing but it is not convenient.

Every time I need to modify it.

I did check but no luck.

I installed sp2 successfully.

Do I still need sp1? (still failed to install)

Thank you. I backup and then restore. Everything is ok.

It works great.

Thank you again

Thank you. I almost get there.

But, if I inserted more values, the duplicate result will displays.

How to fix it?

INSERT INTO dbo.PatientInfo

VALUES ('06000248','08/02/2010','08/04/2010'),

('06000248','08/10/2010','08/12/2010'),

...

Machine DSN

Link table in Access

SQL name: Order

Database: OrderYear

All users use the same account and password.

user account: sqluser,

password:user123

Thank you.

I learned your way before.

The problem is that there are about 200 rows and 30 columns in real table.

Is there another way to code it?

Thak you very much.

It works.

Since the date is controled by @CSV I deleted the following statement in @sql.

AND OrderDate BETWEEN ''' +

...

Hi Jeffem,

If I want to get sum of 12 months, how to modify your existing code?

Thank you so much.

I ran it in my local 2008 express, it works great!