Thanks Eirikur for your response.

But I'm greeted with the following error on executing the query you posted.

Msg 102, Level 15, State 1, Line 13

Incorrect syntax near 'b'.

The error i get...

Dear Shafat,

Thanks for your reply. But its not working.

When I add b.School_Year I get another error message that says b.School_code is because it is not contained in either an aggregate...

Thank you all for your prompt responses. I'm sorry I was not able to revert back sooner, was tied up in trying to implement the suggestion as posted by SQL...

Thank you for the suggestion. Earlier I had briefly looked at "Stairways" but did not delve deeper into it. And so far my initial experience interacting with folks here has...

Thank you for clarifying the doubts succinctly. Your lucid explanation helps in understanding a lot. I clearly understand now the reason to introduce a new Primary Key because SchoolCode was...

Thank you for answering the Q1. Now let me ask another question based on this. I have four Excel tables named BasicData, FacilityData, StaffData and StudentData. They all have SchoolCode...

I was overjoyed yesterday because the solution you gave worked for me. I'm sorry but I'm re-opening this thread again because I have the following questions.

Q1. Why have you created...

Thank you, thank you and thank you so much.

I had been struggling with this problem for over a week now when I acccidentaly stumbled on this website. Out of sheer...

thanks for the reply

sure, will do that. Do i delete the other posts elsewhere?

Sure, by the way thank you for the reply.

The script is DROP TABLE BasicData CREATE TABLE BasicData(District_name nvarchar(255), School_code nvarchar(255) NOT NULL PRIMARY KEY, School_name nvarchar(255),

Block_name nvarchar(255), Cluster_name nvarchar(255),...