Viewing 15 posts - 76 through 90 (of 185 total)
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.
July 23, 2015 at 2:00 pm
I will thank you, where EnrollmentDate is coming from?
July 23, 2015 at 1:51 pm
Luis - Can you please tell me how you go about the max between start and end date?
July 23, 2015 at 1:42 pm
Lynn - the answer is yes.
July 23, 2015 at 1:38 pm
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...
July 23, 2015 at 1:22 pm
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.
July 16, 2015 at 6:33 pm
I just changed my query to follow your example, and it worked. Thank you. I appreciate it.
July 16, 2015 at 8:30 am
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...
July 16, 2015 at 8:28 am
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
July 2, 2015 at 6:32 am
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....
July 2, 2015 at 6:17 am
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....
June 29, 2015 at 12:51 pm
I can also see it from the registry screen, please see attached..
June 16, 2015 at 7:19 am
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....
June 16, 2015 at 6:35 am
Got it, thank you.
April 15, 2015 at 7:29 am
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...
April 15, 2015 at 7:23 am
Viewing 15 posts - 76 through 90 (of 185 total)