After going through the query, if found i have missed a case and i have fixed it.

Following is the issue:

fixed issue: If 1st DemandQty is greater then the available quantity...

Well, try to pass the ToDate without timestamp data.

i.e instead of

ToDate=2016-06-23%2021:59:00

try this

ToDate=2016-06-23%2022:00:00

you are welcome 🙂

Check the settings for TempDir under the advanced settings on your SSAS instance. By default this is set to c:\ and if your cube is heavy on aggregations they can...

declare @Transaction table

(

ID int

, Store char(3)

, SKU int

, AvailableQty int

, ReceivingStore char(3)

, QtyDemand int

)

insert into @Transaction

--- Original Case

select 1, 'ST1', 100, 20, 'ST2', 14union all

select...

Share some of the sample data for which you are having issues.

can you share some more detail when you say something like

you do you are getting this date from ???

any my...

what i meant was USE your parameter in the report source something like this:

Select @FromDate as FromDate, @ToDate as ToDate

and use FromDate & ToDate column as a source and...

declare @Transaction table

(

ID int

, Store char(3)

, SKU int

, AvailableQty int

, ReceivingStore char(3)

, QtyDemand int

)

insert into @Transaction

select 1, 'ST1', 100, 20, 'ST2', 14union all

select 2, ...

quick question, you need TransferedQty column result through the query ???

passing date as parameter is a very basic and usual working however, try to select the parameter in the t-sql and see what you are getting in return?

Nice question, Thanks for sharing.

If you use the

SET SHOWPLAN_TEXT ON

you will get the following result

SELECT sum(ID) FROM T1

you will get the following plan

|--Compute Scalar(DEFINE:([Expr1004]=CASE WHEN [Expr1005]=(0) THEN NULL ELSE...

you can change your logic to this if u r on SQL2000.

Declare @Val1 int= 1

, @Val2 int= 2

, @Val3 int= 3

, @Val4 int= 4

;

Select MAx(val)

from

(

Select @Val1 as val...

Something like this:

Declare @Table table

(

id int identity(1,1),

col1 int,

col2 int,

col3 int,

col4 int

)

insert into @Table

Select 1,2,3,4 union all -- 4 highest

Select 5,6,7,8 -- 8 highest

Select *

from

(

Select * , ROW_NUMBER() OVER...