Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql
Search options not deleted
user 83851
Structured Query Language (SQL) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS)
0
votes
Multiple Random Selections Using Union- erroring
Instead of using ORDER BY, use the following -
ROW_NUMBER() OVER (PARTITION BY Contact_Key, c.Account_Number ORDER BY c.Account_Number ASC) AS Row
Query -
select top 31500 Contact_Key
…
- 171
0
votes
Accepted
Compare current time (hours) with time range in Transaction SQL
In order to achieve this using Queries, you will have to divide these into multiple steps as following -
Create a DE, say Test_DE and include the following fields -
Add a dummy value to the Counter …
- 171
0
votes
Create an automation without a PK
For any update operation that you perform, the DE should have a primary key in order to identify the records. If you do not have a primary key then only add & overwrite operations are possible.
Worka …
- 171
1
vote
Accepted
SQL Case Statement
Try this -
SELECT
CASE WHEN SubscriberKey IS NULL
THEN [Email ID]
ELSE SubscriberKey
END AS SubscriberKey,
[Email ID]
FROM
(SELECT
de2.SubscriberKey,
de1.[Email ID]
FROM
[TABLE1] de1
LEFT JOIN [TABL …
- 171
0
votes
Why does my conditional average query return 0 in MC Query?
Below query will give you the expected results -
SELECT ((CAST((count(case when message <> '' then 1 else NULL end)) AS DECIMAL(2,1))) / (CAST((count(event)) AS DECIMAL(2,1)))) as average, COUNT(*) as …
- 171