Not normally... of course, there are always exceptions.

Most results will be taking a present value from a previous value grouped by a name and show the result eg.

Smith 1/1/2008 ...

Yes... look for "Configuration Management".

Create a datawarehouse environment on your development server? Buy a copy of SQL Server Developer's Edition and install on you home PC? Take a course?

The definition of leap years changed many times and leap years didn't always exist. In fact, depending on which country you're talking about, leap year definitions were different for...

Heh.... Just like SQL allows itself to take any form... or Java... or...

Yes... there are... just setting recovery model to SIMPLE doesn't stop logging for loading of data. You have to use BCP or BULK INSERT or SELECT/INTO and your target...

Agreed... guess I need to wipe some of the egg off my face. DOB columns would be an appropriate place to use DATE only (although I don't know if...

Lynn Pettis (3/10/2008)

---

And it wasn't that I gave up too early; we had a workable solution, and there were many other things I needed to work on that were considered...

Giving away a fine "secret" here, but no one's ever heard of temporary stored procedures? Build it using dynamic SQL... execute it... it's all in the same scope that...

Jack Corbett (3/10/2008)

---

I like to use between when doing date ranges, I just think it is easier to read. I would use DateAdd(SS, -1, DateAdd(YY, 1, Convert(datetime, @year))) to...

Would be a heck of a lot faster if you used a holiday table or, better yet, a calendar table.

Bob Fazio (3/7/2008)

---

using the following;

;WITH table1(col1) AS (

SELECT objects.[object_id] FROM sys.objects

)

SELECT DISTINCT TOP(2000) Table1.col1,Table2.col1,Table3.col1

FROM table1,table1 TABLE2,table1 table3

ORDER BY table3.col1

-- option(force order)

The above comes back...

It's also unfortunately due to the fact that it's substantially easier to get "certified" as a Microsoft DBA than it is in Oracle. You therefore have a lot larger...

I had a dog like Matt's... the only way to get her to take meds was with a small enough piece of steak for her to swallow in one gulp......