check out DATEDIFF on books online

With your restrictions the only thing you may be able to do is to modify the <SprocName> stored procedure to work with rowset operations (inner joins to your list table),...

xp_cmdshell opens a new console using the Windows account used by SQL Server service. Your Windows account has access to that remote folder; the SQL Server service account may not.

This may not be the problem with your query, but it is an incorrect assumption from your part if I understood it correctly. DISTINCT applies to all the columns in...

I tried it on one of our databases and it did not work. I got an error. This was on a SQL 2008 server.

The only thing I would think off,...

daniell-1020276 (11/5/2009)

---

I tried to get an execution plan for the problematic query.

However, once the "IP" field is mentioned in the query I can not get an execution plan for the...

Is that 4 billion records?!

Without having a clue about the data I would think that [Query] column would have a smaller number of distinct values (how different can be [Query]...

Interesting article, but I do not think the proposed solution will cure the "lazy developer" syndrome. That's because the real problem are bad development practices, not the SELECT *...

I am not sure what you are trying to do, but the problem may be with your IF structures. When you write:

if (@j = 4)

set @project_no = 'ME93'

set @job =...

Try using "OPTIMIZE FOR" query hint. As mentioned before, it seems to be a parameter sniffing issue. When using variables instead of scalar values, SQL query engine is not using...

Invoices table would need an OrderID column, foreign key to Orders.OrderID. Otherwise, how do you know what are you billing for?

I would not put CustomerID and AddressID on the Invoices...

From current experience in my workplace: sometimes developers use third-party libraries like iBatis or NHibernate for Object Model - Relational Database mappings. Maybe these libraries are forcing the developer to...

meichner (10/15/2009)

---

Al-279884 (10/15/2009)

---

John Rowan (10/15/2009)

---

Yep, it makes sense. I'm not sure if that's how I'd design it, but it is what it is. My personal preference would be...

John Rowan (10/15/2009)

---

Yep, it makes sense. I'm not sure if that's how I'd design it, but it is what it is. My personal preference would be to have...

meichner (10/15/2009)

---

John Rowan (10/15/2009)

---

That's fair. I think we need more info then from the OP as to how the addresses are currently being related to other entities.

meichner,

Care to...