Strange. I've never written a query with parentheses on the select list.

As a matter of fact, I just tried it, and I got a syntax error. Here's what...

In SSIS, you would create a Data Flow Object, create a connection to the database and define its source as the proc, then a destination, which would be the spreadsheet....

Glad I could help.

Matt Miller (6/17/2008)

---

I've done something like that with DTS a few times. For better or worse - I found it easier to have DTS handle the importing of a...

One way to log them is to use the SQL Server Agent job properties. Under Notifications, you can have it write data to the Windows log. Is that...

It should be easy enough to do in DTS. I haven't done that (I have in SSIS), but I'm sure it can be done. I have done similar...

You can do that a couple of ways.

delete from dbo.Table1

where Path in

(select Path

from dbo.Table2)

delete from dbo.Table1

from dbo.Table1

inner join dbo.Table2

on Table1.Path = Table2.Path

I'm not familiar with C#, but I bet there's something in it comparable to the VB "SQLConnection" object. If you can find something like that, that should do it...

I'm not sure I'm following your requirements correctly, but it looks like something that could be done with a modified running total query. There's an article about how to...

create database MyDB

on primary, secondary, tertiary

That will create the database MyDB on the primary, secondary and tertiary filegroups. You'll have to use your actual filegroup names, of course, and...

To move the database files around in a T-SQL script, you'll need to use xp_cmdshell. That allows you to issue commands like "copy" or "move" to the file system,...

Have you tried changing the data type from varchar to nvarchar?

On the parentheses thing, do you mean:

insert into t (col1, col2, col3)

select col1, col2, col3

from t

If that's what you mean by putting the columns in parentheses, yes, this is the...

In doing some tests on this, I found something I consider quite interesting.

Datepart(Day, date)

Datepart(Month, date)

Datepart(Year, date)

Datepart(Hour, date)

Datepart(Minute, date)

are all considered deterministic by SQL Server, but

Datepart(Weekday, date)

is not.

Neither are:

dateadd(day, '12/30/1899', date)%7

cast(date...

SSIS can do that.