Viewing 7 posts - 16 through 22 (of 22 total)
Hello,
Thanks for the reply. This is the error I get once I execute the script in powershell:
Get-ChildItem : Cannot find path 'C:\Users\System.Data.DataRow' because it does not exist.
At C:\Users\Get-Permissions.ps1:18 char:28
+...
May 21, 2012 at 7:55 am
Hi,
So you cannot INSERT into a different table to the target?
EDIT: Does anyone know why this code still is not working?
There is no actuall error on the code...
August 5, 2011 at 5:01 am
Hello,
OK I have added the schema in bold still no luck. This is just making all my code error. when before it was just the last update statement.
MERGE tblInstances...
August 5, 2011 at 4:17 am
Hello,
My schema is .dbo. Your solution below did not work. Any other suggestions?
MERGE tblInstances AS TARGET
USING tblInstanceImport AS Source
ON (Target.InstanceName= Source.InstanceName)
WHEN MATCHED THEN
UPDATE
SET tblInstances.dbo.[Home] = Source.dbo.[Home]
,tblInstances.dbo.[Version] = Source.dbo.[Version]
,tblInstances.dbo.[DateCollected] =...
August 5, 2011 at 3:46 am
Hello,
This failed to work. Any other suggestions?
MERGE tblInstances AS TARGET
USING tblInstanceImport AS Source
ON (Target.InstanceName= Source.InstanceName)
WHEN MATCHED THEN
UPDATE
SET [Home] = Source.[Home]
,[Version] = Source.[Version]
,[DateCollected] = GetDate()
WHEN NOT MATCHED BY TARGET THEN
UPDATE
SET...
August 5, 2011 at 3:27 am
Hello,
Thank you for your quick response but unfortunately this has not worked, I am still getting the same error 'The multi-part identifier could not be bound'.
MERGE tblInstances AS TARGET
USING...
August 5, 2011 at 3:17 am
Viewing 7 posts - 16 through 22 (of 22 total)