Thanks Jason, this should be exactly what I need!

Hi imex, thanks for your quick reply.

I just discovered I only need the latest web_survey_date for each user id, how to do that?

Is it possible to complete this within...

WITH CTE AS(

SELECT ID, Group_Name, ROW_NUMBER() OVER( PARTITION BY ID ORDER BY START_TIME) rn

FROM pivot_test)

SELECT ID, START_TIME,

...

Wow Thank you, you saved my day! I never learned SQL from any courses or anything, this forum is where I learn most of my things, thanks teacher!

haha sorry I know this will be a stupid question. How do I create the view into a specific database?

Originally I had,

CREATE VIEW aggTest as...

Then I managed to find...

Cool, this might be the solution. Two questions,

1) I followed your sql, the command executed successfully, but I can't seem to find it, where is the view stored?

2) Is it...

Then is it possible to to write an SQL that will summarize the table into what I want? (permanately turning the table into a summarized table)

Thanks for the quick reply!

I tried the 4 steps you mentioned, and the error message changed this time.

The 32-bit OLE DB Provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.

What to do...

Just tried the code you provided, still the same error.

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0; Database = C:\abc.eeee.xls', 'Select * FROM [Sheet1$]')

Same Error 🙁

I am using Excel 2010, how should the query be edited?

So..the way I am importing and updating data is correct?

Is it possible to use this statement while importing data from excel at the "Write a query to specify the data to transfer" page? (before the table is created)

SELECT...

Thank you very much, it solved my problem.

Sorry, it's the firewall of the server machine. The issue is solved now, after I identified it's firewall problem, I did a little bit of research myself, and followed the...

I have located the general direction of the problem.

I was able to connect when I turn off my firewall. So it MUST BE a firewall issue.

What should I do now?