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

If I include it as a sub report it only shows the first employee because the parameter expression is =First(Fields!Employee.Value, "Employee").  If I take out the first I get an...

I'm not sure how to combine two different types of tables into one. How do I force a page break on employee? Since they are two separate tables the results...

Awesome, Cross Join with Union All worked perfect.

Thank you,

• This reply was modified 5 years, 1 month ago by  Ken at work.

Thanks but I can do the T-SQL. I'll just do that.

I'm fairly sure we haven't add anything to our SQL Server yet.  I'll look this over, but I think I need to do that first. Oops, wrong forum.