Thanks for giving suggestions and for the reply.

Thank you very much!

I will be using this on a weekly basis.

I have to copy data from Server1 and replicate or upload data into Server2.

Sample:

Insert into Server2.DBName.Tablename

Select * from Server1.DBbame.TableName

Btw, How do...

Please try this one . hope this will help you.

Create table #table1 (ID nvarchar(10), point_id nvarchar(10) , point numeric(28,12))

Insert into #table1(ID,point_id,point) values ('001','P001', 5)

Insert into #table1(ID,point_id,point) values ('001','P002', 6)

Insert...

Thanks for the reply.

Only with -R,-IR, -S are obtain by the query.

but the 7 character string that start from (HTC,LGE,SAM) are missing from the result set.

Derived result from the...

Hoping this will help you. this is also my problem before.

This is what i've done with my report and it's working.

create multiple tablix and dataset in the SSRS report...

Solved.

Guys,

Anyone who have idea about my concern..need your input please.. thanks.