Frank,

That sort of helps, but doesn't. The output sample at the top of the post doesn't match the sample data at the bottom. I am a visual type...

Not sure where you are looking in BOL, but my local copy matches the version at Microsoft, and it clearly discusses 5 system databases, including the Resource Database (mssqlsystemresource.mdf/mssqlsystemresource.ldf).

Here is...

Sugesh Kumar (2/4/2008)

---

you can't change collation at server level. but you can change the collation on particular columns. also changing collation on the database only makes the collation effective for...

True, the Resource database is not listed in sys.databases; however, the documentation does refer to it as a special, read-only database that must be located in the same directory as...

As far as I know, you can't turn it off.

😎

Actually, I'm still waiting for more information since the four date fields are in four seperate tables. BDate is in TableB, CDate is in TableC, and DDate is in...

NEI (Not Enough Information). Still don't know what you are trying to accomplish, plus the code I see just looks wrong from the get go. Plus, you have...

Rhetorical question on your part? A good answer would be this: T-SQL is SET based while the other languages you mention (even if OO) are procedural. Many...

First, only partial code in your post, so not a real help. Second, why do you need to create a cursor dynamically? What are you try to accomplish?

😎

I'd also be interested in seeing enough of the tables DDL, some sample data, and expected results so I could understand the query as well. Looks like you have...

Marvin,

No problem. I didn't even notice the error in the code itself. I just thought I'd help fix it to give the first of the month.

😎

MD (5/7/2008)

---

I'd put it in function and then pass the function the three date values

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[ufn_MaxDate] (@DateA DATETIME, @DateB DATETIME, @DateC DATETIME)

RETURNS DATETIME

BEGIN

DECLARE @ReturnDate DATETIME,

BEGIN

...

Just a problem with some people not reading the entire question. The question did specifically state SQL Server 2005.

Good question, everything specified to be able to make an educated...

Would you please provide a little more detail into what you are doing? Specifically, how are the four tables related (just need enough of the DDL to understand the...

Just another view of the example above. I added a count(n) to show the difference between count(*) and count(column_name).

select

count(*) as theCount,

count(n) as theOtherCount,

avg(n)...