Viewing 5 posts - 1 through 5 (of 5 total)
You are ignoring the reason "banker's rounding" exists in the first place. In most cases the handing of financial calculations (including rounding) is regulated by law or contract. It's not...
June 15, 2020 at 11:15 am
For sake of completeness the solution was:
CREATE TABLE SURNAME (
[SurNameId] [int] IDENTITY(1,1) NOT NULL,
[SurName] [nvarchar](50) NOT NULL)
create function [dbo].[SurnameLookup](@SurNameId int)
returns nvarchar(50)
as
BEGIN
Return (Select SurName from SURNAME where SurNameId = @SurNameId)
END
CREATE TABLE...
May 21, 2010 at 3:19 pm
Thank you.
So something like:
FullName As (Firstname + ' ' + dbo.SurnameLookup(SurnameId))
is what you're suggesting? Sounds doable. Long term the performance impact can be measured and troublesome lookups and...
May 21, 2010 at 2:33 pm
Yes, I know I can create a trigger, yes I know I can create a view. A trigger means the data is persisted, the view tells the O/R mappers not...
May 21, 2010 at 2:13 pm
Yes I know, but as I noted above if I do that O/R mappers will not generate update code because views aren't updatable (in SQL server). I could also simple...
May 21, 2010 at 1:41 pm
Viewing 5 posts - 1 through 5 (of 5 total)