Another useful query for a Calendar table is future business days. (This version only works in SQL 2005 or later.)

;with FutureBusiness (Date, Days) as

(select Date, row_number() over (order by...

Jeff's more of an uncommon table expression...

The easiest, fastest and most accurate way to accomplish this is with a Calendar table.

The simplest version of this is:

create table dbo.Calendar (

Date datetime not null primary key,

constraint CK_DateOnly check...

I use ApexSQL Diff for that. RedGate has a product for it too.

I'm not sure what you're asking.

I would like to point out that memorizing the answers to some probable interview questions is probably a good way to get job that you can't do and will be...

Nah. He's just recursive. Not hierarchical. One's a potential subset of the other.

MarkusB (2/3/2009)

---

scott_lotus (2/3/2009)

---

thanks again for the reply.

So whats the difference between LOG SHIPPING and TRANSACTIONAL REPLICATION then if both use the transaction log to keep the second database up to...

In the case where it's one parameter works and the other fails, and that's consistent, then it's gotta be something like the size of the result set. Or latency....

Look up Jeff Moden's article on Running Totals (on this site). Should be able to use that for what you need.

Any thread that stays on-topic for more than five posts is usually a flame anyway. 🙂 (Check out some of the threads we've had for Question of the Day...

Nah. Don't drop this thread. And not because of "points". The entertainment value has been just too high.

If any job the agent is running hits tempdb, and doesn't close its connection or some such, then yeah, it could cause a problem.

If, for example, you have some ETL...

This sounds like an interview/test question. Is it?

Go for it. Might take more than a quarter, so don't be disappointed if you aren't up to Jeff Moden's or Gail's skill level by that time.