use a cursor to loop through the tables that match your criteria and pass the table to some dynamic SQL and use BCP OUT? Or use PowerShell?... maybe... <spitballing>

SELECT ...

FROM t

WHERE  (EMPLOYEE_ID != 123 AND WORKSITE_ID != 22)

Now to understand it!

Maybe this article will help:

Introduction to T-SQL Window Functions - Simple Talk (red-gate.com)

Welcome!

Good explanation of the problem! Very helpful. Since you're new, please read this article. It's just a user's manual of sorts for here. Forum Etiquette: How to post data/code...

3199 points and you can't even post sample data?

Use LEFT() or RIGHT() to trim off the characters you don't want.

Seems like you could do a main/subreport.

Main is based on Student, and then the subreport is based on attendance in a span of time (it has the StudentID as a...

Did you drop a tablix in and then drop the fields into the columns of the tablix? I've never ever had SSRS just not return any data based on a...

It sounds like you could be filtering based on domain username, and if you're using impersonation or whatever to run SSRS, then that's getting lost. Strictly conjecture though.

Could you post...

Can you execute the stored procedure through SSMS? What error message do you get?

I never hard code a filter like that. You can use everything but the WHERE clause as the source for your report, and then pass the filter part in the...

Okay, let me try that again.

Since you're new... one thing that's extremely helpful to know is in Jeff Moden's article about how to ask a question so that it gets...

• This reply was modified 4 years, 1 months ago by pietlinden.

I don't know, but the first place I would look is at Rob Sewell & Chrissy LeMaire's dbaTools (using PowerShell). I'd be surprised if it weren't built in.

Is this a for real question or a homework assignment?

You could import the data to another table, and join the two on ColumnA from your sheet and show the value...

running total of 1 divided by ROW_NUMBER() over some partition?  That's what the sequence {1, 0.5, 0.33, 0.25, 0.2} implies. Where's the problem? If you really had to, you could...

look up STRING_AGG()