Thanks a lot its working perfect, but is there any way to prevent the MainGroup.Name from output more then one time.

SELECT Aydin.MainGroup.Name, Aydin.SalesFigures.ArticleNo, Aydin.Article.Name, Aydin.Article.QuantityPerUnitTextSale,

STR(round(SUM(CASE WHEN PERIOD = 1...

Thank you for this solution.

One issue is solved now I´m displaying 0 instead of NULL in all the columns except the total column it still displays NULL when at least...

We have 16GB of RAM sqlservr.exe takes all 14,5GB

Thanks it works perfect after adding an alias to the columns that was computed or concatenated.

I need to understand the scope of the variables and to know if @testResults is...

Msg 8117, Level 16, State 1, Line 5

Operand data type varchar is invalid for subtract operator.

Parsing the code is green but when executing I´m geting the following error I know it has to do

with the single and double qoutes can you please help to correct...

I mean the rows selected if there is any.

What I want is:

If there is any rows then I send the mail

If not then I´ll skip the mail.