Yes isdste fianlly worked. Thank you.

(cast(CASE when ISDATE(b.[LAST_DAY_WORKED]) = 1 Then (b.[LAST_DAY_WORKED]) ELSE NULL END as datetime) = cast(CASE when ISDATE(a.[LAST_DAY_WORKED]) = 1 Then (a.[LAST_DAY_WORKED]) ELSE NULL END as datetime)

...

This works Thanks Cris

Yes your solution is a start although it still does not adress the issue that I am having.

The data type in RawImport table is varchar and contains records without...

That works great! Thank you very much for your help.

That works although I neglected to mention that I was using SSIS expression builder and I need to build an expression that shows the leading 0's in the date. That...

Thanks that looks like it works.

Yes table structure would make it a bit easier.

(Database that contains associate details)

Database = [AssociateRepository]

Table Name [dbo].[Associates]

AssociateId PersonNumber Hierarchy

1329838xxxxxxxEBBGB...AD

1329840xxxxxxxEBBGB...AD

1333796xxxxxxxEUNKCFH.AB

1333797xxxxxxxEBGIB...AD

1329988xxxxxxxEBJD....AL

1329989xxxxxxxEBGIB...AD

1329991xxxxxxxEBBGB...AD

1330350xxxxxxxEZEFKB..AB

1330351xxxxxxxEZJDX...AK

1330352xxxxxxxEZHBI...AA

1361963xxxxxxxEBGIB...AD

1330898xxxxxxxEZEBBB..BD

1331108xxxxxxxEZJDX...AD

1331109xxxxxxxEBGIB...AD

1331110xxxxxxxEBGIB...AD

1331113xxxxxxxEBGIB...AD

1331114xxxxxxxEBGIB...AD

1326643xxxxxxxELBFABB.AB

1331439xxxxxxxEZHBH...AF

1331441xxxxxxxEBJD....AL

Database that contains recorded website hit counts PersonNumber and PersonNo used...

Hello I am a newbie as indicated next to my name. I spent the last 24 hours wrapping my brain around CTE's and feel I learned quite a bit. I...

Thank you so much SSCrazy and Lynn I really don't yet understand how it works but it does. I am going to try and wrap my brain around this for...

I am sorry i do not understand with TestDate ( PersonNumber, EntryDate) as piece.

Mayby I can clarify what I need. I want...

That is exactly what I needed. Thanks

Here is a sample of the results that I want. I want to combine the results of these two querries into one query.

This is query 1

Select Hierarchy,

...

I've attached sample data for each table view.

I just want to return

Hierarchy, -- From Forecast table

Course Code, -- From...

Yes there is a field in the forcast table for course code.

dbo.PM_ForecastView.CourseCode. What would the additional join statement look like?

I am looking at your code and I am trying...