[font="Verdana"]1. Select the distint records from original table and insert them into temp table.

2. Truncate the original table and insert the al records from Temp table into original table.

3. Then...

[font="Verdana"]I guess, you might have missed some join. Post table structure and sample data.[/font]

[font="Verdana"]If possible post the table structure of both the tables.

Mahesh[/font]

[font="Verdana"]With the help of Output parameter you can fetch the results. In SP_1 declare the parameter as Output and you can get them into SP_2.

Mahesh[/font]

[font="Verdana"]Might be I have posted some wrong information, but once our DBA had asked us to make a habit of it. (It was my mistake then, that I didn't gone...

[font="Verdana"]Cross Post

http://www.sqlservercentral.com/Forums/Topic500333-8-1.aspx

Mahesh[/font]

[font="Verdana"]Yup, condition can not be placed on Drop statement.[/font]

[font="Verdana"]Post your table structure with sample data and the stuff you wants to do, so that we can try o give you the perfect solution.

Mahesh[/font]

[font="Verdana"]

As I already said, it has nothing to do with backend. Its a...

[font="Verdana"]Why do you need such duplicate values into your table? This can be done easily, but let us know the exact stuff you wants to do on a table. Coz...

[font="Verdana"]

Row_Number() is one of the new feature introduced in SQL Server 2005.

Mahesh[/font]

[font="Verdana"]

...If I was to open a TRAN within a ADO connection, and then call a Sproc within the TRAN that has its own TRAN server-side, if the Sproc's TRAN fails,...

[font="Verdana"]Try Bulk Insert as well. Syntax:

Bulk Insert {Table Name}

From {File Name with complete path}

With {Different Hints}

For more information on Bulk Insert refer BOL and the below URL as well.

http://msdn.microsoft.com/en-us/library/ms188365.aspx

Mahesh

[/font]

[font="Verdana"]Well in that case change the connection type and try. This is to just confirm where the problem is.

Mahesh[/font]

[font="Verdana"]The error is self explanory. The table count in you query is exceeded. Why and what kind of data you need in a single view from more than 260 tables?

Explain...