If you query the Catalog table where the content field is null, the Type field, at least on my server, is always 1.

This indicates that it's a folder.

How about this:

SELECT

C.[Path] as [Report Location], C.name as [Report Name], EL.UserName as [User Name], COUNT(EL.TimeStart) as [Number of Runs], MIN(TimeStart) as [First Run],

MAX(TimeEnd) as [Last Run]

FROM...

Huh?

What is the reason to have to do something if it is an integer, and something else if it is not an integer?

Is the data type of...

Can I get in????

michanne (6/20/2011)

---

Hi there,

I am trying to export some xml data from sql server via sqlps. I want it to run in a sql agent job. The xml is generated from...

Steve finished my thought.

Try to plan ahead. Most entities in a database follow a "pattern" of logical roles. For example, the marketing people probably do not need...

It may be a bit cleaner to add (or create) the Active Directory group that corresponds to the purchasing department to SQL Server, and grant execute to the group as...

I will sound rude, but anyone who calls themselves a DBA and actually recommends NOLOCK is not really a DBA.

It helps with contention? How about designing good schema and...

GSquared (4/27/2011)

---

Peter Trast (4/27/2011)

---

GSquared (4/27/2011)

---

Richard Warr (4/27/2011)

---

Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the...

For starters, a 29 GB log file for a 60Gb database, considering all of the transactions that are occurring during your refresh, is not "enormous".

Bulk logged does not always...

DDL is "Data Definition Language" Or, in other words, the actual schema of the tables.

There is a wealth of info on this site. Books On Line is my...

This query is long, but the logic makes sense. It appears that you have the logic, but this isn't T-SQL code. The CASE statements are syntactically correct, but that's about...

My advice to you is to drink heavily!!

I found my self in an almost identical situation. In this case, the floats were a result of the PM using the...

Your sample data makes it tough, but here is my shot at it:

SELECT

CASE WHEN T1.BUTY = 'AD' THEN REPLACE(T1.SUBTYPE, 'EQUIPMENT P&L', 'OTHER DIRECT COSTS ')

...

When you say replication, do you mean repeated rows?

You...