Kill a lock process
The last method (workaround) to solve a lock status is by killing the process. Write this line to Kill a process in sql server:
1 2 3 4 | --This example shows how to terminate SPID 55. KILL 55 --This example generates a status of the rollback process for the specific spid. KILL 55 WITH STATUSONLY |
–This is the progress report.
spid 55: Transaction rollback in progress. Estimated rollback completion: 70% Estimated time left: 15 seconds.
Multiple IIf Logic Block
IIf function often used in MultiDimensionalExpression (MDX), It’s quiet simple to implement single block of IIf block.
This an example of Multiple IIf logic block.
Example1:
1 2 3 4 | IIf(Measures.[Store Sales] > 50000, "Good", IIf(Measures.[Store Sales] > 30000, "Average", IIf(Measures.[Store Sales] > 10000, "Poor", "No"))) |
