Jeff is correct use CURSOR for row by row processing but, remember there is a problem using curosr it will affect slower down the insertion.

so better you first validate...

Guys,

As per me programming styles consist of writing code way, commenting, query forming, readblitiy of code...

is it correct ?

Create table dbo.tmpTriggerTest

(

IDINT IDENTITY(1, 1),

Value1VARCHAR(10)

)

GO

Create table dbo.tmpTriggerTestHistory

(

IDINT,

Value1VARCHAR(10)

)

GO

Create View dbo.vw_tmpTriggerTest

AS

SELECT * FROM dbo.tmpTriggerTest

GO

Consider tat tmpTriggerTest is a table from different DB on same server.

I had created view namely vw_tmpTriggerTest which is...

sorry for d wrong reply...

Select * from of object on diff DB.

& trigger contains..... inserting record in history table, which schema is same.

Text of the view contains only...

SELECT *

FROM

Jeff Moden, A correlated subquery is a SELECT statement nested inside another T-SQL statement, which contains a reference to one or more columns in the outer query. The correlated subquery...

Writing common sp for all is always complecated caz if suppose in future any changes have to be done it will affect the other ones .

so better to maintain it...

may be u should try this....

drop table #MyParent

drop table #MyChild

create table #MyParent

( myid int identity(1,1)

, myval char(1)

)

go

create table #MyChild

( mychildid int identity(1,1)

, myid int

, mynewval char(1)

)

go

insert #MyParent select 'A'

insert #MyParent...

Change the timeout expire limit & try to alter the table schema by query

🙂

tats true returning required rows (pagewise ) is alwasy better than retuning all data rows if paging is used.

Go ahead

Can u give an example of resultset u require..

thxs John, but in output result i want only distinct col_ref [ whatever may be the order by clause colname]

there is no such parameter or value from which i know the output.

thank you lowell, for your reply. but i want to do it without creating additional functions / SP.

is it possible...

R u trying to connect to different server. if yes then first you have to link that server using " sp_addlinkedserver "