Questions tagged [sqlserver]

The tag has no usage guidance.

13 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6
votes
4answers
1k views

Is ETL/script the best way to create SQL database from SF?

At our organization we would like to set up a SQL copy of our Salesforce instance for two reasons: 1) the app we are using in Salesforce is shutting down (Common Ground) and we we want to keep a ...
4
votes
0answers
102 views

Is This Project Possible?

I'm setting up a Wordpress site for a new customer. They have moved their customer database from a plesk environment to a salesforce database, 13 records per row including address, id, phone number, ...
3
votes
1answer
231 views

Marketing Cloud SQL Injection?

I had a question come up that seemed a bit ridiculous at first, but has got me wondering. Is it possible to run any sort of script or SQL injection equivalency on forms that are configured to direct ...
3
votes
1answer
1k views

Hide iframe url

I am using a visualforce page and adding an apex tag: <apex:page standardController="account"> <apex:iframe src="a.com/embed/preview/f?theme=dark fullscreen" width="100%" height="800px" ...
1
vote
0answers
36 views

query gets wildly varied results on sql server vs sf of same dataset

the data is 1:1 with SF on the sql server with same named columns, yet... SELECT ID,TIER__C FROM [salesforce_stage].[dbo].[SFDC_ACCOUNT] where TIER__C NOT IN ('C1', 'E1', 'E2', 'E3', 'E4', '...
1
vote
1answer
72 views

Marketing Cloud - Replacing Multiple hardcoded values in JOINS with values from Parameter Table

Salesforce Marketing Cloud query activities do not allow variables or temporary tables according to the "SQL Support" section of this official documentation (http://help.marketingcloud.com/en/...
1
vote
1answer
93 views

Pushing data from MSSQL into Salesforce

Are there any best practices or recommendations for syncing licence data from our MSSQL database to Salesforce custom objects which are child objects of Accounts? As a SaaS app, customers can sign up ...
1
vote
1answer
36 views

Sync without the middle layer

My company has uploaded data from the middle layer(SQL database) into salesforce. This is a one time upload. Now they have terminated the middle layer. Now they would like to keep sync between the ...
0
votes
0answers
487 views

SF Marketing Cloud - Query Variable Table for value used in SQL function

Salesforce Marketing Cloud queries do not allow variables or temporary tables according to the "SQL Support" section of this official documentation (http://help.marketingcloud.com/en/documentation/...
0
votes
0answers
181 views

SQL server table not locating the respective Record ID

My SQL server administrator could establish a connection with our salesforce sandbox instance and could bulk insert brand new records. However, he couldn't update the existing records as the record ID ...
0
votes
1answer
282 views

Open rate by domain over time - SQL

I'm trying to figure out open rate over time based on domain however, it seems to error or timeout every time I run it. I've limited it to just gmail, yahoo, and AOL for now. SELECT o.domain , s....
0
votes
1answer
162 views

Oracle SQL to SFMC Date Issue

Running a query to send email subscribers a +X day email. FIRST_PROMO_SUBSCRIBE_DATE is coming from Oracle which they say is not a compatible format with Salesforce SQL so I have; select * from ...
0
votes
1answer
472 views

Ampscript or SQL to limit the number of products shown per 2 distinct fields

I have a data extension with MemberKey, Location, ProductID The same MemberKey can appear multiple times, with the same Location (but with different ProductIDs). How do I restrict each each ...