NVARCHAR()??? You sure you need that?

Check this out: https://support.microsoft.com/en-us/office/comparing-access-and-sql-server-data-types-9188f41d-6c0e-4733-9d20-d08916f50bd2?ui=en-us&rs=en-us&ad=us

Access Date/Time data type maps to SQL Server Date/Time data type, not DateTime2.

LOL... Part of the problem is the fact that Access uses VBA to accomplish anything complicated (transactions etc), and uses VBA to manipulate the interface etc. Separating the two might...

Wendell,

Thanks for answering! I was hoping you would.  Super handy list! I'll have to have a read and pass on the links. (Pretty sure I told the OP to post...

• This reply was modified 5 years, 7 months ago by pietlinden.

If it were me, I'd do something like this to identify all the tables containing the column I want...

SELECT ao.name AS objectName
 , ao.type_desc
 , ac.name as ColumnName
FROM sys.all_columns...

• This reply was modified 5 years, 7 months ago by pietlinden.

I just want the first record from TableB.fname returned for each of the 9 results in TableA and then move to the next record.

SELECT A.Col1, A.Col2, BTop.Col1B,...

So far so good. Could you post the expected output of the query you need?

Be brave. try it. LAG() looks at the previous record in a window (defined by the PARTITION clause) and LEAD() looks at the "next" record.

Use a numeric index on the possible values and then use NEW_ID() to generate a random number?

Huh? This HTML is messed up. Standard format for an HTML table is

<table>
 <tr>
     <td>R1C1</td>
     <td>R1C2</td>
     <td>R1C3</td>
</tr>
<tr>
     <td>R2C1</td>
  ...

• This reply was modified 5 years, 8 months ago by pietlinden.

"Pfffft! *he* wrote it??? Not reading that!!"

LOL

If a driver can NEVER drive more than one car, and you don't care about the car if it doesn't belong to that driver, then you could incorporate the Car...

"[Drivers] can technically "own" more than one vehicle personally, but they only drive one for our company really."

I would probably have one table for Drivers and one for Vehicles, and...

wait... this design is off.

Taking a step back... Can you explain the relationship between Person and Vehicle? Can one person own more than one vehicle? Can one vehicle be owned...

• This reply was modified 5 years, 8 months ago by pietlinden.

I totally missed that full outer join. =(

So you mean you're trying to UNION the two split results? Like this? the short version of union is

SELECT  f1, f2, f3
FROM t1
UNION ALL
SELECT f4,f5,f6
FROM t2;

So your...