how to display some Particular months from table based on today date

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

i have one table in that table 12 months column and emp name column means
emp_ name jan feb march april,,,,,,,,,,dec

means all 12 months are there

in my query i am passing today date
my question is
1) if i pass feb-01-2014 as date
i have to display emp_name jan and feb column name

2) if i pass march-02-2014 as date
i have to display emp_name jan feb march column name

3)if i pass may-11-2014 as date
i have to display column like
emp_name jan feb march april may

please can any one give query for my requirement

Posted 11-Mar-14 1:41am

Member 10562086

Updated 11-Mar-14 1:44am

v2

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)

OriginalGriff · Answer 1 · 2014-03-11T01:53:00

Solution 1

Try

SQL

SELECT * FROM MyTable WHERE DATEDIFF(y, dateColumn, datePassed) = 0

Posted 11-Mar-14 1:53am

OriginalGriff

Comments

Member 10562086 11-Mar-14 8:10am

Conversion failed when converting date and/or time from character string. this is error i got sir
and what is that dateColumn ???? is this my months column or what sir?

OriginalGriff 11-Mar-14 8:14am

The name is meant to be a clue: it's the column that holds the date in your database that you want to check...

Stop concatenating strings to form SQL commands! Not only does it leave you wide open to SQL Injection attacks which can damage or destroy your database, it means you get conversion error like this because SQL cannot identify the date format of the data you send it. Get the date into a DateTime object in your code first, then pass that via a Parameterized query instead.

Member 10562086 11-Mar-14 8:37am

emp_name jan feb march april may june july,,,,december
sachin 5 6 6 6 7 7 5 12
dravid 6 5 7 8 4 7 8 10

declare @ShiftDate datetime='01-02-2014';

here if i pass this date i want output like
empCode jan feb (only jan feb months and empcode )
sachin 5 6
suppose if i pass date as 2-3-2014
my output like
empcode jan feb march
sachin 5 6 6

like this i have to show sir