Hi Robert, Replication is a server level configuration which requires few additional objects to be created on the source server like Publisher, Distributer,...
Hi Elan, I will be very grateful if you could explain your pint further for me.In terms of performance, what are the likely problems. Also with th new column...
Hi, I go with Michael's option. Just for one table going for Replication is not a wise thing to do. Apart from the additional column it creates there could be...
2620
Michael Weiss
mweiss@...
Nov 14, 2006 10:10 pm
Hi Robert, Take a look at this post http://www.thescripts.com/forum/thread513448.html. I am wondering why you can't use a On Insert Trigger as well as Update ...
I may have to clarify my problem again I have SQL instance called PAPS on Dell Server SV001 and another instance called SAM other Dell Server called SV002....
Hi Rowland, I have read a lot about replication and finding my way out. I however need some help. Anytime a replication is set, I hope you see that it creates...
The replication process takes care of that. Basically, it goes like this. First you create a 'snapshot' of the table to be replicated. And then the Replication...
Thanks Rowland, I have just started investigating that and I am beginning to believe that will be the best option. May i please know if you have an idea as to...
You can execute this query (revision of the one Tracey sent you). However, since there is no 'simple' way to identify the 'new' rows, this process will become...
I may have to clarify my problem again I have SQL instance called PAPS on Dell Server SV001 and another instance called SAM other Dell Server called SV002....
Robert, You can do it as follows (assuming that Table1.Field1 and Table2.Field4 are the PK on their respective tables): INSERT Table2(Field4, Field5, Field6)...
Robert, Have you investigated Replication and/or "Log Shipping" as possible solutions? Does Table1 have a datetime column for the insertion date/time? If not,...
2611
John Warner
john@...
Nov 10, 2006 7:00 pm
I'm less then clear here, is this DB2 you are talking about or what DBMS? John Warner...
Hi All, I need urgent help on this. I have two databases.I will want Table1 (Field1,Field2,Field3) in DB1 to tranfer data into Table2(Field4,Field5,Field6) in...
2609
Debbie
southfldeb@...
Nov 9, 2006 7:04 am
A made a Cheat and it works!!! Select A.recip_id ,A.firstdos AS Date_From ,b.pos_prov_type as POS , min(b.To_date_of_service) as Date_TO INTO #TAB3 from ( ...
2608
Debbie
southfldeb@...
Nov 9, 2006 3:00 am
I tried you query and these are the results returned: 123 2006-03-15 00:00:00.000 2006-03-15 00:00:00.000 ER 123 2006-03-16 00:00:00.000 2006-03-16...
Look up 'partitioning' in Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/8936789a-e803-4814-83f2-77e7 17f81736.htm - Arnie Rowland "I am a great...
Debbie, I made a change to the way the #member table is populated and that addresses your issue; here's that code: SET NOCOUNT ON DECLARE @BegDat datetime ...
... Select Max(Date), toolid From yourtable Group by toolid Stephen Russell DBA / .Net Developer Memphis TN 38115 901.246-0159 "Our scientific power has outrun...
hi folks, any help much appraciated: i have a table of tools, and one of inspections. the inspections table has individual inspection records tblinspections ...
2602
Debbie
southfldeb@...
Nov 8, 2006 7:39 am
I made a change to the member table. Notice the 2 ER visits. Your query gets the same results Mine is is getting. create table dbo.member(memberid int, begdat...
Here's the solution I came up with: First, create and populate a new table as follows: create table dbo.member(memberid int, begdat datetime, enddat datetime,...
2599
Debbie
southfldeb@...
Nov 2, 2006 4:17 pm
Use a Union joining the table to its self or even a select distinct....
I think the best solution would be as follows: INSERT Table3(primekey, table1_concat, table2_concat) SELECT Table1.primekey, x1 + y1 + z1 + p1 + q1 + r1, x2 +...
... Well this gets into the meat of programming and what rules you want to follow. 1) Make a Business Class for inventory and put all inventory code there. 2)...
