Sorry, reattach it.

Thanks

I attached the sample data. So far we only consider school year 2016.

Also my question is a little different from previous post, donot want to make confusion, so start a new one.

I will create some sample data

Yes , that was posted by me.

But I donot like to use recursive CTE, it is slow.

And I wonder if there are any other suggestions.

Thanks

Here is the table...

Thank you very much, very helpful, I will give a try

Thank you, that worked, the trick like you said just enter the login without search in AD.

Thanks,

Also would like to ask how to identify the SQL server is Kerberos authentication,...

Thanks,

One other question related to this, I have a SSIS package that export data from this local server that has MSA account to another SQL server.

I need to add...

Sorry, I saw in job activity monitor and see next run not scheduled. what I should look is the Scheduled column.

For next run we temporarily disabled it for the period...

Thank you!

So the article says Kerberos Constrained Delegation, what does constrained mean, is it special?

Can the managed service account be shared on another computer? for example can it...

A further question, if function are not worked efficiently, why T_SQL has this table valued functions?

In which case we should create functions?

I can think of is for calculation, parse, and...

Have you considered alternatives such as simplifying the check? One option when checking if multiple columns in the same table have values is to multiply the data length of those...

GilaMonster (11/5/2016)

Often in SQL, 'reusable code' = 'slow code'

Have you...

Yes it is a inline table valued function, not multiple statement function

Thanks. Because it will be used in several places , so other developer request to create a function for reuse

Right now I don'thave a school calendar table. But the TruantDay table covers that, it will only have current school year data.

I would like to modify above query a...