You would make your life easier if you stored dates as dates. This is an Islands and Gaps problem. One solution:

WITH cte_Employee (EmployeeId, EmploymentTypeId, DateId)
AS
(
  ...

https://www.sqlservercentral.com/forums/topic/a-brief-explanation-and-solution-for-the-double-hop-problem

Run Ed B's code.

In future, provide a test rig and test answers before answering. If you do not know how...

I prefer migrations but have used in-place upgrades to buy time until there are the resources to look at a more managed upgrade. The trick is to have lots of...

I'll try to answer the questions all in one post here.

1. I'm not posting the full DDL of objects because there are only 2 views that are joined.  However,...

@ken - The 2 views are in the same schema,  but the underlying tables are in 2 different schemas.  That said, if I run "SELECT * FROM ViewA" and...

Personally I will only use DENY permissions when I really have no option.

Are all the tables and views in the same schema or at least in schemas with the same...

Your link uses the Microsoft OLE DB Driver for SQL Server not the ODBC driver. Maybe you should try that.

Where is the result showing 23? SSMS or, as I suspect, Excel etc

My first replay seemed to time out so I posted again.

• This reply was modified 2 years, 1 months ago by Ken McKelvey.

If this is an Agent Job step then Powershell is a lot less hassle. Play with something like:

$SQLparams...

LEAD is a windowed function - what makes you think it is going to work in a...

It may also be worth speaking to you network team as something like Wireshark could tell you what is communicating with the server. Also, given the age of the server,...

This post makes no sense. Why would you have an OrderId in a Customer table!?

Also there is no DDL, including the primary key, so the best that can be done...

I am not sure what question/problem is.

A few basic points to note:

1. Oracle effectively works as SET IMPLICIT_TRANSACTIONS ON so third party applications, which target multiple dbs, tend to work...

• This reply was modified 2 years, 1 months ago by Ken McKelvey.
• This reply was modified 2 years, 1 months ago by Ken McKelvey.
• This reply was modified 2 years, 1 months ago by Ken McKelvey.
• This reply was modified 2 years, 1 months ago by Ken McKelvey.