Questions tagged [sqlserver]
The sqlserver tag has no usage guidance.
14
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
103 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
325 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
2k 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
38 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
123 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
187 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
37 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
1answer
20 views
Pull data from sql to salesforce
I am looking to generate reports and dashboards on Salesforce and the data reside in my SQL server.
How do pull data from SQL to Salesforce in order to create reports & dashboards in salesforce
0
votes
0answers
33 views
transact-sql seems is outdated and not anymore being supported
As soon as I opened the official resource for Transact-SQL from the link provided on the official support page (bottom links), a notice from outdated appears at the top of the Microsoft page.
This ...
0
votes
0answers
689 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
228 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
380 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
176 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 ...