|
|
|
|
|
TestBase 3.0 1 2 3 4 5 6 7 8 9 You have the full range of date capability. You can specify a range of dates to stay between, which days of the week, the date format, and whether to age the data.
The tbt_orderdetails table contains a productid. In order to have valid orderdetails, I needed the IDs from the tbt_products table. This demonstrates retrieving data from a database. This doesn't have to be restricted to a single row of data. If more than one row is returned, you can tell it to either use the first row or simply grab a random row. Within the SQL statement, you can embed tokens to allow data to be selected based upon another column in the table. For my purposes, I didn't need them.
|
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
