Duplicate post. Please post replies here.

Please do not cross post.

Check the data, run this:

select top 1000

shippingcost

from

dbo.NavAttempts

I'd start by showing us what you have tried so far. hard to know what you are doing wrong in your code without seeing it.

Give this code a spin. It is untested as you did not provide the DDL for the tables or any sample data. To see how you really should...

select replace(convert(varchar(8),getdate(),5),'-','');

Try the above.

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