Would you show the last check or the first check; By check date or by number?

Mentoring seems to be the theme of the day. I just received an e-mail from a company on mentoring.

If any of you received the same e-mail should we be...

This should do the trick.

SELECT

p.employee,

p.first_name,

p.last_name,

d.description,

b.expired_date,

u1.description,

u2.description,

u3.description

FROM

person p

left join badge b on b.person_id = p.id

left join department d on d.id = p.department

left join person_user u1 on...

Sounds like a great program!

Nope that would require something a bit more ocmplicated. Before we could begin to answer that though could you explain how the information is stored in person_user. What...

assuming this is what you mean you can change the = to an IN. so something like this.

SELECT

p.employee,

p.first_name,

p.last_name,

d.description,

b.expired_date,

u.description

FROM person p

left join badge b on b.person_id...

in all of your subqueries you are summing by CHRG1.CHRG_BAL and you include CHRG1.CHRG_BAL in your group by cluase. The column you are summing should not be in the...

I reformated the code for you for readability but I have a couple questions. What do you mean when you say you only want the ins companies. What...

The following would return all folders in report manager

use ReportServer

go

select * from dbo.Catalog where Type=5

The problem is that people tend to look through information with a filter on these days. They ignore anything that is not part of there accepted reality. One...

In that case the way you have demonstrated is the way I would likely do it unless we are talking about an enourmous amount of data. In that case...

What would be the reason for not wanting to use <>'A' That would certainly the most direct.

I am not sure I understand the distinction between the employee and the record level.

I still think a trigger might be the better way to go. When an update is made in staging you could handle that anyway you need to. weather...

Since these changes are based on Insert/update/delete have you thought about doing this with triggers rather than and SSIS. doing this with triggers would mean the update would happen...