Skip to content

Instantly share code, notes, and snippets.

@cdeutsch

cdeutsch/gist:e7da9a1fea4e69cb345f

Created May 29, 2014 23:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save cdeutsch/e7da9a1fea4e69cb345f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save cdeutsch/e7da9a1fea4e69cb345f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
-- TRUNCATE TABLE xam_SFDC_Accounts
INSERT INTO STOREREPLICA.StoreReplica.dbo.xam_SFDC_Accounts
SELECT *
FROM OPENQUERY(DBAMP, 'SELECT Id, Name, OwnerId, Owner.Name, Website FROM Account')
SELECT *
FROM STOREREPLICA.StoreReplica.dbo.xam_SFDC_Accounts
@bryanhelms
Copy link
Copy Markdown

bryanhelms commented May 29, 2014 

-- TRUNCATE TABLE xam_SFDC_Accounts

INSERT INTO STOREREPLICA.StoreReplica.dbo.xam_SFDC_Accounts
SELECT  Id, Name, OwnerId, Owner_Name, LEFT(Website, 100) AS Website
FROM OPENQUERY(SALESFORCE, 'SELECT Id, Name, OwnerId, Owner.Name, Website FROM Account') 


SELECT *
FROM STOREREPLICA.StoreReplica.dbo.xam_SFDC_Accounts

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment