Query for getting Selected date(s) Data from the Table

Question

0.00/5 (No votes)

See more:

SQL-server-2000

Hai all,

I need to filter my table with respect to a date column, where i only need the selected date(s) Row(s) from it...

I need a selectQuery statement for this...

How can i do this..?

please help me...

Posted 25-Jul-11 0:00am

version_2.0

Add a Solution

2 solutions

Solution 1

hey! So what's problem you are facing you can use appropriate clause to fetch out the result.
use given syntax

SQL

SELECT column_name(s)
FROM table_name
WHERE column_name operator value

or If I am getting any thing wrong so please fell free to revert back with your table structure and your requirement in details.

Posted 25-Jul-11 0:07am

RaviRanjanKr

Comments

version_2.0 25-Jul-11 6:22am

see what i dont need is

Select Column_name,date_Column_name,column_name(s) from table_name
where date_Column_name BETWEEN 1st value AND 2nd value

I only need the selected dates rows from the table...

I Dont need any range of data need selected data only..

How can i do this...

RaviRanjanKr 25-Jul-11 6:44am

Still I am not getting your Question. if you wanna to select Dates rows based on selected values then you need to use any appropriate Clause.
as
select date_Column_name from table_name where date_Column_name ='Dates Values'.
hey! I need more Information about your question. be more clear and specific while asking question.
If possible provide some Table Structure with your requirement.

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)

*dan!sh* · Accepted Answer · 2011-07-25T00:43:00

Solution 2

You can make use of "in" here

select [ColumnNames] from [TableName] where [FilterColumnName] in ([FilterValues])

Posted 25-Jul-11 0:43am

dan!sh

Comments

version_2.0 25-Jul-11 6:49am

thanks...