Questions tagged [sqlserver]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
2answers
2k views

Query Activity Failing

I have set up a data extension to capture a query and return it's results. In order to track the query, I am running it in automation studio. However, the query keeps failing. I have checked that the ...
2
votes
1answer
590 views

Store Data from Salesforce Marketing Cloud to my local SQL database server

Am new to using Marketing Cloud. I want to know if there is a possibility of storing the data from Marketing cloud campaigns and Subscriber activity, Conversion tracking data to my local SQL server? ...
2
votes
1answer
247 views

Unable to access LastViewedDate on Account object SQL [duplicate]

I am trying to get the list of last 10 accounts viewed. The code seems to be working in sandbox and workbench but when I try deploying it in production, I get the error: No such column 'LastViewedDate'...
0
votes
1answer
343 views

Exact Target SQL comma separated values within a field

We are having a field called - ‘VisitOverdueMailingList__c’ on the Account object populated with comma separated values. The field contains data in the following format (only for certain Accounts that ...
0
votes
3answers
2k views

Exact Target SQL find two values within a string

We have a value stored in a string in a table and we need to extract 2 values from it into 2 new fields. The field name is linkname and it contains a value like 'VALUE1-VALUE2-52'. We need to pull ...