Is this what you want for the counter?

WITH ResolutionCTE (order_no, cntr)

AS

(

SELECT order_no, MAX(COUNTER) 'cntr'

FROM abcd

GROUP BY order_no

)

SELECT emp, COUNT(*)

FROM abcd a

INNER JOIN ResolutionCTE r

...

I'm saying you need 3 queries, not 2, to join together. One for each requirement, then one to pull them together.

I don't understand what the 0 or 1 are in...

RESTORE HEADERONLY also grabs the LSN. Those are linked together.

If you use the GUI and do it on the same machine, the backups are stored. If you are doing this...

I tend to do the backup and restore as well. The Copy Database task was flaky in 2000 and I never trusted it in 2005. Not sure you gain anything...

We have debated that here, and might. It's a somewhat long process to get it well integrated, and likely we'd want to scale our points up in other areas as...

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.