Thanks for the response!

I have found the solution.

When the message appears you have to go to

C:\Documents and Settings\ \Application Data\Microsoft\MMC

In the MMC folder, there is a file named...

CREATE                          PROCEDURE [InsertID]

@CityID varchar(2),

@Top int

AS select CityID from table_Employees where cityid=@CityID

declare @RegionID as varchar(5)

set @RegionID = (select isnull(max(EmpID),0) from table_Employees where cityid=@CityID

if cast(@RegionID as int)=0

set @RegionID =...

Thanks for the kind replies and help!

* I had no idea about ROWCOUNT. What it's suppose to do?

After the cursor I use to "update the RegionID against the EmpID fetched...

Yes, EmpID is unique.

What is alternate for " cursor "?

Thank you dear

Thanx for the reply,

Isn't there any tool to recover the corrupted SQL Server files?

Please do reply,

I am really sorry, I just missed what I had to mention...

All the basic views include selective data and union is used to combine the three Views in 1 (That...

You can say:

/////////////////////////////////////

For Basic View1: select 1,2,3 from tbl_Main where category=1

For Basic View2: select 1,2,3 from tbl_Main where category=2

For Basic View3: select 1,2,3 from tbl_Main where category=3

For Main:

select 1,2,3 from...

Thanx for all of your kind replies, I am really happy to get the solution.

Thank you very much.

Thanx for the Suggestion Frank!

I 'll formalize my Database Design.

Regards

JAN

Thanx to all of U for the great support.

I have tried union but not working for many columns.

The idea of inserting the ID, Orders in a new table [#better] is...