Thanks so much for your help Gilamonster, I really appreciate it.

Thanks for all your help GilaMonster!!

One more thing though. If the date range entered doesn't fall within items in the AbsenceHistory table, nothing is returned.

In this case I switched the...

I made the changes, but the query still returns the same results:

WITH TEMP AS

(SELECT

E.ID,

E.Name,

AH.StartDate, AH.EndDate, AH.SpansWeekend, AH.AbsType,

CASE WHEN AH.SpansWeekend = 'True'

THEN

((DATEDIFF(day, AH.StartDate, AH.EndDate) +1)...

Which one will perform better?

It is going into a production environment. There are not very many rows now, but it will grow over time. There could potentially be several thousand...

Perfect!!

Thanks for the responses, much appreciated.

I read some info on TDE while reading the other articles you posted.

Would you recommend using TDE?

It seems like it would be the easiest solution to put in place since...

By removing the Integrated Security=false and adding in Trusted_Connection=yes resolved the connection issue.

That seems to all be working fine now. Now on to some encryption questions.. 🙂

There are definitely columns...

Hi Elliott,

user/pass is authenticated using SQL.

I added a new login and it uses SQL Authentication. Set the default database to the db that it needs access to.

In the Server...

Thanks for all the feedback guys! Helped me alot!

Found my mistake.

It should be E.ID = T.EmployeeID

NOT

E.EmployeeId = T.EmployeeID

Thanks.

Thanks for the help everyone, especially Tom. Got it working now.

Tom.Thomson (4/18/2011)

---

What is the type of the ClosedDate column of the PerformanceReviewHistory table?

If the type is DATE, try using

....PRH.ClosedDate BETWEEN + cast(' + convert(nchar(8), @pStartDate, 112)...

Thanks for all the help. Almost got it working, except I wanted to add a start/end date filter which I thought would be easy, but am getting some conversion errors.

CREATE...

Here is the Split function:

CREATE FUNCTION [dbo].[Split]

(

@RowData nvarchar(2000),

@SplitOn nvarchar(5)

)

RETURNS @RtnValue table

(

Id int identity(1,1),

Data nvarchar(2000)

)

AS

BEGIN

Declare @Cnt int

Set @Cnt = 1

While (Charindex(@SplitOn,@RowData)>0)

Begin

Insert Into @RtnValue (data)

Select...

here is the Dynamic_Pivot Procedure

CREATE procedure [dbo].[DYNAMIC_PIVOT]

(

@select varchar(max),

@PivotCol varchar(max),

@Summaries varchar(max)

) as

declare @pivot varchar(max), @sql varchar(max)

select @select =replace(@select,'select ','select '+@PivotCol+' as pivot_col,')

create table #pivot_columns (pivot_column varchar(max))

Select...