Sounds like a reasonable source of the...

Jeff, there's a reference to the location table in the Where clause, "WHERE t2.Location='PRK'".

Sharul, the first thing I'd do for performance, is get rid of the conversion functions in the...

Is this selecting from a really wide table, or is "HHContract200804" a view?

How many rows is it dealing with (how many in the table/tables, and how many are actually returned)?

Is...

If I understand what you're asking, you can use Management Studio to create a select statement for a table by right-clicking the table name, then "Script Table as", "SELECT to",...

Without that, it was trying to get the left -1 character of the column. Charindex returns 0 if the character isn't in the string, and then you're subtracting 1...

Without the table and proc, I'm kind of guessing here. I've seen this kind of problem before with views (or just plain selects) that are very, very wide, and...

I think MSDN has an article on this exact subject. Search in there, you'll probably find it.

Basically, to find the data in the column, you can cast it to...

Add:

and CHARINDEX('-',Q5) > 0

to your Where clause.

See if that gives you what you need.

Yes, it can be done. Take a look at the Pivot command in Books Online. That might have what you want.

If not, you can do something like this:

select...

Take a look at "bcp" in Books Online. That might have what you need.

Without having actual table structures, I'm guessing a bit here, but here's an idea:

;with FirstInvoice (CID, InvDate) as

(select customerid, min(invoicedate)

from dbo.invoices

group by customerid)

select *

from dbo.customers

inner join dbo.invoices

on customers.customerid...

Have you tried storing the RTF data as varbinary documents in the first place?

Don't push the performance button on this one.

The biggest concern I'd have with this is still the ability to move a database to another server when size, traffic, etc., justify...

troyehall (5/12/2008)

---

GSquared (5/12/2008)

---

Take a serious proofreading and copy editing aptitude test. I guarantee you will fail a number of the primary tests. Less than 1 person in 1000...

Your modification to the cursor should work in your case.