I think you have two queries here. You want a count by employee, but then the last employee based on order. Is that right? Seems like you are pulling together...

What's "last". You don't show an ordering column. Or do you mean the counter column denotes which one is last? Is it the max value?

I always thought Steinbrennar was a PIA, but no denying he wanted to win and was happy to spend money to do so.

RIP.

The questions are not stupid, but it appears that you're asking about things without really doing much research, or you're making leaps that don't make sense. Why would you look...

I'm not sure what the last column in your output means.

Also, we are happy to help, but we shouldn't be doing all the work. You should attempt to run a...

What do you mean "first release"?

This applies to SQL Server 2008 RTM.

SQL Server 2008 R2 is a separate product. It is not a second release of SQL Server 2008. It...

I would do what Andrew has done. That's worked well for me.

One thing to be aware of is that you want the create table statements in the DTS (along...

You need to post it on the T-SQL Challenges site.

cold_blue (7/12/2010)

---

Hi Steve,

It's not feasible to run the package in both SSIS packages, it'll slow down the performance. It takes around 10-30mins to finish the package(for around 8k records)....

T-SQL Tuesday - Still time to enter.

blandry (7/13/2010)

---

...

Yes, techies are frothing at the mouth over cloud computing, but having attended two non-IT business seminars on it, few if any outside the techie-sphere are buying into it.

I...

Congrats!

Richard Gardner-291039 (7/13/2010)

---

The fundamental problem seems to be that when you're serving objects to thousands or millions of people you just can't afford the overhead of keeping track of each...

I tend to dislike "syntax error" questions since they are usually easily corrected. Double click the error, find the line, examine it.

However there are lots of people that don't seem...

TravisDBA (7/13/2010)

---

Private clouds require considerable upfront investment in both hardware and software, so they are not a good choice for small and medium sized companies operating currently under tight budgets...