You don't need a CTE. In this case, it would just add complexity for no real reason that I can see :-).

Sean Lange (7/22/2013)

---

Yes you can still do a wildcard search.

inner join #search...

Michael Valentine Jones (7/22/2013)The CASE expression will verify that the data string is in YYYY-MM-DD format, and is a valid date. It will return a 1 if the date...

Something like this should be very close at least, I think:

create proc pSearch

@searchparam varchar(400) -- values will be entered like this - seperated by comma: John, Mary, 23.10.1980

as

set @searchparam...

chrissorric (7/17/2013)Thanks for all the help!

This is what I finally came up with

SELECTp.OrderNum

FROM@Orders AS p

INNER JOIN@Results AS x ON x.LabNum = p.LabNum

GROUP BYp.OrderNum

HAVING SUM(Case when x.Flag = 'N'THEN 1...

If the first date is greater than the second date, you will get a negative value.

If you want to treat all date differences as positive, add ABS() function around the...

If you can, instead just truncate the old table, then re-insert only the kept rows.

I would never have them run their own BACKUP command.

You need to have them call a stored proc so that you can add/override all options necessary to the BACKUP; for...

For a very small number of immediate changes, it's ok. But close the window immediately after the changes. If you let it hang open, you might cause issues...

Not much to go on, but probably something like this:

SELECT ...

FROM (

SELECT

...,

...

OK, so:

datetime_column < DATEADD(YEAR, -2, DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0))

Just capture value of the RecordID that you just modified in the calling code, and pass it into the code to be dynamically executed:

@query = 'DECLARE @RecordID AS Varchar(12)

SET @RecordID...

In general, as below. But, if the column is not datetime, CAST the date calc to the exact datetime of the column. For example, if the column is...

dspink (7/15/2013)

---

Also any thoughts on this approach?

Select * INTO T1_Obfuscated FROM T1. (obfuscating only columns needed.) then dropping T1 and renaming T1_Obfuscated to T1. Not really too worried about space...

Sean Lange (7/15/2013)

---

Many of the things you listed as possibilities are likely to help but probably the biggest performance woe is calling the same scalar function 11 times for 250...