Viewing 15 posts - 13,321 through 13,335 (of 14,953 total)
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...
June 17, 2008 at 2:44 pm
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....
June 17, 2008 at 2:38 pm
Glad I could help.
June 17, 2008 at 2:34 pm
Matt Miller (6/17/2008)
June 17, 2008 at 2:29 pm
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...
June 17, 2008 at 2:27 pm
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...
June 17, 2008 at 2:23 pm
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
June 17, 2008 at 2:17 pm
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...
June 17, 2008 at 2:14 pm
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...
June 17, 2008 at 1:48 pm
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...
June 17, 2008 at 1:42 pm
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,...
June 17, 2008 at 1:37 pm
Have you tried changing the data type from varchar to nvarchar?
June 17, 2008 at 1:35 pm
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...
June 17, 2008 at 1:34 pm
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...
June 17, 2008 at 1:08 pm
Viewing 15 posts - 13,321 through 13,335 (of 14,953 total)