Hi

What version of visual studio SSDT are you using?

There was or is an problem with version 15.6 where you would get this error. If you...

Hi

Just check that your PK (PK_CIFBlobMaster) was actually created on the table dbo.TestMaster. I ran your code and it created all 3 tables with all the PK and FK's...

Is this what you are looking for:

CREATE TABLE #Test(TestDate DATETIME, TestNumber INT)

INSERT INTO #Test(TestDate,TestNumber)

VALUES ('2016-06-01', 3574),
       ('2016-06-30', 4178) ,
       ('2016-09-01', 4941) ,
     ...

Hi

No, the first query did not process the else part. It has to do with the data type precedence. In the first query you are comparing date's and...

Hi

Check that your user PRXUSER has access to the location where your access database files (.mdb) are stored.

What you can also do is create two separate reports for the two that you have.

Then create a third one to act as an 'portal'. On this report you can...

Hi

You should change your second AND statement as well to check for the three different conditions.

This should work if I understand the question correctly:

Is this what you are looking for:

SELECT EmployeeID
  , HireDate
  , TermDate
FROM #T
WHERE EmployeeID IN ( SELECT T.EmployeeID

Your values for the where conditions should be in double single qoutes.

SET...

There are two indexes because you created an clustered Index before specifying the Primary Key.  The primary key is usually the clustered index unless specified otherwise.

So since creating...

The Problem here is parent table is also acting like a child table.

is there anyway to insert a record , for this kind of scenario ? Yes...

Hi

When you are referring to max date should the dates all match including the hours, mins and seconds?

If not why just not get the max date form you date cast...

Also have a look at the following as an maintenance plan which you can use or only pieces for the index optimizing that you are interested in: