Hi Just_Myles,

Please take a look at this topic Can't deploy reports from BIDS to reporting it contains a detailed explanation about setting up the Report Server hosting your reports (which...

That's totally true :blush:

I did not try the query without referencing a function; the query below took a bit more than a second on my environment.

-- 2 seconds

SELECT

SUM(sc.column_id...

I did not try the query without referencing a function; the query below took a bit more than a second on my environment.

-- 2 seconds

SELECT

SUM(sc.column_id...

I did not try the query without referencing a function; the query below took a bit more than a second on my environment.

-- 2 seconds

SELECT

SUM(sc.column_id...

I did not try the query without referencing a function; the query below took a bit more than a second on my environment.

-- 2 seconds

SELECT

SUM(sc.column_id...

I did not try the query without referencing a function; the query below took a bit more than a second on my environment.

-- 2 seconds

SELECT

SUM(sc.column_id...

I did not try the query without referencing a function; the query below took a bit more than a second on my environment.

-- 2 seconds

SELECT

SUM(sc.column_id...

I did not try the query without referencing a function; the query below took a bit more than a second on my environment.

-- 2 seconds

SELECT

SUM(sc.column_id...

Hi ReginaR1975

It seems your testing query on the in-line table valued is missing a join column

--this returns 5 records

SELECT P.[ListPrice]*PH.StandardCost

FROM [AdventureWorks].[Production].[Product] P

INNER JOIN [AdventureWorks].[Production].[ProductCostHistory] PH ON P.ProductID = PH.ProductID

WHERE PH.[StandardCost]...

Thanks Barry,

I will find out the structure or format of the site's articles and approach Steve Jones, I am not discourage, actually I went into comparing the four solutions discussed...

Thanks Jeff

I tried my code with Barry's function getting a result 1 versus 6 seconds in favour of Barry's 🙂 I am in the process of fine-tuning my T-Sql skills...

Hi ReginaR1975

You may follow the suggestions found at the link posted by dwain.c or enable the CLR (Common Language Runtime); the CLR allows you to code functions in Vb.Net or...

Hi akumbabarns

I am glad it worked :-), this topic's documentation is spread across several documents over the internet, it took me about two days to work it out.

Hi akumbabarns

Take a look at the last picture on my previous message, right-click on your project, click on properties and make sure that the TargetServerURL is http://DBA/ReportServer_MSSQLSERVER08, once you set...