Lamprey13 (7/21/2009)

---

Something quick and dirty might be the SOUNDX or DIFFERENCE functions.

If you are looking for something better do a search for "sql fuzzy match" There are bunches of articles...

What is the data type of the AMOUNT column?

Could it be a MONEY datatype that you are stripping the last 2 digits from to show with 2 decimal places?

Do it this way to get the date in decending order within amount.

ORDER BY

AMOUNT DESC,

...

The date looks OK to me. Why do you think the date is "messed up".

It would be helpful if you could explain the actual requirement that you are trying to meet.

Why no just use BACKUP and RESTORE to make a copy of the database?

It will create an exact copy of all database objects and files.

Lynn Pettis (7/20/2009)

---

I also need to ask a question, what about leaplings? If some one is born on February 29th, when do you need to consider them a year...

The logic for Age in this select statment shows a simple way to do it.

declare @date_of_birth datetime

set @date_of_birth = '19770801'

select

...

Isn't that a SQL Server 2008 feature?

Still seems to have a problem with the first tab being indented differently (see below).

Also, can it be fixed so that blank lines show?

select

col1,

col2

from

MyTable

select

col3,

col4

from

MyTable

If you can't reach the other site, maybe you can reach this one at Tara Kizer's blog:

Defragmenting/Rebuilding Indexes in SQL Server 2005

http://weblogs.sqlteam.com/tarad/archive/2009/06/23/DefragmentingRebuilding-Indexes-in-SQL-Server-2005.aspx

Sample restore command with backup on network share:

restore database MyDatabase

from disk =

'\\MyServer\MyBackupShare\MyDatabase_db_200907160525.BAK'

with

move 'SYS' ...

I am not sure that I understand what you are after.

You said that you have identified that fastest form of the query already, so what is it you need?

This works with all versions of SQL to look at the code for stored procedures, functions, and views:

exec sp_helptext 'MyProcedureName'

I think that the primary value is in the discussion, so I am only interested in sites where there is open discussion. Let people post their opinions, disagree, say...