http://www.sqlservercentral.com/Forums/Topic787180-148-1.aspx

refer this

probably u may expect a query like as following

insert into table2(col1,col2) select col1,col2 from table1 where condition

hi

Given information is not enough to provide answer.. can u pls explain your issue with sample?

s jeff.. i realized that.. i made it in presentation layer

Hi

I am using Sql server 2k5 Express edition. is it possible there?

thanks a lot!!!!!!!

same doubt i had few days ago... people suggested me to check cursor_status to close and deallocate the cursor..

ok thanks a lot chris....

try this

SELECT MAX( RowNumber ) FROM

(

SELECT

ROW_NUMBER() OVER (ORDER BY MSG_DTM_LASTSTATUSTIME DESC) as RowNumber

FROM

Message_MSG msg with(nolock)

) A

but i have 20 columns in table1...Should i add 20 columns in table2 too?

thanks Chris... still i have a doubt.. i explained that in following code. i changed tables added columns in fact...

if object_id('tempdb..#table1') IS NOT NULL DROP TABLE #table1;

if object_id('tempdb..#table2') IS...

any idea ?... cursor inevitable?....

Thanks a lot for valuable ideas.. but what i am trying to do is

just like the following code...

from the select statement few values wil be inserted in one table and...

Chris.. the links in ur signature u want me to check out?

create table #table1 (col1 int,col2 varchar(30))

insert into #table1 values (1,'martin')

insert into #table1 values (2,'tom')

insert into #table1 values (3,'schrof')

create table #table2(t_col1 int identity(1,1),t_col2 int)

create table #table3 (f_col1 int identity(1,1),f_col2 varchar(30),f_col3 int)

insert...