I guess the good thing about using views is that they are always up-to-date. You can just grab the data out of their database whenever you want (subject to load...

If the data that is coming out of the examination system contains rubbish as a result of bad design, that should not be your problem. You will end up building...

This sounds like a reply - but to what message?

Great - I like stories with happy endings

Create a table that contains just numbers - 0, 1, 2, 3, ..., 1000 say.

Then do a CROSS JOIN to this table from your label data source, where newtable.num < number of...

Like this? I don't know SQLLite.

select datepart(dw, getdate())

You are correct in stating that the first piece of SQL identifies all the latest owners and their assets, but by performing a self join back to the orig table...

Not strange really. MS Access is a database, a development environment, an end-user environment  ... it tries to do pretty much everything.

SQL Server is a pure database environment - it...

No problem!

Something like this ... ?

select myTable.ID, myTable.AssetID, myTable.UserID, myTable.DateUpdated

from myTable join (select t2.assetID, max(t2.dateupdated) from myTable t2 group by t2.assetid) t3 on myTable.AssetID = t3.AssetID and myTable.DateUpdated = t3.DateUpdated

where...

OK - that's Analysis Services, not straight T-SQL. Analysis Services is one of Microsoft's business intelligence tools (design of OLAP cubes etc). It is complementary to SQL.

VBA functions do not work directly within chunks of T-SQL, as far as I know. Please post the quote from BOL that says they do.

This works for periods less than 1 day.

declare @secs float

set @secs = 15000

select convert(char(8), cast(@secs / 86400 as datetime), 8)

No, nothing like INSERT UNIQUE - your query is fine.

Do you have a backup of the database anywhere?

If not, you are in trouble.