What is...

This works OK for me.

select

datediff( m, CHARDATE, '20090630' ), *

from

dbo.ComputeScalarProblem

where

...

At a former job, I requested purchasing to find me a chair that was built to take a lot more abuse because I had managed to wear out 2 chairs...

You can use the ROBOCOPY command in a job to mirror the backup directory to another server.

ROBOCOPY is a command line tool available as part of the Windows Server 2003...

It is possible to do a cursor loop with only a single fetch:

declare Cur_Cursor cursor local

for

select

MyData

from

...

Can you explain what you are trying to do? Are you trying to add leading zeros or remove leading zeros?

Just take the database offline before starting the restore:

use master

alter database MyDatabase set offline with rollback immediate

You can just raise an error in the CATCH block.

Lynn Pettis (7/23/2009)

---

You don't here on SSC. Many in this community believe that...

Service_Tag like

'[0-9A-HJ-NP-Z][0-9A-HJ-NP-Z][0-9A-HJ-NP-Z][0-9A-HJ-NP-Z][0-9A-HJ-NP-Z][0-9A-HJ-NP-Z][0-9A-HJ-NP-Z]'

Run the script on the link below to see how much used and free space you have in each database file, and to see how much space is used by...

This is a farily simple method:

declare @files table (cmdout nvarchar(100) )

insert into @files ( cmdout )

-- Get filenames excluding directories

exec master.dbo.xp_cmdshell 'dir C:\ /b /a:-d'

select cmdout from @files where cmdout...

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,

...