Viewing 15 posts - 16 through 30 (of 2,777 total)
Do you have a trigger on the relevant columns that writes the change info somewhere, or how are you collecting the change information? Awful thin on details.
April 16, 2020 at 4:44 am
unless you have some way to order them in insertion order, you can't. You'd need a column that's either an incrementing identity column or a datetime field with a default...
April 14, 2020 at 9:04 pm
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.
April 14, 2020 at 8:38 am
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...
April 14, 2020 at 12:23 am
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...
April 14, 2020 at 12:21 am
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 ColumnNameFROM sys.all_columns...
April 13, 2020 at 6:02 pm
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,...
April 11, 2020 at 7:51 pm
So far so good. Could you post the expected output of the query you need?
April 10, 2020 at 11:39 pm
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.
April 10, 2020 at 10:58 pm
Use a numeric index on the possible values and then use NEW_ID() to generate a random number?
April 6, 2020 at 5:19 pm
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> ...
April 4, 2020 at 1:15 am
"Pfffft! *he* wrote it??? Not reading that!!"
April 4, 2020 at 12:55 am
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...
April 3, 2020 at 8:35 pm
"[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...
April 3, 2020 at 6:42 pm
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...
April 3, 2020 at 5:53 pm