Navigation

    Monaca & Onsen UI
    • Register
    • Login
    • Search
    • Tags
    • Users
    • Blog
    • Playground
    1. Home
    2. Sarika_A
    S
    • Flag Profile
    • Profile
    • Following
    • Followers
    • Blocks
    • Topics
    • Posts
    • Best
    • Groups
    Save
    Saving

    Sarika_A

    @Sarika_A

    Having expertises on ETL (Clover ETL, SSIS, Pentaho, Talend), Datavisualization (SSRS, Power BI, Zeppelin,Tableau, Ab initio) and Predictive analytics with R and Azure Machine Learning.

    0
    Reputation
    1
    Posts
    526
    Profile views
    0
    Followers
    0
    Following
    Joined Last Online
    Website mindmajix.com/ssrs-training Location India Age 29

    Sarika_A Follow

    Posts made by Sarika_A

    • How to UPDATE from a SELECT in SQL Server?

      In SQL Server, it’s possible to insert into a table using a SELECT statement:

      INSERT INTO Table (col1, col2, col3)
      SELECT col1, col2, col3
      FROM other_table
      WHERE sql = 'cool’
      Is it also possible to update via a SELECT? I have a temporary table containing the values, and would like to update another table using those values. Perhaps something like this:

      UPDATE Table SET col1, col2
      SELECT col1, col2
      FROM other_table
      WHERE sql = 'cool’
      WHERE Table.id = other_table.id

      Sarika//mindmajix.com/ssis-training

      posted in Developer Corner
      S
      Sarika_A