Thanks for the feedback. The original table had an unnecessary join which the new query eliminates, and if you can remove the DISTINCT now, then you remove a memory-hogging SORT...

dwain.c (8/29/2012)

---

RBarryYoung (8/29/2012)

---

Unless the queries all strictly follow the same very simple format, this is going to fall somewhere between "Impossible" and "Incredibly Hard" to do in SQL.

If the queries...

Pick a chunk of the query at the bottom of your stored procedure, run it in a query window with a couple of sensible parameters, and have a look at...

Numeric datatypes are inappropriate because telephone numbers may have embedded spaces, non-numeric characters and leading zero's. Length isn't constant either, so most folks use VARCHAR.

You're welcome jd, thanks for the feedback.

Try putting the FOR XML PATH stringinator into a CROSS APPLY, where it can crunch up the rows of PSFDOC separately from the rest of the query. You might not...

Larry Kruse (8/29/2012)

---

I have a problem with performance of a query embedded in some 3rd party software.

The query (see below) performs a select of some fields on one server WHERE...

The stored procedure returns the result set you want - why complicate it (and double the execution time)?

You may have simplified things a little to help - in which case,...

Edit: dog removed from pile.

It refers to "fields" too - and took me ages to call them "columns" when I moved...

dwain.c (8/29/2012)

---

ChrisM@Work (8/29/2012)

---

-- casting GETDATE as INT gives different results before and after midday ...

-- casting GETDATE as INT gives different results before and after midday

SELECT...

walidkilani (8/29/2012)

---

1. Query the USESSION table for the users 'session_id':

select session_id from USESSION where delete_session_id is NULL and user_id = (select user_id from users where...

dwain.c (8/29/2012)

---

Mark-101232 (8/29/2012)

---

If you're willing to jump through a load of hoops, you can update both tables with a view

CREATE TABLE ABC (Id INT NOT NULL , Name VARCHAR(10), Tab...

dwain.c (8/29/2012)

---

Yeah, so now what I haven't tested it with is:

Since you can use both OUTPUT and OUTPUT INTO within the same INSERT, UPDATE, DELETE or MERGE, can you also...