ya i just tried that import data and export data plz tell how to tranfer datas in database a table 1 ...

sorry

in databse 1st databes A I AM HAVING A COLUMN A

TABLE 1 SER1

...

thanks

BrainDonor,

Gazareth

it was working fine

sorry

Lynn Pettis

i understand what u said now and i am sorry i didn't response for that before thread plz tell me what...

no

Lynn Pettis plz dont think like that i just given all the table u asked about mapping and i told...

i just solved that function problem any way thanks a lot

ALTER FUNCTION [dbo].[Split1](

@delimited VARCHAR(MAX),

...

thanks when there was

memberdetail phonenumber it was ' ' means it was empty for example

SpaceId IndexNumberdatas

119176720005

12044-42126680

219841427677

22044-22592999

2322593330

319884029977

32044-45554030

41

519841910117

how to stop this empty values...

sorry for the delay

i select only

phone number

from tbl member details

select

...

the first phone number phone1 will be represented as contact id 2

the second phone number phone2 will be represented ...

sorry

Koen Verbeeck i miss typed the table

CREATE TABLE [dbo].[tblContactInf](

[ContactInfId] [int] IDENTITY(1,1) NOT NULL,

...

plz tel me what are the requirement u need from me

sorry i didn't under stand what kind of detail you are asking from me

from the above reply will tell u how iam getting values for the two table

for this i can get adinforid

here i wrote a...

insert into [dbo].[tblSpace] (MemberId, AdSpaceName, TotalBlocks, PaymentType)

SELECT

t1.MemberId,

t1BusinessName as [AdSpaceName]

...