CREATE TABLE & INSERT scripts?

Feel free to explain more. I'm not sure I know how to determine what is approved.
Please read this and post again: http://www.sqlservercentral.com/articles/Best+Practices/61537/

You need Jeff Moden's DelimitedSplit8K function for this...

DECLARE @MyString VARCHAR(200) = 'Department =''test'' AND Branch = ''Yankee'' AND city = ''Brooklyn'' AND State =...

Neither. fn_CalculateNetPay is a function, and that's how you join a table to a table-valued function - by using APPLY

sys.dm_exec_procedure_stats
does that.

FFS! Just post the contents of the text file into the message window!
--Create New Table
    drop table if exists Test_Tbl
    CREATE TABLE Test_Tbl (Id varchar(1), Name...

Only thing I can think of that even might work is to create a subform and add two parameters to it for DIP and Data. Then add that to the...

What happens if you run the stored procedure that the report is based on?
If you're on a test server, you could do something evil like run
DBCC FREEPROCCACHE
to...

Where does one get these files:
library("rClr")
library("rsqlserver")

?

Are the users in a Group in Active Directory?  Are the objects they need permissions to in the same schema by themselves?

Sue,
Thanks for the reply. I figured I had nothing to lose, so I installed the Data Mining Add-In... Now to figure out how to set up SSAS Multi-Dimensional... =(

How long does it take to run the report if you run it directly?
Did you look at the stored procedure that the report is based on? (it is based...

Why not make things easy for everyone and tell us all what your expected output is given the data you have already provided?

Use OR/IN in the your WHERE clause.

SELECT itemno,item code,closedate
FROM item a INNER JOIN itemcode bFROM item a INNER JOIN itemcode b

July 24, 2017 at 8:42 pm

#1952487

There's even an example XLS file...
http://www.daxpatterns.com/budget-patterns/

If you want Q1 to ignore the previous quarter (Q4 of previous year), you could do something simple like

IF(Calendar[Quarter]="Q1",BLANK(),...

How about the CREATE TABLE and INSERT scripts?