First, is there a reason why you could get the source to stop doing this. Second if any one of those fields must have data in it you could just...

The problem is B does not exist in the data source. You can however do it like so.

SELECT A, B,

C = Case B

When 'Female' Then 'Woman'

Else

'Man'

FROM (Select A,

B...

When you do xp_cmdshell it shells out to the server you are attached to and the file will be exported there. You have to open a CMD prompt on you...

Not sure, most likely paid Microsoft so the backup hooks or are hooking some API to get to the database. If I come across anything I will pass it on.

"Don't...

You may need to do it thru QA code by doing an

ALTER TRIGGER "tblCustomerName_DTrig" ON dbo.tblCustomerName FOR DELETE AS

SET NOCOUNT ON

/* * CASCADE DELETES TO 'tblCustomerChallenge' */

DELETE tblCustomerChallenge FROM deleted,...

Your request is confusing. Can you be more specific about what you mean. First it sounded like you wanted ther date of the last time the database was resotred. But...

In truth no, except that they execute immediately one after the other. They should ahve the exacte same execution time as doing seperately but you have to keep in mind...

Do a file backup to the local drive system or a remote drive.

BACKUP DATABASE [dbnamehere]

TO DISK = 'D:\Backups\Backup1.dat'

WITH

INIT,

NAME = 'Database Full Backup'

Just fill your information in then restore to the...

Let us know what happens?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

You will not be able to group by as the data varies, a piivot table won't work here and you cannot join to self enough to cover every possiblity.

However this...

So far this has never failed me and cleans up a number of issues with databases when adjusting size (especially drastic changes). Note: large databases take a while, generally.

--Truncate Log...

Maybe I am missing something, can you post an example of what you get as the output. Also please post the table DDL so I can see what happens here...

Who knows why sometimes things do this. Great to hear it's working.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Try

Select name, date, dept from table

where

(date between '2/2/02' and '2/4/02')

and dept = 'red'

You should always put between statements in () to make sure parses correctly.

"Don't roll your eyes at me....

One way is to run

for Single DB

select [name] from sysobjects where xtype = 'P' and base_schema_ver != 16 order by [name]

for All DB

sp_MSFOrEachDB 'select ''?'' AS DB , [name]...