Lynn - Any need for Start year Parameter to pass?

I will modify my actual query hoping it will work.. Thank you all for your input.

I will thank you, where EnrollmentDate is coming from?

Luis - Can you please tell me how you go about the max between start and end date?

Lynn - the answer is yes.

Phil - I completely agree, I remember that and I appreciate it...

Here is the script:

Create table EMP

(ID INT,

NAME NVARCHAR(10)

)

insert into EMP values (1, 'JOHN')

create table EMP_INFO

(ID INT,

STARTDATE DATE,

ENDDATE DATE)

insert...

Once again, many thanks Steve.

I read online the examples but your example was very clear, I immediately realized how to do it... Thanks again.

I just changed my query to follow your example, and it worked. Thank you. I appreciate it.

Hi Steve -

Following is how I have the query, I first have a set of data from the CTE, then another query that is joined to the CTE. What I...

Gail -

Thank you so much for the link and your input, I will look into it and follow the necessary steps.

I appreciate it.

Lava

Bjoern -

I was not able to find any good source explaining about licensing and CPUs available to SQL Server, but based on the articles out there I used masking....

Update - I have used the affinity mask, initially I had all processors show as online. Now I have only 8 visible online. Please correct me if I am wrong....

I can also see it from the registry screen, please see attached..

Hi Perry - From the Service screen when I look at the parameter, I do not see any spaces and that is how I added it T272 without any spaces....

Got it, thank you.

Perry - To confirm, from what you are saying converting two standalone SQL servers to clustered environment is not an option since Cluster was not set at windows level to...