Forum Replies Created

Viewing 7 posts - 16 through 22 (of 22 total)

  • RE: PowerShell - Get Permissions

    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

    +...

  • RE: SQL Server T-SQL - Merge

    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...

  • RE: SQL Server T-SQL - Merge

    .

  • RE: SQL Server T-SQL - Merge

    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...

  • RE: SQL Server T-SQL - Merge

    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] =...

  • RE: SQL Server T-SQL - Merge

    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...

  • RE: SQL Server T-SQL - Merge

    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...

Viewing 7 posts - 16 through 22 (of 22 total)