Loundy (5/23/2013)

---

Did you physically install 4 instances (all with different names)? or did you install an instance on node A then add the instance on Node B (for both...

How can I manually fail over the node1 to node2?

THanks,

Thanks much, will try it, may have more questions coming back, thanks

so when I apply service pack, it actually will do on 4 instances, correct? Thanks much

We found out it is Unitrends the tool to backup virtual server, thanks

Thanks, I forgot to say the big picture.

This bad data is from an application that use oralce database. The data type is date in Oralce.

I am wondering how the bad...

Any sample code on internet we can take a look?

Thanks,

Thanks, that is an article in 2002, I wonder if there is newer technology in it, we really don't want to use linked server option. Thanks,

Thanks, but this is .net application we probably not going to use SSIS.

Lynn Pettis (5/14/2013)

---

I'd probably have the application do the update, but that's just me. The app could be coded such that the update needs to occur in both or...

Thanks!

Thanks much, I created the table script in the attachement. there are two tables, one is masterAddress table - is used for verifying address, the other is studentaddress table.

Now I...

but how can I get the first record of addressID? I got duplicates.

DAVNovak (5/3/2013)

---

Try:

Create Function Get_XY_Coordinates (@i_Pupil_Number int)

Returns int

Begin

Declare @iXYCoord int

SELECT @iXYCoord = sab.address_id

From sps_address_bridge sab inner join sps_stud_assignment_address saa on sab.street_number = saa.street_number

And sab.full_street_name...

Thanks, much, it is exactly like what I wrote too.

It looks like we don't need the cursor. Not sure why PLSQL uses that.