It feels like to me there is something jacked up in your aliases. I'm not sure off hand, if you want to review it there's an article at the bottom...

Visual Source Safe is a functional product that we use. I'm not a huge fan of this particular code repository; however, it does work. If you can splurge a little...

I would suggest studying for both of the exams, but maybe only taking / focusing on BI. A solid understanding of querying in SQL Server will go a long way....

What kind of data source are you pulling from using open row?

Are you familiar with powershell?

It's microsofts scripting utility, and it has the ability to ping servers. Here's a script that will allow you to ping a list of servers. I...

I agree on some level with the article; however, there are always situations where things get complicated. One time, I was working and I made my boss aware of...

Do you have any indexes on the tables?

I think you've got it... becareful with sendmail though, you want to test that before you push it to production, people get real angry when 500 emails come through from...

Awesome example, I was working on a response and when I saw your response I felt a little bit like an idot without the savant. 🙂

You are 100% right... however, when in rome?

[\ code] (Without the spaces)

I'm looking at your problem too... I can't see anything that's wrong with Lowell's statement... maybe i'm blind.

I'm curious, why the nested distinct clauses?

I would love to help you; can you post the table create statements.

I assume a solution would be:

Select Distinct EmpID from Emp1

UNION

Select Distinct EmpID from Emp2

UNION

Select Distinct EmpID from...

We always stick to mixed mode authentication, it's a company policy.

Hey,

Give this a shot.

The temp table #report contains the months that you need i.e. you insert the last 10 months. The query uses a subselect to lookup the relevant...