Hi

ERWin is best.

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

The way i see is there are couple of steps involved in this.

1) Creation of the file which contains the information (i.e 100 records based on multiple joins).

-- To do...

I Agree with Ninja's decision. If the data requires to have Unique Index then we should have Unique Index. In this world anything can happen with Data Quality. So always...

Hi

Check out the below article, which will clarify all your questions with examples.

http://decipherinfosys.wordpress.com/2008/02/07/index-rebuilding-vs-index-reorganizing-in-sql-server-2005/

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

Agree with Ramesh solution. It is very simple. Never use curosors in SQL Server. They are 30% slower than normal queries.

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

if the table is small then create a new table with the distinct values and then drop the old table and rename the new table to the Old table name.

Thanks...

Hi

Check out the below links

http://www.dotnetspider.com/tutorials/

Thanks -- Vijaya Kadiyala

http://dotnetvj.blogspot.com

Thats really a good tip. This will work if you are creating a new table.

What if the table already exists, so in this case we have to use Update Statement...

Hi

Why dont you do it in single short?? The amount of data that you are delaing is very small. why do you want to do it in small chunks?? If...

Hi

Agree with Bruce, thats the right way to go.

Check out below links to start with:

http://www.dba-oracle.com/oracle_tips_oracle_v_sql_server.htm

http://www.oracle.com/technology/products/database/oracle10g/pdf/cwp_general_o10g-vs-ss2k.pdf

http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm

Thanks -- Vijaya Kadiyala

There is no way u can achieve this with script unless you add a separate column with IDENTITY as a property.

Thanks

Vijaya Kadiyala

http://dotnetvj.blogspot.com

Hi

First of all you dont need a recursive function to achive this.

Try achieveing it using loops. If you still want to go ahead with your current logic then you...

Hi,

You need to Transaction Blocks to do it. By default if run any queries in Query Window , all of them are implicit commit.

You need to follow Mahesh's code to...

HI Mahesh,

You have provided partial solution, i.e. converting rows into Columns. But his requirement is slightly different. i.e Convert a Column which contains concatenated string into multiple columns. In this...

Hi

You said you want to concatenate the columns values in each of these tables!!! To concatenate you need to join these three tables on a certain column..othewise it will result...