I deal with this by:

1) having a "template" generically named spreadsheet (c:\template\salesdata.xls),

2) copy it to a working file (c:\working\salesdata.xls),

3) populate the data via a transformation,

4) rename it to the saved...

Hi Ed,

Would you please post an example of your code.

Michael

Aho, Steve!

What you said was important to say, and I admire your courage to say it.

Michael

Excellent suggestion, Sarah,

I post to some forums which allow me to change the date format mask in my profiles. This is done via a text field so I have complete...

I think you are asking for the Transact-SQL syntax and that is in the help files in SQL Server Management Studio (and in Books Online: BOL).

I admit to being confused for first 12 days of each month with the US and ROW formats, so make that 2 votes from Canada for the Internalional format (yyyy-mm-dd),...

I am sure this is not the most elegant solution and...

I solved this with a SP which 1) inserts all my data (with a distinct key and the transaction date)...

Hi Irene,

Do you have permissions from your SQL system for C on serverXYZ? You may need assign them and/or share C.

I use the CMD window to prototype my DOS commands...

Also, I learned a lot about processing DOS directories from this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=96&messageid=7812

change:

execute master.dbo.xp_cmdshell 'dir C:\'

to:

execute master.dbo.xp_cmdshell 'dir F:\Archive_bds2'

How's about:

use ABC

EXEC sp_updatestats

GO

DECLARE @rtn int

EXEC @rtn = master.dbo.xp_sqlmaint N'-D ABC -WriteHistory -VrfyBackup -BkUpOnlyIfClean -CkDB -BkUpMedia DISK -BkUpDB C:\BackUpSql\ -DelBkUps 2DAYS'

IF @rtn = 0

print 'ABC Backed...

Hi,

I just created an export to text DTS (with 62 columns by using the "Export Data..." wizard, and the DTS works correctly.

Michael

I have been an IT professional since 1980, and as of 1998, a registered acupressure therapist. I have been doing work on my vision for the past 18 months and...

If you can't say the things you want, you'll want to say the things you can't.

(from a radio interview with a man who was illiterate until recently)