How could I incorporate this into a report?

Can I add this to the bottom of the query?

IF OBJECT_ID('tempdb..#source_table', 'U') IS NOT NULL DROP TABLE #source_table;
IF OBJECT_ID('tempdb..##new_table', 'U')...

• This reply was modified 5 months, 2 weeks ago by Ken at work.

if a global temp table works, that would be fantastic.  When, how does a global temp table get dropped.

P.S. I'm thinking of putting this code into a report, which can...

You could probably use TRIGGER_NESTLEVEL to do that.

I tend to use session context values instead, set via sys.sp_set_session_context and SESSION_CONTEXT(N'<key_name>').  If you want more info on this method,...

I will say you've give me a lot to read and think about.

Thanks,

Let me try this in sql. I think this should work fine.

Thanks,

Awesome, that worked perfect

What would I like to accomplish? I would like a single result set that shows all employees and the Start and End dates of their time off:

Column A: EE

Column B:...

• This reply was modified 4 years, 11 months ago by Ken at work.

This is how the data is stored in the system. There is no start or end date in the system. Any actual day off is recorded in a row separately....

The code in the report worked awesome. Thanks. But I did run into a problem since it had more that one group. My fault, I left it out. I like...

The TSQL didn't work.  The report can't do a double aggregate like Sum(Last()).

You're code is awesome for testing. I should have thought of this. My fingers are crossed and I'm...

You're right, and I do apologize. I'm a little confused as to how to ask what I need.  I'll see if I can get some data, but first how about...

The example I get is horrible, I should redo the thread.  Sorry about that. Let me try this.

This is closer to what I want. In yellow I...