If this is a 1 time deal, you don't even need DTS. You go under the Security item in EM, setup a linked server to Oracle. Once that is setup,...

>>So, how does one go about "replicating" the expression? I don't understand what you mean by that.

Instead of ORDER BY V2020, you need to ORDER BY {expression that is V2020}

i.e.

ORDER...

You can't reference output column aliases in the ORDER BY.

Eg:

CASE WHEN EXISTS(SELECT pkID FROM UsersPlansCouncils WHERE UsersPlansCouncils.fkUserID=u.pkID AND UsersPlansCouncils.fkCouncilID=1) THEN 'X' ELSE ''

 END AS V2020

This entire expression is aliased as "V2020"....

The (+) is Oracle specific. To code this in a more portable, ANSI SQL compliant way, you'd use LEFT OUTER JOIN:

select e.employee, u.user_name from employee e LEFT OUTER JOIN user_name ON...

To get last day of month, I usually add 1 month and subtract 1 day.

So take the existing algorithm (which gives you 1st of month) and ...

DATEADD( d, -1,  DATEADD(M,...

>>If you can then normalize... it's always the best option on the long run.

... for a transactional OLTP system. If the primary requirement is responsive reports, then resolving...

I don't think the VBA code is the issue:

>>Cannot load the DLL c:\Program Files\Microsoft SQL Server\MSSQL\Binn

This error would seem to indicate a badly constructed filename in the extended stored proc...

The difference is declarative versus physical/procedural integrity.

With a constraint, you specify what integrity you want, by declaring it as part of the table definition, and you allow the DBMS to...

I would suggest revisiting the data model first.

>>I have another table (supervise) with jobtitle and reportstopos.

Why is Title in this table, and not EmployeeID ? What if a job title...

The first question in a hierarchy related problem is always this:

Is the hierarchy of fixed maximum depth, or is it variable ?

i.e. How deep is your organisation's org chart ?...

>>Ambiguous column name 'Feature_Sequence'.

Right, but it's an easy fix to prefix each occurrence of feature_sequence with the table alias to remove the ambiguity.

Select feature_id, feature_text, f.feature_sequence, publish_startdate

That's not the query I posted. See the very 1st reply, above, using a join to a virtual table.

Given that info, the query I posted above should work. Did you try it ? Did it not return the correct 4 rows ?

Read BOL on the CONVERT() function. Using a format code, you can convert [Period Date] into 'MM/DD/YYYY' format in the WHERE clause.

Psst - 2 digit years ? What about Y3K ?...