We'll never forgive you! You are eternally beyond...

So, what you need is a list of the dates that immediately follow a PA, whether they are EN or not?

That's easy enough. Just select all the PAs, and...

C# will get you more "resume opportunities", because it's got more egos attached to it that think it's a superior language. Since both go through the CLR JIT compiler,...

I've used mine for a lot of productivity increases, without increasing hours.

I can answer e-mails while not at my desk, which doesn't equate to "at home", and so on.

Cross join to a table with the number of rows equal to the number of repetitions you need. Numbers tables are useful for that.

I'm not sure if it's a typo or an actual error, but you partition by col2 twice in your CTE.

I'm also not sure what you mean about an update producing...

Are you familiar with writing inline subqueries?

Would look something like this:

select *,

(select min([DATE])

from dbo.MyTable as MT2

where [DATE] > MyTable.[DATE]

and (ST = 'PA'...

They won't normally fail on warnings like that. I'd suspect a permissions issue, with a difference between the account using BIDS and the account the job belongs to in...

I covered hierarchies of a couple of types in http://www.sqlservercentral.com/articles/T-SQL/65540/.

Personally, with what you've described, I'd probably go with nested sets. The only thing they don't do well is frequent...

Normalization makes for faster updates. Denormalization can, in some cases, make for faster selects, if it's done correctly. That's really oversimplified, but if you want a more complete...

GilaMonster (11/19/2010)

---

Oh for crying out loud...

Conversation from 5 min ago.

PM: We agreed that you'd start the investigation for <really complex and possibly impossible data extrapolation> on Monday. Is there any...

The Dixie Flatline (11/18/2010)

---

GilaMonster (11/18/2010)

---

CirquedeSQLeil (11/17/2010)

---

I love finding out that a project has a dependency on a task assigned to you - when everything else is done and ready to...

Per this, SQL isn't installed:

hydbadrose (11/18/2010)

---

Sql engine is not installed. There are no sql services such as MS sql server, or sql agent. The client tool has been installed...

You're welcome.

First, I sincerely hope you aren't talking about credit card numbers. Whatever you do, don't store those unencrypted! Again, DON'T store credit card numbers in plain-text. If...