Viewing 15 posts - 18,931 through 18,945 (of 26,490 total)
Duplicate post. Please post replies here.
Please do not cross post.
September 2, 2009 at 8:24 am
Check the data, run this:
select top 1000
shippingcost
from
dbo.NavAttempts
September 1, 2009 at 9:02 pm
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.
September 1, 2009 at 7:57 pm
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...
September 1, 2009 at 7:56 pm
select replace(convert(varchar(8),getdate(),5),'-','');
Try the above.
September 1, 2009 at 4:13 pm
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
Viewing 15 posts - 18,931 through 18,945 (of 26,490 total)