Replicate only requierd fields

Question

Replicate only requierd fields

Prakash-205770

Ten Centuries

Points: 1079
More actions
November 12, 2007 at 9:09 pm

#180176

Users Table
Userid, UserName, Sex, Age, Address
Department Table
DeptID, Dept
UserDepartment Table
Userid, Dept
For example, I want to replicate only the selected fields like (Userid, UserName, Sex, Dept) to a single table.
Is it is possible to replicate the required fields from more than one table to one
table without using View but by replicating it.
If possible, please help me. Very Urgent.
Kindest Regards,
R

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004318 More actions · Answer 1

Very urgent normally means "I'm on an interview" or "I'm taking a test" or "I have homework due tomorrow"... what's your situation 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Prakash-205770 Ten Centuries Points: 1079 More actions · Answer 2

very urgent means "I have to complete replicating fields by today".

Kindest Regards,

R

Vivien Xing SSChampion Points: 12297 More actions · Answer 3

You may use "Filter Columns" to get the columns you need from each table and join the filtered tables on the subscriber using a query/view.

Right click your publication -> Properties -> Filter Columns...

* why not view, it is so handy.