Hi Phil,

Wordpress has issues converting and showing T-SQL code correctly.

For example the function fn_removelistChars, the function in WordPress code block gets strangely converted.

This part:

WHILE PATINDEX(@list,@txt) > 0

SET @txt = REPLACE(@txt,SUBSTRING(@txt,PATINDEX(@list,@txt),1),'')

RETURN...

Hey Thomas,

Thanks for commenting and sharing your solution.

Great thinking.  I have had this similar solution for years and understand it.

But eventually decided to recreate it. My issue with parameters as...

Thanks Phil.

I totally relate to your concern regarding the version control; there are pro/cons.  But so-far I have not come to a bullet-proof solution.

I have solved this with 1) either...

Hi rlDawson_SLCb,

Thank you for reporting this; it is a formatting problem (that occurred with uploading the code) and I will update the code so it will be readable. Readable version...

• This reply was modified 2 years, 10 months ago by  tomaz.kastrun.

Hi ReeceWatkins-16343,

Thanks for notifying about the English words.

Feel free and fork the repository and remove the words and create a pull request. That would be super awesome and I would...

• This reply was modified 2 years, 10 months ago by  tomaz.kastrun.

Hi,

you can use all the Markdown formatting text for the output. You can try: Basic Syntax | Markdown Guide 

I agree with QUOTENAME() function; great remark.

Best

Couple of shorter solutions:

--Solution 1
SET DATEFIRST 1
DECLARE @d DATE = '2016-05-13 00:00:00.000'--GETDATE()
WHILE (@d < '2099/01/01')
  BEGIN
   IF DATEPART(dw,DATEFROMPARTS(YEAR(@d),...

Hi Jay,

sorry for late response.

This looks to me that ROCR is not available at the right location from where you are calling this R script. So...

Thank you Nick,

Agree with your  points.  Thank you for point them out and  thumbs up on article. 🙂

Hi Nick,
I would be careful as to what type of data to be used in PCA, as this algorithm is sensitive to types of data (nominal, ordinal, categorical, interval)....

Hi,

thanks for feedback.

Yes, you have to install it manually.

There is an article on how to install missing packages in R: http://www.sqlservercentral.com/articles/R+Package/145571/
I...

Hi,

I can not reprocduce the error 🙁 Try to handle the datatypes in report. maybe the image is in wrong format. Can you try that.

best, tomaz

Glad that this is working.

then just double check all the settings in SSRS, that datasets are correctly set.
and I strongly suggest that you also execute the  stored procedure in...

Very good.
Have you tried to execute only a simple R script that will return a dataframe / table in SSRS?

For example create  simple procedure like:
[code...

cool.
and can you also run the Procedure for SSRS and the code for powerBI?
including the one  where you are referring to the ggplot2 package?