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...

SELECT IP.IPCode, MAX(AllSubtables.UpdateDate) AS LastUpdateDate

FROM SAMPLE.IP IP

INNER JOIN (

SELECT IPCode, MAX(UpdateDate) AS UpdateDate FROM SAMPLE.IP IP2 GROUP BY IP2.IPCode

UNION ALL

SELECT IPCode, MAX(UpdateDate) AS UpdateDate FROM SAMPLE.AddressProfile AP GROUP BY AP.IPCode

UNION...

SELECT CASE WHEN Total_Rows = Active_Rows THEN 'Valid' ELSE 'Invalid' END AS Status

FROM (

SELECT

SUM(1) AS Total_Rows,

...

Welsh Corgi (6/24/2013)

---

Thanks for the help guys.

I'm using the Data calculation in the WHERE Clause.

WHERE Effective_Date < CONVERT(DATE, DateAdd(yy, - 5, GetDate()));

Does it matter which method I use as far...