SQL Server. As soon as it hits the first comma in ('4','10','30') it throws an error.

The error is in relation to the parameter I have setup. I do have the "IN" clause in place within my dataset query. I am googling for a resolution, but...

How do I correctly use the "Select All" option with this? I have multiple values checked in the parameter property, but when I execute the report it returns " incorrect...

That is perfect! Thank you for the help. It is appreciated.

I built a staging table and I am writing the last execution time of the sp to that table. How do I now use the execution time in the WHERE...

Thanks for the reply. I was hoping to accomplish this using some dynamic code, rather than maintain a static table, but that may be my best option. Thanks again.

I figured it out. Added the Null in the Select list and split out my Where clause.

Declare @FromPN char(30),@ToPN char(30)

Set @FromPN=FromPartNumber

Set @ToPN=ToPartNumber

select *

...

The part numbers include numeric, alphanumeric, and sometimes special characters (-, /, etc...). I receive an conversion fail error when using COALESCE.

Worked perfect! Thanks.

That looks good. As long as I can identify which permissions differ between two groups.

I will be comparing only two groups at a time.

The goal is to find out which permissions one group has that another group does not, or vise verse.

Will do. I appreciate your help very much. That is a cool piece of script.

That is cool and will get me by, but is there a way to list them into individual columns rather than stringing them together in one? I appreciate it very...

Got it. Forgot to include the TimeStart in my Group By (Sub Query).

-- Reports that are not being used

Select c.Path as Folder

...