I am not familiar with PLSQL, but with the method you are doing in that query, you are doing a 1-1 comparison, so @ID MUST be a single value, unlike...

That part is the EASY bit.  Set the report parameter to allow multiple values.  Then set the report parameter to be a variable in the query and use your WHERE...

This one is actually answered in the documentation.  First I went here:

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-parameters-report-builder-and-report-designer?view=sql-server-2016

which gives an overview of report parameters in SSRS 2016.  From there, I searched for "Data Type" which listed...

Could you provide:

1 - what you have tried already?

2 - sample output for what it should look like?

I am not sure what "stick" means or what your output should look...

• This reply was modified 5 years, 7 months ago by Mr. Brian Gale.

Congrats!  I have the same certificate and I think I got the same score actually.

Are your plans to keep going and getting more certs or stopping at the MTA?

What I mean by sequential is to just don't do the same task simultaneously.  So if you are calling a stored procedure, just make sure your package only calls that...

I wouldn't bother with NOLOCK as that doesn't work with UPDATE queries.  Won't get a syntax error, the hint just gets ignored.

As for a good alternative, if you NEED a...

Jeff I think this may be a thing that we have to agree to disagree on.  I am not saying that SQL shouldn't be the first solution you look at...

The index ID and the Object_ID are tied together.  Object_ID will tie back to a table whereas the Index ID will tie back to an index ON the table.  So...

Stream design doesn't introduce blocking.  Your stored procedure is creating the blocking.

You even said it creates blocking - you are requesting an update lock on the table.  So anything that...

Index fragmentation is a very heated debate on SSC and ranges between "don't ever do it" to "do it once it gets above x%".  My advice - if the index...

it depends.  Having multiple "streams" call the same stored procedure that is updating a table will create blocking on that table and each one will need to wait for the...

My approach is to watch for long running queries.  If I have a long running query, then I probably need an index (or other tuning) of some sort.  I would...

Can you post some DDL?  We have no sample data to go off of and your query that you have there doesn't have an end to it or a FROM...

It depends.  The order for the index is the order it is "ordered" in the table.  So if you order it by col1 and col2, it is REALLY by col1...