Wait, I have to solve a problem??? <g>

He's not a computer guy at all. And most of his computer-related work he does on his iPad. So unless I do something...

Sure. Just a minute. I attached a PDF. (I changed the extension to txt because this place doesn't like PDFs, so you'll have to change it back). The date and...

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

I'd look around and maybe ask Cathrine Wilhelmsen - she's a huge ADF fan and blogger. I'd swear she did a series of articles on it. If you're really stuck,...

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

Oh, okay, Gotcha. Something like this?

select backup_path
, LEFT(backup_path,CHARINDEX('\FULL\',backup_path,1) + LEN('FULL\'))
from #tbl_backup_path;

Which \?

Can you give an example of what you're trying to return? My mindreading skills are taking April Fool's Day off.

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