Hi Abinash, Welcome to SSC.

Its a good start, but this is not how you post a question in an online forum. Its near impossible to understand your requirement....just by...

That is a very good tip from Jeff.....Computed Columns are not used a lot....they are even sometimes avoided in the cases they could be used....it may be due to negligence...

Bhuvnesh (11/12/2012)

---

vinu512 (11/11/2012)

---

I did get it to work for batch inserts......you can use a temp table to store the inserted values and then use a cursor to select each value...

You can use the Genereate Scripts option as shown in the following link:

Generating Scripts in sql server[/url]

This is how you can do it.

And from next time onwards post some readily consumable sample data.

This is how you post readily consumable sample data:

--Creating Table

Create Table Ex...

You don't need a Cursor to do that..............please post DDL and sample data for both the tables and precisely describe your requirement and someone may come up with a set...

Neither is better.

If your requirement is simply to compare data between two tables then you can do it as a set based operation without using a Cursor.

I would...

Yes Capn....it definitely is not a good idea to use a trigger for doing this. But, the requirement was very interesting and I just wanted to see if I could...

Sorry for the late reply Jason.

If I have understood your requirement correctly then the following sample script would do what you want.........test the script with the test cases provided...

You can run a trace using SQL Server profiler to get the execution times, but make sure you're not running the trace in the production environment.

You can also do...

Yes,...

You just want to create a text file??....What do you want to be written into it??....

You can do it as follows:

--Query for your requirement

Select boardid, companyid, companyname, countrycode, city From

(

Select b.boardid, b.companyid, a.companyname, a.countrycode, a.city ,ROW_NUMBER() Over (Partition By a.CompanyName Order by...

Yes it is possible to fetch multiple columns using cursors. You need to do a little research on Cursors.....the following link...

There is a variable being used "@t".....which is nowhere declared.....When you post example code with...