When I execute this syntax get this error Message

Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MEDICALSTORE_Data.mdf". Operating system error 2: "2(The system cannot find the file specified.)".

MEDICALSTORE_log.ldf does not exists in tha path

This path exists in my system

I got this Error When running this syntax

File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MEDICALSTORE_log.ldf" may be incorrect.

The log cannot be rebuilt because the database was not...

Thanks for your Suggestions

its working fine

Its working only single

but I want to save using union all statement

Insert into TblExecutives(CompanyName,ExeFName,ExeLastName,Biograpy)

select [Company Name] as CompanyName, ISNULL([Executive First Name 1],'') As ExecutiveFName,

ISNULL([Executive Last Name 1],'')As ExecutiveLName,[Executive...

How can we Insert into anoher table

select [Company Name] as CompanyName,ISNULL([Executive First Name 10],'') As ExecutiveFName,

ISNULL([Executive Last Name 10],'')As ExecutiveLName,[Executive Biography 10] from CompaniesExecutives

Insert into TblExecutives(CompanyName,ExeFName,ExeLastName)values(CompanyName,ExecutiveFName,ExecutiveLName)

this...

Actually the resulte can get by using

Union all statement

from a table (its a parent table ) I want to save the result into another table

The Result not saved into table1

The result of table was get by executing some queries

When import file by default it takes nvarchar(255) then change this datatype to nvarchar(max)

then also it shows same error

When change datatype max then also get same error