Question about SQL query WHERE statement

Question

Hello jmp expert,
       I want  query one date period data by SQL/database. the period is between A and B, but A and B need to be input by dialog box (keyboard key in).

for example, i want data between 1900-1-1 and 1901-1-1 in my database. need jmp show dialog box to me, and key in the 1900-1-1 and 1901-1-1.

do you have any idea?

thanks

pniel · Answer

tanks..

pmroz · Answer

A google search for "SQL Server between dates" reveals a wealth of helpful information

http://msdn.microsoft.com/en-us/library/bb264565(v=sql.90).aspx

http://www.databasejournal.com/features/mssql/article.php/2209321/Working-with-SQL-Server-DateTime-Variables-Part-Three---Searching-for-Particular-Date-Values-and-Ranges.htm

http://www.w3schools.com/SQl/sql_dates.asp

http://msdn.microsoft.com/en-us/library/ms187922.aspx

pniel · Answer

hi,

do you know how to build a SQL statement like this but in SQL server ??