LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » Transact-SQL Programming » DML (SELECT, INSERT, UPDATE, DELETE) Questions » Querying

Querying

Options

Previous Topic · Next Topic

ynaina

Posted: Monday, September 27, 2010 6:22:56 AM

Rank: Newbie

Joined: 9/27/2010
Posts: 1
Points: 3

I have table tbl_A and tbl_B with following data

seqno amt1 amt2 amt3 total
1 10 10 20 40
2 20 10 20 40
3 30 10 20 40

tbl_B
seqno calculation
4 1+2-3

Now i want to insert a row into tbl_A with seqno 4 and row1+row2-row3(1+2-3). tbl_A is temporary table which creates columns dynamically, so we don't have fixed number of colums in tbl_A.

Please help me.

Thanks in advance

Scott Whigham

Posted: Monday, September 27, 2010 7:22:11 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 476
Points: 1,053
Where do you live?: Dallas, TX

I need help understanding what you mean when you say, "tbl_A is temporary table which creates columns dynamically, so we don't have fixed number of colums in tbl_A". Can you explain that a little more?

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.