yes....i guess this is the best solution

IF EXISTS(SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[StringToTable]'))

DROP FUNCTION [dbo].[fnDStringToTable]

GO

--This UDF will split a delimited list into a single column table.

CREATE FUNCTION dbo.StringToTable

(

@list NVARCHAR(4000)

, @delimiter NCHAR(1) =...

thankyou ................i will try with this.................

Columns names are aa,bb,cc,dd

in the prev post

for Example.............

address phonenum ...

we dont need the table name.........just need to display the attachments to it...........

all the table names are present in another table.................

thanks...........

i need to search for data next to _ref

'hello' is not the specific name.............we have different data in place of that..............data is dynamic.............and also we have like

tblname _ref.data and

tblname.data1

we need to get data(-ref fields) and data1...

'hello' is not the specific name.............we have different data in place of that..............data is dynamic.............and also we have like

tblname _ref.data and

tblname.data1

we need to get data(-ref fields) and data1...

i am looking for data inthe columns...........data means in the column which are attached to _ref.

thanks for ur response..

i need to search for a column names which are present in a table in the below format..

tablname_ref.ColumName1

tablname_ref.ColumName2

tablname.ColumName11

tablname.ColumName22

i need to retrieve the ColumName1 from

tablname_ref.ColumName1

and...

the comparison of columns is not for particular tables.................

for every ObjectID it need to get the columns and compare...........

if we have ObjectID like 1,2,3

it loops 3 times and every...

thanks for ur reply...

we have two tables VMR AND B_VMR

B_VMR is original table

VMR is updated table

and we need to compare these two tables( not particular after every iteration tables...

if we use left join we display all records in left table.......but we need to display only new record.........

i have a bunch of tables to be compared.........all the table names are in one virtual table.............

thanks for ur response

they asked to use curser becoz it needs to check the records every time for the changes for every baselineobject...........