Sean,

thanks for pointing out that there is not FROM clause in my statement. That solved out my issue, thanks a lot for advice.

Sincerely grateful

Fr. Ivan Delic

Serbia

I just want to say all of you who helped me out.

Regarding the NULL values I decided to fill it with blank values by simply putting this statement online

UPDATE PERSONS

SET...

You could try this (it worked for me when I installed SQL Server 2008 over my SQL Server 2005 instance and SQL Server 2005 databases - after I could not...

Thanks laurie!

There is something else but I think I could work it out. One of the problem was a thing that I didn't entered few row data, I left them...

Thanks laurie!

This is exactly what I wanted to do. Thanks a lot.

Very grateful, wishing you and yours all the best from our Lord Jesus Christ and Our Father who are...

Hi!

I forgot one thing. In paper-data there is about 30 books with 100 pages in each of them. On each page there is 10 records, so 1,000 records per book,...

Yes, you are right want I need to do.

I started to create MS Access database with those different tables knowing for normalization. My printing app need only one table as...

Thanks for the answer.

Sample data in tables are, as follows

TABLE RECORDS

ID book page number

1 1 1 1

1 1 ...

Thanks again.

Table1 is called Records, Table2 Names, Table3 Parents. They could be related by ID field which has the same value for all of them.

I was recently asked to create...

Thanks for the quick answer.

I simply want to copy my data from table2, table3 to table1.

I have about 25,000 records.

Fr. Ivan Delic

Thanks for your quick answer

I did what you asked with little change of line (I called mine SQL Server setup file SQL_Server_SP3.

Result is not good at all, and here it...

Thanks a lot for quick answer

Thanks to both of you.

I'm sorry for didn't realize that columname means SELECT FROM PersonName WHERE PersonName ...

Thanks for the answer and question Lynn

No, column names are PersonID, PersonName, etc.

A* is criteria for searching data in Access query.

I know that I should create View, select column PersonName,...

I will try to naswer to your question.

You wrote:

Thanks for the reply, but you may have missed the point of the question.

How do I get "Microsoft SQL Server Manager Studio...