Can I do this in SQL?

Question

3.67/5 (2 votes)

See more:

Check the date between 2 dates in another query?

SQL

Select * From TableName Where myDate Between (Select myFromDate,myTodate From AnotherTableName where id=3)

Posted 11-Aug-14 21:50pm

TheWebDeveloper

Add a Solution

Comments

Herman<T>.Instance 12-Aug-14 3:53am

You could have tried....
No
it is between....and.....

2 solutions

Solution 2

Hi,

Try this...

SQL

DECLARE @FrDate Datetime
DECLARE @ToDate Datetime

Select @FrDate=myFromDate, @ToDate=myTodate From AnotherTableName where id=3

Select * From TableName Where myDate Between @FrDate AND @ToDate

hope this will help you.

Cheers

Posted 11-Aug-14 21:55pm

Magic Wonder

Comments

Herman<T>.Instance 12-Aug-14 3:56am

+5

Magic Wonder 12-Aug-14 3:58am

thnx.

TheWebDeveloper 12-Aug-14 7:24am

Not what I expected

Magic Wonder 12-Aug-14 7:46am

I was not sure about your expectation.

TheWebDeveloper 13-Aug-14 4:21am

Thnx for trying anyhow

Magic Wonder 13-Aug-14 5:12am

Your welcome.

Add a Solution

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

Herman<T>.Instance · Accepted Answer · 2014-08-11T21:54:00

Solution 1

SQL

Select * From TableName Where myDate Between (Select myFromDate From AnotherTableName where id=3) and (Select myTodate From AnotherTableName where id=3)

Posted 11-Aug-14 21:54pm

Herman<T>.Instance

Comments

_Asif_ 12-Aug-14 3:56am

+5

TheWebDeveloper 12-Aug-14 3:59am

My solution too I was going to post it +5

Can I do this in SQL?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Can I do this in SQL?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us