Neat solution! Thanks 🙂

Hi,

what about a set based solution? It'll run faster and scale better. This code courtesy of Jeff http://www.sqlservercentral.com/articles/T-SQL/62867/

We'll need a tally table for this so, set one up:

...

ajaykshanker,

Nor will you be able to search for names with spaces.

What about diacritics? e.g. â, ã, ä, å, æ

Regarding SQL injection, what about carriage returns/line feeds/tabs?

Can I search for "O'Neil"?

Can I search "';drop table dbo.Contacts;"?

Have you thought about full text index?

Hi there,

check out Server Generate SQL Server Scripts Wizard — http://msdn.microsoft.com/en-us/library/ms181421.aspx

Hello,

It looks as if it should be a fairly easy solution, but without some table structures and some sample data it is difficult to help! See http://www.sqlservercentral.com/articles/Best+Practices/61537/ on...

Heh heh... np Jeff, any time, probs gonna be the only time I beat you to it... plugging one of your solutions!

@kramaswamy, your solution is based upon pivots,...

for the static (i.e. all column names for output are know in advance) see http://www.sqlservercentral.com/articles/T-SQL/63681/ — this article also compares pivot solution with cross-tab — cross-tabs are easier to read/maintain...

No problem Dan, glad I could help.

Allister

If no one else is relying on data in AuditTrail, and you have it backed up, you could consider a truncate on the table (http://msdn.microsoft.com/en-us/library/ms177570.aspx).

However, it concerns me...

Hi Dan,

It could be, without more details I can't be sure.

Is there anyone else involved with this project, or are you on your own on this?

Also are you sure the...

Hi there,

Any chance you could post table structures with some sample data and your expected results?

Here is a very useful article on how to post this information: http://www.sqlservercentral.com/articles/Best+Practices/61537/

///edited typo

Before doing a delete I often find it useful to do a select with the same where clause first so SELECT TOP 100 * FROM AuditTrail WHERE TimeStamp <= '2009/3/23'...

Hey Dan,

I had made the assumption that AuditTrail would have some timestamp column?

If this is the case then it'll be pretty easy DELETE FROM AuditTrail WHERE TimeStamp <= @YourChosenDate

If no...

Hi Dan,

the information logged in the AuditTrail table will be being logged by your web application, it really depends how many places in the code base that this is being...