Thanks again. That totally right form my general, views, transaction and bulk process.

I am with you 100%.

For a compliance rule engine, the auditors and subject matter experts understand the atomic...

Id_Wells on Wells table is an PK (unique)

I totally forgot to include R_35 - thanks for the reminder.

As per my Missive above...

This Discrete Rule calls 2 sub-Discrete Rules.

While that...

CREATE FUNCTION [dbo].[R_35A](@ID_Wells int)

RETURNS int

AS

BEGIN;

DECLARE @Result int;

SELECT @Result = SIGN( COUNT(*) )

FROM Wells

WHERE (ID_Wells =...

Just getting back over extended 4th of July weekend.

Will post some examples soon. Thanks again for the valid concerns of efficiency.

In general, most SQL Server functions are used for large...

Thank you very much!

The use of this is calling only one ID_Wells at a time.

The data set is very small, about 50,000 total records in the main...

Many thanks! Did learn a couple of new things.

The Identity key worked. And, the Primary Key on a view is not possible.

The actual problem was that I used a...

CREATE VIEW [dbo].[vRegulatory_Nav_GISC]

AS

SELECT ROW_NUMBER() over(order by Reg_ID_Wells desc) as RowNum, dbo.vEDWells_List.ID_Wells AS Reg_ID_Wells, ...

-- Also removed the ORDER BY clause

However, I still need to make the RowNum...

Thanks again! Found an article on that and will now take the time to read it.

Thanks! I didn't think about that. (where is my V8 icon).

I was busy cobbling this together when you responded.

The Rule Engine components are designed to return each...

Yes, how to convert this one function to a UDF would be great.

I appreciate the comment on the efficiency of a hundred UDFs. The 100 Base Rules will not all...

http://www.access-programmers.co.uk/forums/showthread.php?t=260764

Have been creating views from the Oracle Linked Servers.

Interesting -

Trying to create View from SSMS interface failes because the editor removes the square brackests from the

[V2.EGG.COM].

SELECT...

The Access DB corruption isn't unique. But, it often is tied to a lack of a plan. It is not uncommon to see people trying to open up the combined...

Am I on the right track?

Started designing a View (MS Access can link to a view). The Oracle data is Read-Only.

The Oracle data residing in SQL Server will be where...

First of all, I am a Newbie myself.

The answer is .... it depends.

I have set up a table in SQL Server, usually a staging table rather than a direct link...

Thank you so very much. This is all very valuable to me.

At least in the past, only new field have been added to the Oracle views.

My 1st role is application...