Questions tagged [sqlserver]
The sqlserver tag has no usage guidance.
13
questions with no upvoted or accepted answers
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 ...
