Hmm, interesting. SQL's still "dumber" than I thought :-).

We'll need to UNION the query results instead of using "OR".

Also, as always, we want the variable to be exactly the...

You might want to allow for no comma being in the string (just in case).

And you can remove some unnecessary elements from the code:

SELECT CAST(LEFT(@buyer, CHARINDEX(',', @buyer + ',') -...

You don't need separate indexes on StartDateTime and EndDateTime, you need them in the same index.

SQL will only be able to do a seek on that index if it's headed...

Stefan_G (8/9/2013)

Unfortunately your code will read all data for all invoices from 1 year...

Here's my version of it. I delayed the lookup of CustomerName to avoid having to GROUP on it -- GROUP BY is an especially expensive operation on varchar columns.

I...

That might be the problem. Detaching a db in SQL...

I prefer a "template" approach. I find it much easier to write, follow and maintain. For example:

DECLARE @backupcommand_template varchar(8000)

DECLARE @backupcommand varchar(8000)

SET @backupcommand_template = '

BACKUP DATABASE [$db$]

TO DISK =...

Do you really need only the TestId column in the result set? You don't all the columns?

If you start a single transaction before the loop begins (or, more awkwardly, only on the first loop), then any rollback will rollback all activity for that transaction. If...

CTEs do not do that, from what I've seen looking at query plans. Instead, SQL re-runs the entire query every time you refer to the CTE.

For the most performance...

Yes, it's possible; I've done it several times. In fact, you don't even have to pass in the db name -- the proc will automatically run in the current...

You shouldn't do a full count of the table for that either, btw; use...

mister.magoo (8/5/2013)

---

Amy.G (8/5/2013)

---

I am creating a table by using the

SELECT column1, column2

INTO NewTable

FROM OldTable

method. Is there a way of creating a table in this manner and saying if the columns...

Agreed, a trigger is not at all the best place for this type of thing.

RECONFIGURE is not allowed to be part of a transaction. A modification trigger is inherently...

The function below will return the job_id when you pass in the string with the "Job 0x...." (I've since discovered a perhaps better way, but can't find that code right...