Filter Table by a Historical 'Last Day of the Month'
How to create a consistent feel for character names in a fantasy setting?
Are cabin dividers used to "hide" the flex of the airplane?
Is there a way to make member function NOT callable from constructor?
Where to refill my bottle in India?
Lied on resume at previous job
What is GPS' 19 year rollover and does it present a cybersecurity issue?
Can a planet have a different gravitational pull depending on its location in orbit around its sun?
How would photo IDs work for shapeshifters?
Is there a familial term for apples and pears?
Some basic questions on halt and move in Turing machines
I’m planning on buying a laser printer but concerned about the life cycle of toner in the machine
aging parents with no investments
Re-submission of rejected manuscript without informing co-authors
Could Giant Ground Sloths have been a Good Pack Animal for the Ancient Mayans
What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?
What is the offset in a seaplane's hull?
What does "enim et" mean?
Does the average primeness of natural numbers tend to zero?
Why airport relocation isn't done gradually?
What is the command to reset a PC without deleting any files
How can I add custom success page
Unbreakable Formation vs. Cry of the Carnarium
Is every set a filtered colimit of finite sets?
Shall I use personal or official e-mail account when registering to external websites for work purpose?
Filter Table by a Historical 'Last Day of the Month'
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have a daily appending table, that I need a formula for that would filter the table results to just the last day of any given historical month. For example:
Table:
DwDate Balance
20181231 $10
20190131 $80
20190228 $75
20190331 $50
99% of the time I just need the MAX DwDate, which would be: @MaxDate = (SELECT MAX(DwDate) FROM dbo.TABLE)
However, occasionally I need a formula that would allow me to go back 1 or 2 months: @MaxDate - 2 Months
sql-server-2016 date date-math
asked 51 secs ago
Mike JonesMike Jones
454
add a comment |
I have a daily appending table, that I need a formula for that would filter the table results to just the last day of any given historical month. For example:
Table:
DwDate Balance
20181231 $10
20190131 $80
20190228 $75
20190331 $50
99% of the time I just need the MAX DwDate, which would be: @MaxDate = (SELECT MAX(DwDate) FROM dbo.TABLE)
However, occasionally I need a formula that would allow me to go back 1 or 2 months: @MaxDate - 2 Months
sql-server-2016 date date-math
asked 51 secs ago
Mike JonesMike Jones
454
add a comment |
I have a daily appending table, that I need a formula for that would filter the table results to just the last day of any given historical month. For example:
Table:
DwDate Balance
20181231 $10
20190131 $80
20190228 $75
20190331 $50
99% of the time I just need the MAX DwDate, which would be: @MaxDate = (SELECT MAX(DwDate) FROM dbo.TABLE)
However, occasionally I need a formula that would allow me to go back 1 or 2 months: @MaxDate - 2 Months
sql-server-2016 date date-math
asked 51 secs ago
Mike JonesMike Jones
454
I have a daily appending table, that I need a formula for that would filter the table results to just the last day of any given historical month. For example:
Table:
DwDate Balance
20181231 $10
20190131 $80
20190228 $75
20190331 $50
99% of the time I just need the MAX DwDate, which would be: @MaxDate = (SELECT MAX(DwDate) FROM dbo.TABLE)
However, occasionally I need a formula that would allow me to go back 1 or 2 months: @MaxDate - 2 Months
sql-server-2016 date date-math
sql-server-2016 date date-math
asked 51 secs ago
Mike JonesMike Jones
454
asked 51 secs ago
Mike JonesMike Jones
454
asked 51 secs ago
Mike JonesMike Jones
454
asked 51 secs ago
Mike JonesMike Jones
454
asked 51 secs ago
Mike JonesMike Jones
454
454
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234248%2ffilter-table-by-a-historical-last-day-of-the-month%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f234248%2ffilter-table-by-a-historical-last-day-of-the-month%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
