Suoritettu

Write a SQL insert statement

Write a SQL statement to insert dummy records into an access 2010 database table with set values for each day of a particular month.

Let's say the month is June it will create records for every day in June from the 1st to the 30th so that my union queries display correctly since access doesn't have the ability for outer joins (I think) hence the need for dummy records.

The statement will also include a max lookup for one table which will then insert related records into a related table for the count of records in that table. So say June, 30 days, 30 records into both tables with set values.

Easy enough, I am stuck with the routine to tell it how many records to create and to change the date in one field. This is beyond my current abilities.

Thanks in Advance

Ben

Taidot: SQL

Näytä lisää: write every day, set union, june is the month for, for the month of june, write sql query parent child relation tables database, php count days mysql, aspnet forms insert sql, insert sql server xml file, programming count days, web service insert sql forms, read xml file using net insert sql server, insert sql web form, j2me count days, insert xml mssql table count

Tietoa työnantajasta:
( 40 arvostelua ) Bangkok, Thailand

Projektin tunnus: #10635718

Myönnetty käyttäjälle:

yogeshkale92

Hello We have good experience of PHP,HTML,HTML5,CSS, Ajax,jquesry,JavaScript,Mysql, Graphic Design,Website Design, wordpress, open cart , E-commerce etc. Core PHP [login to view URL] http://purvadi Lisää

$25 USD 1 päivässä
(0 Arvostelua)
0.0

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$29 USD 1 päivässä
(1 arvostelu)
1.5
$25 USD 1 päivässä
(0 arvostelua)
0.0