I'd see if you can't do it with PowerShell.  Rob Sewell & Chrissy LeMaire may well have that in their dbatools library. I'd look at that first, or ask them...

Phil,

If you want, I can DM you a few receipts in PDF form (I'll have to change the extension, but ...), and you can if you wish, if only for...

Phil,

thanks for looking at it. The good thing is that since it's a bakery, he only buys a small number of different ingredients, so entering them by hand won't be...

Something like this should work:

SELECT g.ID,
StartTime = MAX(IIF(rn=1,Game_time,null)),
EndTime = MAX(IIF(rn=2,Game_time,null))
FROM
(SELECT Game_time, ID, ROW_NUMBER() OVER (PARTITION BY ID ORDER BY Game_Time) AS rn
FROM Game) g
GROUP BY g.ID

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 3 years, 7 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 3 years, 7 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...