i want to display a text which will be in particular date range in a table am having two different columns as from date and todate now i want to display the display text in between the dates how...

Question

0.00/5 (No votes)

See more:

i want to display a text which will be in particular date range in a table am having two different columns as from date and todate now i want to display the display text in between the dates how do i write query for this
Edit-pashad

SQL

SELECT n.noticetext ,DATEDIFF(DD,n.PeriodFrom,n.PeriodTo) from tbl_Master_NoticeBoard as n inner join tbl_Master_Employee as e on e.Cid=n.DisplayTo where e.EmployeeId='j126'

Posted 2-Apr-12 19:03pm

palaniram

Updated 2-Apr-12 20:24pm

Prasad_Kulkarni

v2

Add a Solution

Comments

Prasad_Kulkarni 3-Apr-12 1:07am

what exactly 'display text' means?? from where you've to get that text, is it from database or somewhere else..
Post some of your db structure if you can, and some more details also

palaniram 3-Apr-12 1:29am

select n.noticetext ,DATEDIFF(DD,n.PeriodFrom,n.PeriodTo) from tbl_Master_NoticeBoard as n inner join tbl_Master_Employee as e on e.Cid=n.DisplayTo where e.EmployeeId='j126'

in the above query i want to display a noticetext between periodfrom and perioidto dates

palaniram 3-Apr-12 1:31am

query is not correct plz change it ....

sravani.v 3-Apr-12 1:07am

Elaborate your question. what is your table structure or data... so that we can help you.

palaniram 3-Apr-12 1:30am

select n.noticetext ,DATEDIFF(DD,n.PeriodFrom,n.PeriodTo) from tbl_Master_NoticeBoard as n inner join tbl_Master_Employee as e on e.Cid=n.DisplayTo where e.EmployeeId='j126'

in the above query i want to display a noticetext between periodfrom and perioidto dates is the query is correct plz tell me

2 solutions

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)

Prasad_Kulkarni · Answer 1 · 2012-04-02T20:28:00

Solution 1

Hi, Try this: add @FromDate & @ToDate parameters for the date selection & follow the query.

SQL

SELECT 
noticetext ,
FROM tbl_Master_NoticeBoard 
INNER JOIN tbl_Master_Employee ON Cid = DisplayTo 
WHERE EmployeeId='j126'
AND PeriodFrom >= @FromDate AND PeriodTo <= @ToDate

Posted 2-Apr-12 20:28pm

Prasad_Kulkarni

Maciej Los · Answer 2 · 2012-04-03T08:49:00

Do you mean?

SQL

SELECT CONVERT(NVARCHAR, n.PeriodFrom & ' - ' & n.noticetext  & ' - ' & n.PeriodTo) AS [OneColumn]
FROM tbl_Master_NoticeBoard as n inner join tbl_Master_Employee as e on e.Cid=n.DisplayTo
WHERE e.EmployeeId='j126'

Result:

OneColumn<br />
2011/05/05 - Travel to Berlin - 2011/05/07