Viewing 15 posts - 3,151 through 3,165 (of 3,738 total)
steve.anderson 7639 (5/13/2011)
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. ...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 9:54 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 9:50 am
Stringzz (5/13/2011)
Yes, I want to update the primary key that is a foreign key in other tables
Could you please provide the schema and dummy data?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 9:22 am
ashaaban (5/13/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 9:06 am
steve.anderson 7639 (5/13/2011)
UPDATE Purchasing
SET Purchasing.IsHardware = 1
FROM Purchasing as t1
INNER JOIN Vault_043011 as...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 8:53 am
ashaaban (5/13/2011)
and...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 8:39 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 8:28 am
The following articles may be a start:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 7:34 am
SpectralGhost (5/13/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 7:14 am
gsc_dba (5/13/2011)
Did you login/register when prompted?
I logged on and unfortunately it's not working.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 13, 2011 at 7:04 am
You may not want to drop the PK, FK's etc depending upon your situation...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 6:01 pm
Update the client table first where the FK exist and then update the Parent Table with the corresponding Primary Key or Unique Constraint.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 6:00 pm
Thank you everyone...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 5:41 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 5:35 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2011 at 5:09 pm
Viewing 15 posts - 3,151 through 3,165 (of 3,738 total)