can u plz help me up to ths secession

in my store proc i am not getting correctly

EXEC [dbo].[SP_InsertGrabberDetails]

@RowColumn = '1_2|2_3|1_3',

@AdSpaceId = 1

and...

tell me up to this its enough for me than i can update that remaining column

the input...

a member is selecting space which i represent as space id

for example if two member selecting ...

the input data will be like this

EXEC [dbo].[SP_InsertGrabberDetails]

@RowColumn = '1_2|2_3|1_3',

@AdSpaceId = 1

and iam trying output in the table like this

adbid ...

from table one we are getting contacttype int value only

here iam having two table in one table the values are placed pre defined depend on that i...

bala is the sample insert data for table 2 depend upon contact type 1

i show u the output how it should come

accontid contacttype ...

thanks a lot for all guys for giving me a new idea

sorry for your inconvenience and thanks a lot for your work

i found the solution for my problem anyway thank u every one for sending our valuable time for me

i found the solution for my problem anyway thank u every one for sending our valuable time for me

for this table only i want split function

i posted the details

table1

(

FileTypeId int ,

FileIndex int,

filename varchar(20),

Extension varchar(200)

Description text

)

here iam having the 4 column

the output should be in one insert function i want to...