Susan,

Thank you for the additional info.  There are a few questions that come to mind about the basic design of the system.  I'll ignore those for now because it sounds...

Hello,

I am going to rephrase your question.  Please confirm that this is close to what you are asking, or corrct me if I misunderstand the problem.  Also, please provide DDL...

G'Day

Wow.  Where to start...  Lets deal with the immediate problem first, then move to the more general question of how to learn everything there is to know about being a...

Hi Cory,

I'm not sure I understand your question.  Can you provide a few more details?

Ideally, we would like to see an example schema, sample data, and expected results.

The simple answer...

Hello Megan,

I think the key word in your post is "document", not "implement". 

Business rules are usually derived by asking the experts in the business how there work takes place. ...

G'Day,

When I google 'temporal upward compatibility' I receive 46,800 links.  The first link says "Temporal upward compatibility [BBJS97] demands that existing XQuery code operating on the previous non temporal documents...

Hi there,

There are a couple of problems you will need to consider in the implementation.  First is that when a proc is executing on the server, it may not execute...

Thanks Noel,

Your advice got me moving in the right direction.  I was concatenating three NVARCHAR strings to create the complete command.  I converted the code generator to use a single...

Here is the access query reformatted to spread things out a bit... 

SELECT DISTINCTROW

qryDLEmpList.Emp_HireDate,

qryDLEmpList.Emp_Dist,

qryDLEmpList.Emp_Dept,

qryDLEmpList.Emp_ID,

qryDLEmpList.FullName,

qryDLEmpList.Emp_ClassName,

qryDLEmpList.Emp_Phone1,

qryDLEmpList.Emp_Phone2,

Max(qryDLCallOutsCentral.CallDate) AS MaxOfCallDate

FROM qryDLEmpList

INNER JOIN qryDLCallOutsCentral

ON...

Here is the generic solution I mentioned earlier.  Hope this helps.

create table #FlagTable (Flag1 int, Flag2 int, flag3 int)

INSERT INTO #FlagTable (Flag1, Flag2, Flag3) VALUES (0,1,1)

create table #DataTable (LastName VARCHAR(25),...

Please post DDL for the two tables.  Otherwise, you will likely receive a generic select that may or may not make sense in your specific situation.

Wayne

Lowell: Please notice that I did not aseert whether I thought one database was right or wrong - I asserted that there was not enough information to make an educated...

Of course, as most spooks and military types will tell you, it is far easier and cheaper to just point a gun at someone and ask them what you want...

G'Day,

I'm not sure I agree with Peter, mostly because there is not enough information in the original post.

Is the application an internal company app?  Or is it a product?  Are the...

Hello,

I have encountered problems in the past when a materialized view included the tables I expected and a few other tables that were not part of the insert, for example.  The...