Viewing 7 posts - 1 through 7 (of 7 total)
Why not just edit the job in Management Studio? You can just add a new step and then place it where ever you need it to be.:-)
September 24, 2009 at 8:30 am
Why not create it on the Master database. You could then call it from anywhere
July 31, 2009 at 6:12 am
You could just use COLLATE DATABASE_DEFAULT.
At least you would not need to know what collation setting you are playing with. You would still need to put this into each...
June 19, 2009 at 4:39 am
Hi, If the correctly ordered sample you gave is typical of the data the correct sort order is simply the average of all values > 0 😎
eg:,
Row1: 4.4225
Row2:...
April 24, 2009 at 6:27 am
Have you tried using replication. You could just replicate the procs, functions etc;
April 24, 2009 at 3:55 am
Just open a second instance of management studio. You can then copy the code from one place to another.:rolleyes:
April 30, 2008 at 1:45 am
Wouldn't it have been better to do
SELECT col1,col2
FROM tablename
WHERE year(datecol) in (2007,2008) AND month(datecol) = 1
instead of using a union
as long as you use integers for the year and month...
March 5, 2008 at 1:37 am
Viewing 7 posts - 1 through 7 (of 7 total)