Nope. Gotta have that in there.

Of course, it's actually a best-practice to qualify all your objects that way. Makes your database run slightly faster.

It sounds to me like you're on the right path.

I got into databases from a background in sales and marketing, and an education in management and executive function. (It's...

The company I currently work for had a similar situation till I got here.

There was actually no admin on the databases other than automatically scheduled backups. No re-indexing, no/very...

I tend to suspect that the reason for the difference in results is that getdate() includes the time of day, while the dates you manually typed in were both midnight.

If,...

I get the same results as Matt.

Also tried it without the Order By, and it still kept the result you're looking for in the 4th row.

Jamie Longstreet (2/7/2008)

---

Ah, can we lobby for points? [Sounds like going to court for a traffic ticket cuz ya know the officer won't be there.] Stupid Interviewer...

Never mind. Managed to get a hold of a copy of Enterprise Manager. Good to go!

LOL!!

Also on Tony's function, unless you're planning on going over 2-billion (American billion), don't use BigInt. Int is good up to 2,147,483,647 per BOL. Making it BigInt just...

Matt Miller (2/7/2008)

---

Jim Russell (2/7/2008)

---

"Whilst you may know how they join, an end-user making a simple report has a much easier time if the joins are already defined for them."

Tell...

I think my response would be in terms of "I'm pretty sure that XML wasn't a data type in SQL 2000" (or whatever was being asserted). Then, hopefully, the...

You are correct, Gail. You can use all of those.

I think the author of this question didn't really pay attention to what he was asking. (Harsh, sorry, but true.)

The "Using" clause includes new data to be both inserted...

If you use the string parser function from Adam's post (I seem to recognize it from somewhere), and use the Cross Apply capabilities of SQL 2005, you can do the...

Yes, Reporting Services could do this, with a cross-tab report.