Hi Thom,

I appreciate your response. I found that although the report when viewed within Microsoft Visual Studio shows an extra blank page at the end, when I exported that...

Thank you for the answer. I'm sure this will apply to lots of similar issues.

I will try changing the #Emps temp table into a @Emps variable table. I have been called to work on another project now, so it may be some time...

Thank you both for your help. I found that inside the stored procedure was already code similar to that which you each proposed. When I entered the CREATE...

The first INSERT succeeds because both "CTId = 1" is TRUE and "Goal IS NOT NULL" is TRUE.

The second INSERT fails because "CTId = 1" is not TRUE.

The third INSERT...

I often need to do the same task as you, working with someone else's SQL statement, usually to create something similar. I like to copy the original SQL statement...

I now have found out that the myCalendar table was set up worse than everyone thought. Columns 1 through 182 of the field named CalendarDays represent days January 1...

Hi Jeff,

Thank you and everyone for your help. I started using the statements from your posting of 6/23/12 8:37PM and was able to get the data that I wanted....

Correction:

--===== Create the test table

CREATE TABLE dbo.Employee

(

EmployeeID INT,

StartDate DATETIME,

CalendarID CHAR(4)

)

;

INSERT INTO dbo.Employee

(EmployeeID, StartDate, CalendarID)

SELECT 1, '20111215', 'A209' UNION ALL

SELECT 2, '20110113', 'L261' UNION ALL

SELECT 3, '20120113', 'S222' UNION ALL

SELECT 4,...

Hi Jeff,

Let's use this:

--===== Create the test table

CREATE TABLE dbo.Employee

(

EmployeeID ...

To Jeff Moden -

Thank you for your help. I have used you Tally Table method on several issues that I have had and it always works very well....

drew.allen said

I don't think that your sample values are correct. June 22, 2012 is 102 days after Feb 3, 2012. If you only want to count paid days, are you...

You can disregard my comment about the Julian date. I believe instead that we can find the Hire Date in the CalendarDays field after calculating the DateDiff in days...

I think that part of the solution would involve converting the Hire Date into a Julian value. Is there any function in SSMS that will convert a date to...

Al says to his friends Bill and...