The only issue I see here is with Scott and My results is the emp_id = 45678. The employee has the same email for both fields, and that email is...

What I did first is create a list of invalid emails

With myCTE as

(

Select emp_id, emailType, email

From #temp1

Unpivot (email for emailType in ([email1],[email2])) as upvt

)

Select email, count(email) as numTotal

into...

Good article that highlights rounding as really a formatting function. In the movement and derivation of data, I like to save rounding towards the end. That is, when you actually...

The links were provided to you because the subject matter is something that people figure that you can read through and understand on your own. It is better to get...

Can you take a look at the attachment... is this how you are trying to connect through...

For older versions of SQL SERVER : A simple (non table valued) function >

if object_id('fcnTEST') is not null

drop function fcnTest;

GO

CREATEFUNCTION dbo.fcnTEST(@param decimal(10,3))

RETURNS decimal(10,3)

AS

begin

return @param *2

end

GO

----------------------------

selectdbo.fcnTEST(t.[n]) as...

On the topic of running

inside of a cursor....

Not sure what the original objective was but if I am understanding well enough, I imagine can...

It would be good to also post the definition of the destination table. We could see clearly what it defines as a duplicate.

I am just wondering if

L.fundingDate < dateadd(m, -1, cast(getdate() as date))

Would not serve your purpose...

Just covering the obvious, is the report...

After this step I am sure you can configure the next data flow task in the control flow, to move from staging to your destination table. Though part of the...

Start with a data flow task. Open this >

If you are joining on tables already in a SQL Server database then you will simply use that same SQL statement...

So for the Monday, you want Friday listed,

Same for Sunday.

Would the code not actually read as

(1 indicates a Monday)

iif(Weekday(Parameters!TopLineDate.Value,1) = 1,

dateadd("d", -3, Parameters!TopLineDate.Value),

...

I am interested in seeing what the columns actually are. Can you post this? I suspect you are not satisfying 3rd normal form in your database tables.

Hugo Kornelis (9/16/2016)

A logical...