Don't go any further out of your way. I have enough of an understanding to test this using the real thing. As well, this answer fits well enough...

I agree with you on the catch-all nature of the system design. I am spending a lot of my time rewriting these to Dynamic-SQL and educating the users as...

It’s not an easy feat to post sample data. The type of data involved is regulated and there are serious privacy issues involved, so I could only post data...

We do not have before/after query plans at this time.

The code is (currently):

create view dbo.vwSystemDateTime

as

select getdate () SystemDateTime

go

CREATE FUNCTION [dbo].[BedIsAssigned]

(

@BedID int

)

RETURNS bit

AS

BEGIN

DECLARE @Result bit

IF EXISTS(SELECT Organization_Bed_Assignment_ID

...

I have to throw in here. I have had similar thoughts as to the author in the past. However, at the time, I was working on low volume...