I give. I don't get it. I see how in theory you should apply debits to credits or whatever, but I'm not sure why it matters. I must be missing...

Sorry, my installation of SSRS 2008 and even 2008R2 are both long since gone.

In 2016 (so this may not work for you), you go to Parameter Properties.

Check Allow Multiple Values.

Go...

Could you please explain the logic of how you get to the expected result? The running total over the CustomerID is really close, but wrong somehow... but why?

How is the...

Here's my setup so other folks can play along:

--TransactionIDCustomerTransactionTypeDateAmount

SELECT CustID

, TransID

, TType

, TDate

, Amt

, SUM(Amt) OVER (PARTITION BY CustID

ORDER BY TransID

ROWS BETWEEN UNBOUNDED PRECEDING

AND CURRENT ROW) AS...

just wondering... what if you used a windowing function and did a running total of the value (credits are positive, debits are negative). Then it would act like a checkbook

SUM(value)...

Okay, looks like I got bit by the "Reading Is Fundamental" bug...

The short answer is CALCULATETABLE.

When I actually OPENED Ferrari & Russo's DAX Patterns book, there's a chapter on Surveys...

This kind of begs the question... If I had a resume like

SQL Developer 2<24 months>

Company ABC

SSMS, SSRS, SSAS

SQL Developer 1<36 months>

Company XYZ

SMS, SSRS

how would you count my experience? doing...

Hmm.. that might explain the defective light saber...

Use the [Google]Force, young Jedi!

https://www.mssqltips.com/sqlservertip/3506/set-select-all-as-default-for-multivalue-report-parameters-in-sql-server-reporting-services/

If you're getting the time the report was run, you can use the global variable Execution Time.

=Globals!ExecutionTime

You could get 12 hours before that using this:

=DateAdd(DateInterval.Hour,-12,Globals!ExecutionTime)

If you create a placeholder for...

Lowell brings up an interesting point that I totally forgot about. tightly coupling data insertion/triggers with e-mail can cause your inserts to fail if your mail server fails. ...

How is the data being inserted? By an SSIS package? Why not flag the duplicate there and manage the problem close to the data?

you don't need .NET at all for...

Due to the way you have to calculate the current rent, I think your only option is to use a cursor (Yeah, I know, I should probably wash my own...

Doing this in PowerBI or PowerPivot would be really simple if you build a quick data warehouse with dimensions for Time/Date and Employee and a few measures

Sounds like you selected just the

SET @test-2='This is my name';

line and tried to execute just that. if you don't select the previous line, where @test-2 is declared, the...