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...

This is just to illustrate the concept outside of SSRS

Create table #temp (

colA tinyint,

colB tinyint,

colC tinyint,

colD tinyint,

colE tinyint,

colF tinyint,

colG tinyint,

colH tinyint

)

/* inssert some test data into our table */

insert...

Hi, Sorry I dont quite understand the question . You want to know how to alter a view to add two new existing columns? Can you post what you have...

Just wanted to bring up a point of inquiry : the view sys.dm_db_index_usage_stats would not satisfy if any table has no indeces I imagine.

I am not sure...