Yes, right you are, I will certainly learn the tally method for making life much easier and thank you very much.

THANK YOU FOR NICE RESPONSE. THE CODE DOES THE TRICK. BUT SOON I LIKE TO LEARN THE TALLY.

THANK YOU VERY MUCH.

First create a development environment. Attach all the database in a local machine in a single instance. Now take time and have plan for the identical keys. May be add...

use astrealerpdba

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE dbo.changemr

@counter int

...

I execute a sql query in the database and the code was like,

Select a.comcod, a.actcode, b.actdesc, a.rescode, c.resdesc, a.trnam, a.refnum, a.vounum

from actrna as a

inner join acinf as b on a.comcod=b.comcod...

Try this

use databasename

select a.Col1, a.Col2, b.Val from table2 as b

inner join table1 as a

on a.col1=b.ID

sqlsdev (6/2/2013)

---

I have two tables, lets say Table 1 and Table 2 as below

Table 1:

Col1 Col2

1 _A

2 _B

3 ...

"List of Heads" of A, B, C, D data type is nvarchar(250)

I like to insert SIRCODE in Sequence like x= x+1000

Then it look like

Comcod Sircode ...

I like to see the query as below where no duplicate party name.

COMCOD PARTY CODE PARTYNAME

3305 ...

Thank you very much it id working.

Actually I want to update by set command for multiple rows containing the ACTCODE in a sequence like (001, 002, 003 ETC) with the sample provided earlier.

Sample Data, ACTCODE...

Thank you very much I will try.

nchar