Csdrhrt

CREATE TABLE #PickedTimes

(StartTime smalldatetime,

 EndTime smalldatetime)



INSERT INTO #PickedTimes

VALUES  ('2019-01-25 16:05', '2019-01-25 17:05'),

        ('2019-01-25 19:05', '2019-01-25 20:05')

--Each row is a time range. There would be more in the real situation, and it is desirable to define them this way.



SELECT * FROM #PickedTimes



-- No questions up to here.



SELECT TransactionID, Timestamp

FROM Transactions

WHERE Timestamp -- SOMETHING WITH #PickedTimes. How to make it pick any of the time ranges in #PickedTimes?

CREATE TABLE #PickedTimes

(StartTime smalldatetime,

 EndTime smalldatetime)



INSERT INTO #PickedTimes

VALUES  ('2019-01-25 16:05', '2019-01-25 17:05'),

        ('2019-01-25 19:05', '2019-01-25 20:05')

--Each row is a time range. There would be more in the real situation, and it is desirable to define them this way.



SELECT * FROM #PickedTimes



-- No questions up to here.



SELECT TransactionID, Timestamp

FROM Transactions

WHERE Timestamp -- SOMETHING WITH #PickedTimes. How to make it pick any of the time ranges in #PickedTimes?

CREATE TABLE #PickedTimes

(StartTime smalldatetime,

 EndTime smalldatetime)



INSERT INTO #PickedTimes

VALUES  ('2019-01-25 16:05', '2019-01-25 17:05'),

        ('2019-01-25 19:05', '2019-01-25 20:05')

--Each row is a time range. There would be more in the real situation, and it is desirable to define them this way.



SELECT * FROM #PickedTimes



-- No questions up to here.



SELECT TransactionID, Timestamp

FROM Transactions

WHERE Timestamp -- SOMETHING WITH #PickedTimes. How to make it pick any of the time ranges in #PickedTimes?

CREATE TABLE #PickedTimes

(StartTime smalldatetime,

 EndTime smalldatetime)



INSERT INTO #PickedTimes

VALUES  ('2019-01-25 16:05', '2019-01-25 17:05'),

        ('2019-01-25 19:05', '2019-01-25 20:05')

--Each row is a time range. There would be more in the real situation, and it is desirable to define them this way.



SELECT * FROM #PickedTimes



-- No questions up to here.



SELECT TransactionID, Timestamp

FROM Transactions

WHERE Timestamp -- SOMETHING WITH #PickedTimes. How to make it pick any of the time ranges in #PickedTimes?

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

active

oldest

votes

SELECT TransactionID, Timestamp

FROM Transactions INNER JOIN #PickedTimes

WHERE Transactions.Timestamp >= #PickedTimes.StartTime 

    AND Transactions.Timestamp <= #PickedTimes.EndTime

SELECT TransactionID, Timestamp

FROM Transactions INNER JOIN #PickedTimes

WHERE Transactions.Timestamp >= #PickedTimes.StartTime 

    AND Transactions.Timestamp <= #PickedTimes.EndTime

SELECT TransactionID, Timestamp

FROM Transactions INNER JOIN #PickedTimes

WHERE Transactions.Timestamp >= #PickedTimes.StartTime 

    AND Transactions.Timestamp <= #PickedTimes.EndTime

SELECT TransactionID, Timestamp

FROM Transactions INNER JOIN #PickedTimes

WHERE Transactions.Timestamp >= #PickedTimes.StartTime 

    AND Transactions.Timestamp <= #PickedTimes.EndTime

add a comment |