iam using 2005.can you help me on this?

All entries will be the same as sample

thanks for the help but from now i will try to help myself and find the solution and if i dont i will let you guys wht i have done...

ok that is a good reply and i guess i understand wht is your point of view i will make sure i will follow it.

thanks

i dont know why you guys created these forums if you dont want to help only bigh mouths .Any way i will get it myself you guys can only disgrace...

can you guide me how to do this i am short of time and have no time to research .appreciate your help

can you tell me wht do you exactly mean same approach for table c

i am not sure in this insert after should the select be from table a as i am doing or it should be table b

Insert into Table a

Select

b.firstname,

b,lastname

from...

can i write my query for insert and update like this do you think this approach is ok or not

Insert into Table a

Select b.firstname,b,lastname

Table a right outer join Table...

no i dont have a Drive on my local machine and that file is on my C

TITLE: Microsoft SQL Server Management Studio

------------------------------

Restore failed for Server 'test'.  (Microsoft.SqlServer.Smo)

------------------------------

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Directory lookup for the file "D:\Datafiles\testing.mdf" failed with the operating system error 21(The device is not ready.). (Microsoft.SqlServer.Smo)

i...

what is your problem do me a favour dont answer if you dont want to and dont even come  and read my post if it bothers you so much

i tried to find it over there but no luck in that too

can somebody explain me how can i do that please

no i have not done that and i dont know how to do that,that is why iam asking here how to do it