Here's one that I tested using SQL 2005, so I couldn't use DATE as a field type, but I'm quite sure this would work in 2008, and there are no...

I think bitbucket's attempt will fall short whenever the same account number dials the same phone number once on one day, once the next, and then twice on another...

I think what the original poster actually needs here may be a computed column. If all the fields referenced are in the same table, then adding a computed...

Chris, I think you have that backwards. I'd state it like this:

That order by clause is effectively creating a new field for the entire set of data, where...

Based on the VB code you just supplied, this clearly indicates you have a tree structure in the XML that needs to be navigated to determine the appropriate result. ...

I'm not sure if there are any problems with disk defragmentation and SQL Server, but if there aren't, then I might consider tackling the disk fragmentation before the index defrag....

That's not quite the same as what the OP is looking for, at least based on my reading of it. What you appear to be looking for is...

Sounds like you have some metadata that qualifies to go right into the database next to the information itself, and some that might be more at the table level. ...

I don't think you could generalize a solution for metadata, as it depends an awful lot on what you intend to actually do with that information. Just saying...

You might want to look up UNPIVOT in BOL, which could be used similarly to the following:

;WITH CTE_SKILLS AS (

SELECT DISTINCT EMPLOYEE_ID, SKILL

FROM SKILL_TABLE

UNPIVOT(SKILL FOR SKILL_TYPE...

UPDATE: I found an article on Microsoft's website late yesterday afternoon that described my problem rather accurately, and although it referred to systems with Vista already installed, the basic...

Glad you have it working. Just be aware that items in the Page Header can't reference detail records - they can only reference aggregates for the fields. ...

I can't be sure, but it might be the "dd-mm-yyyy" portion of the format that's the problem. SQL Server defaults to mm-dd-yyyy, at least here in the...

I don't know if Reporting Services exists for SQL 2000, but if you can get to SQL 2005, it exists there, and it provides a subscription capability one can add...

If this is a recurring requirement, how about creating a report in Reporting Services, and then creating a subscription to it? If it's a one-time event, I'd say...