To Show last seven dates from current

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

Good Morning Every One......

Can any one help me to write a stored procedure to get last seven dates from current date ...

I want to show this into a dropdown list... I havn't get any idea about this...

Sorry for bad spelling or bad grammer...

Posted 11-Jul-13 19:25pm

khursheed Alam786

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

jaideepsinh · Answer 1 · 2013-07-11T21:38:00

Solution 1

Use this query to get last 7 dates:

SQL

select
dateadd(day,datediff(day,0,getdate()),-number) as BackDate from
(
select top 7 row_number() over (order by name) as number from sysobjects
) as t

Posted 11-Jul-13 21:38pm

jaideepsinh

Comments

khursheed Alam786 12-Jul-13 7:22am

Thanks jaideep...........
plz help me one more way..i have a table with column complaintdays...that means what ever user set a value in that column so the dropdown should show that number of days...

jaideepsinh 12-Jul-13 7:46am

I don't understand what you want to do can you explain in brief.

khursheed Alam786 17-Jul-13 5:40am

Thanks jaideep...I have solved it from my own....actually I have a project called transportmanagement system in which if user want to complain about any bus driver so he should complain from current date to previous one week dates....that's why I have asked this question....thanks once again for your help.. :)

jaideepsinh 17-Jul-13 5:45am

Your welcome.Pls vote and accept as answer by the way where you from and for whom you develop this project.