Need a SQL to select the last 60 days from current date

Question

Post reply

Need a SQL to select the last 60 days from current date

purushotham.k9

SSCommitted

Points: 1992
More actions
December 16, 2009 at 8:45 am

#96362

I want to select the last 60 days transactions from current date. please help how to select?

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

steveb.

SSC-Forever

Points: 46733

December 16, 2009 at 8:47 am

#1093063

use DATEADD function

SELECT DATEADD(d,-60,GETDATE())

purushotham.k9 SSCommitted Points: 1992 More actions · Answer 2

I need to select the txs by Day wise

like

d1 d2 ------d60

p1 - - ----- -

p2 - - ------- -

The format could be same as above

steveb. SSC-Forever Points: 46733 More actions · Answer 3

That is not really clear,

you did not mention p1 d1 d2 originally so i do not know what they mean..

can you post your table definitions, sample data and your expected results?

ss-457805 SSCertifiable Points: 5872 More actions · Answer 4

as mentioned above it's not very clear what you are trying to achieve. This may help:

http://www.sqlservercentral.com/Forums/Topic825668-338-1.aspx#bm826044

blog: http://sarveshsingh.com Twitter: @sarveshsing

purushotham.k9 SSCommitted Points: 1992 More actions · Answer 5

Today is 16th Dec so i need to get the txs count day wise(i.e Oct'15 to Dec'15)

like For program1 from oct15 to Dec'15 day wise i need to display the transaction count

Oct15 Oct16 Oct17 .........................Dec'15

program1

Please let me know is that fine

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Looks like selecting 60 days of data and a pivot to boot. Am I correct?

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 7

Lynn Pettis

SSC Guru

Points: 442467

December 16, 2009 at 9:03 am

#1093095

What version of SQL Server are you using?

steveb. SSC-Forever Points: 46733 More actions · Answer 8

That shouldn't be a problem to produce those results use a SELECT with a GROUP BY and a WHERE clause with the DATEADD function.

If you would like some exact code to run, then you are going to have to provide some sample data to work from otherwise it is all guess work from our side.

have a look at this link on how to get the best responses

http://www.sqlservercentral.com/articles/Best+Practices/61537/

purushotham.k9 SSCommitted Points: 1992 More actions · Answer 9

purushotham.k9

SSCommitted

Points: 1992

December 16, 2009 at 9:04 am

#1093097

SQL server 2005

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 10

Lynn Pettis

SSC Guru

Points: 442467

December 16, 2009 at 10:41 am

#1093196

How about my other question??

purushotham.k9 SSCommitted Points: 1992 More actions · Answer 11

yes..60 days of data on day wise and i am using SQL server 2005

Rod Harten SSC-Addicted Points: 476 More actions · Answer 12

It sounds like you want transactions going back two months back and not 60 days back so that the days of the month match. i.e. 14th to 14th.

Try the below.

SELECT *

FROM table

WHERE TransactionDate >= DateAdd(m,-2,GetDate())

Jeff Moden SSC Guru Points: 1004407 More actions · Answer 13

purushotham.k9 (12/17/2009)
yes..60 days of data on day wise and i am using SQL server 2005

Please see the following... it'll do what you want. You will have to spend a bit of time training yourself on it though it does have step-by-step instructions.

http://www.sqlservercentral.com/articles/Crosstab/65048/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)