So how do I use it in this query ?

USE MYDATABASE

INSERT INTO MY_TABLE (TYPE,START_DATE,END_DATE,RATE)

VALUES

('DBLMS','2011.03.01','2011.04.16','104');

????

sorry,result data is a little garbled because the page does not preserve formatting ...

regarding the link I mentioned,what I would like my query to display

(using the example from over there) is :

rate_id rate_start_date rate_end_date ...

Here is something very very similar :

http://stackoverflow.com/questions/5452774/hotel-booking-rates-sql-problem

I am having problem inserting datetimepicker parameters instead of the raw dates.

Also I would like , instead of the price range ,...

I have given you all the info. & data you need.

Also,I know the diff. between Access and SQL server sql...

All I am asking is how should the query go.:-)

Did you read the q. ?

You're joking .... right ???

or you can provide me with sql server version too ...

I plan to move it there anyway so ...

😀

syntax is the same.

this is basic sql ....

My SQL is a little rusty .... 🙂

uhh..forgot to tell you....I am using Access database.

Since this is used in connection to programming , the way I pass my parameters to the queery :

ADOQuery1.Parameters.ParamByName('a1').asString := lookupcombobox1.text;

etc...

SQL is the...

Basic table design is very simple. I have 2 tables ROOM_TYPES (which contain only ROOM_TYPE (string) and ROOM_PRICES (string) )

Example of the data would be (ROOM_TYPES):

//ROOM_TYPE // ROOM_DESCRIPTION//

//DBL ...