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...

Read Kenneth Fisher's blog[/url] about it.

Try using a Tally table where you define the numeric type explicitly in the table definition. Normally INT is big enough... then when you join to another table with...

I might be getting somewhere...

Since I only have 3 possible symptoms, and the total combinations is only 3!=3x2=6, I can just create a cheat matrix:

If I put this in...

Try IsDate(Fields!r1RedWalletSentDate.Value)

Sounds like you have data problems in your underlying tables. Why is there anything but dates in this column? Normally, date fields contain either a date value or...

I have a really simple one in PowerBI with only a handful of Patients. It's really small on purpose, because I only need a few records to prove the...

Since you're pretty new here, I just answered your question... but you really should make it as easy as possible for folks to help you. Here[/url] is a good...

Maybe something like this?

UPDATE [Table2]

SET [CCode] = Table1.[CCode]

WHERE [Table1].[TransType] = [Table2].[TransType]

AND [LocID] Like '%' + [Table2].[Location] +'%');

What exactly do you mean by "contains"? Do you mean something other than "equals" Or do you mean something like

set {a, b, c} contains {b}?

How are you determining "contains"...