Viewing 15 posts - 18,931 through 18,945 (of 26,484 total)
What about permissions on the directory?
September 1, 2009 at 2:27 pm
Duplicate post. Please post further replies here.
September 1, 2009 at 2:26 pm
Here is the code I wrote to test:
declare @TestTable table (
MyDate datetime,
MyYear int,
MyMonth int
);
insert into @TestTable
select dateadd(mm, 2,...
September 1, 2009 at 1:22 pm
Does this mean that the code in your original post works fine from SSMS but not when executed as a job by SQL Server Agent?
Just so that you know, we...
September 1, 2009 at 1:18 pm
Look at the following, and try using the dense_rank function.
select *, dense_rank() over (order by MyYear, MyMonth) from @TestTable;
September 1, 2009 at 1:10 pm
Only if the value of the character variable (or column) is a valid uniqueidentifier.
Test it for yourself to be sure.
September 1, 2009 at 12:51 pm
You tell us what you want, but you left out what you are getting currently.
September 1, 2009 at 12:46 pm
Need to see the code, and not for the split function, but where you are using it. The DDL for the tables and sample data would also help in...
September 1, 2009 at 12:37 pm
I'd use two separate queries in different stored procedures and use the stored procedure in your original post to determine which child procedure to call based on the value of...
September 1, 2009 at 11:26 am
sam.marsden (9/1/2009)
I have a field which is a datetime vaule and i would to show it ion a different format....
2009-09-01 00:00:00.000 is how it appears now
010909 is how...
September 1, 2009 at 10:18 am
drew.allen (9/1/2009)
September 1, 2009 at 10:16 am
What may help is dropping the indexes that may exist on the historical table prior to inserting the new data and then recreating the indexes after the insert.
September 1, 2009 at 10:08 am
Viewing 15 posts - 18,931 through 18,945 (of 26,484 total)