steve.anderson 7639 (5/13/2011)

---

Purchasing Table:

PartNumber, PK, nchar(10)

IsHardware, bit

KitAlways, bit

ChinaPN, nchar(10)

KitChina, bit

InstallTime, int

LaborClass, int

UnitCost, nchar(10)

Cault_043011 Table:

PartNo, varchar(max)

PartDesc, varchar(max)

Revision, varchar(max)

Author, varchar(max)

Stat, varchar(max)

Config, varchar(max)

LN, varchar(max)

WT, varchar(max)

Material, varchar(max)

IsPurchased, bit

IsHardware, bit

No relationship between the tables. ...

Why do you have a separate ptp database? What is ptp and what does it do?

It is unfortunate that you can't create an application that uses GP Data and your...

Could you please provide the schema and dummy data?

ashaaban (5/13/2011)

---

Yes I want to make sure when I go to CRM and check ptp data, to be able to view the live data from the other application related to...

steve.anderson 7639 (5/13/2011)

---

I don't think the Where is being seen here. It is changing all the records.

UPDATE Purchasing

SET Purchasing.IsHardware = 1

FROM Purchasing as t1

INNER JOIN Vault_043011 as...

ashaaban (5/13/2011)

---

Just to see if I got this idea right, so at the end I will need to schedule the job that will import the data to CRM database? right?

and...

I realized that the Account I was using to download was not a member of the Administrators Group.

Usually that is not a problem but in this case it did not...

The following articles may be a start:

http://sqlserverpedia.com/blog/sql-server-bloggers/corrupting-databases-for-dummies-hex-editor-edition/

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2007/01/18/fixing-damaged-pages-using-page-restore-or-manual-inserts.aspx

SpectralGhost (5/13/2011)

---

I was also wondering what types of things you always do on your databases. Obviously things like normalization, clustered indexes, indexes, and smallest datatypes needed are almost always used,...

I logged on and unfortunately it's not working.

You may not want to drop the PK, FK's etc depending upon your situation...

Update the client table first where the FK exist and then update the Parent Table with the corresponding Primary Key or Unique Constraint.

Thank you everyone...

Perhaps I'm not using the correct terminology or stating my question correctly.

But whatever you had to do to perform the following in this environment is what I'm asking.

Thank you...

Welsh Corgi...

Thank you for your response.

I needed to know how to do the the attachment but I was trying to determine how to do a screen shot a previous members post...