What about permissions on the directory?

Duplicate post. Please post further replies here.

What about permissions on the directory?

Cool!

Here is the code I wrote to test:

declare @TestTable table (

MyDate datetime,

MyYear int,

MyMonth int

);

insert into @TestTable

select dateadd(mm, 2,...

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...

Look at the following, and try using the dense_rank function.

select *, dense_rank() over (order by MyYear, MyMonth) from @TestTable;

Only if the value of the character variable (or column) is a valid uniqueidentifier.

Test it for yourself to be sure.

You tell us what you want, but you left out what you are getting currently.

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...

Try this udf.

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...

sam.marsden (9/1/2009)

---

Hi again,

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...

drew.allen (9/1/2009)

---

You DO NOT want to do a CROSS JOIN here. The problem with your original query is that a LEFT outer join will return all records from the...

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.