Search results

Thanks Ron, most intermediate calc's are Decimal(38,26) so it seems type-inheritance applies. I'll round intermediate calc's where <> (38,26). Overflow Errors - thanks, there's always going to be a limit so I'm not too worried about this as I'm designing around reasonable spec's for the...

I'm no mathematician either, but I need to be accurate to 26 decimal places to minimise nested compounding; playing it safe to minimize problems. I do need big numbers mind as the calculations need to be as accurate as possible with linear regression (probably the wrong term). It's quite a pig...

Will the specification of the Decimal data-type apply to all calculations wrapped inside the Decimal data-type & each calculation inherit the accuracy specified by the parent Decimal type (26 decimal points in e.g.). I'm hoping it does because I have complex calculations which I do not want to...

Thanks George, much appreciated, I'll go composite index route.

In Access I used a composite index of 2 fields, but unsure best option in MSSQL for performance to avoid a duplicate record of the combination of the 2 fields? In the child table (relevant to topic) I have a foreign-key & a normal field. I think I have 2 options? Composite Index like in...

You have a great understanding for a first post. So obviously the below Entity Relationship Diagram (ERD) is not going to be fully correct (no doubt massively wrong knowing me) but a gist. Pretty much everyone on the forum is more capable than myself, but in trying to lend a helping hand; I...

@GPGeorge, thank you so much for taking time out of your day for this articulate explanation (the best I've come across after a week or so full-time research where full detailed articles & all MSN research... don't compare to this fine explanation). After much research I could not ascertain...

I would think the OP will require the recordset of the form to be editable, but enjoy the benefit of fast calculated fields in the view/ stored procedure/ function used inside a field of the query. 1 - Testing on a view in MSSQL; which is editable. The view then needs to be reloaded & the...

No that's helpful info, thanks for sharing.

Thanks Dave, ok I'm greatly outvoted here & I take onboard a unanimous vote from the experts with much greater experience than me. Thank you all for your input, greatly appreciated.

Thanks all for your honesty. Thinking of network performance with Azure, doing a very rough calculation (no doubt wrong :p) I have around 108,000 records * 6 average sub-records = 648,000 sub-records in this one area alone. relating to one container. I won't go into detail spilling out my...

Life is short, do what you want I think. But credit to you, it mustn't be that bad for 15 years of use & so happy that don't want to greatly deviate.

Int > TintyInt/ SmallInt/ BigInt... Seems no point in wasting space with some of these. I don't need to waste space generically assigning these data types with the PK's/ FK's to int. Don't get me wrong some will be, but I'm going through them now determining what sizes I reasonably need for...

EDIT - On closing & reopening MSSQL the changes have taken effect fully. I can handle the 4 FK constraints manually; that's no big deal but would appreciate if someone can help in doing this for PK's? After importing to MSSQL I want to convert certain FK's/ PK's data-types. So need to drop all...

Persevere, you're close. I struggled with this also. You're wrong on below, but logical so don't beat yourself. Pretty sure I did exactly that when experimenting also. qdf.Parameters(sPar1).Value = sFreq It's possible. If your intent is to set the parameter in VBA & run the query (you will not...

Oh dear, this is really not good for me 😭.

After spending a year developing my own application intended for .accde at initial launch this is the last thing I want to see. Credit to the author a beautiful brain. Did anyone try it out?

Be like Access I'd imagine; primary key at parent, infinity at child both infinites would end at a joining table. I'm sure your sort of calibre knows this & you've just put this as on off-the-fly comment. Thanks Albert, credit to you a lot of people don't admit when they're wrong. I also don't...

No that's not the protagonist, @tvanstiphout & @BlueSpruce got it from OP. I've regurgitated the topic many times now. Thanks for trying though (y), last thing I want to do is be rude. Your effort was appreciated.

Absent in GUI in Nr-3...