Viewing 15 posts - 61 through 75 (of 469 total)
Have you tried any of the recommendations above?
June 6, 2012 at 1:22 pm
Can you post the full set of table variables you're using and queries to insert any starting data? It'll make it much easier to see what's going...
June 5, 2012 at 1:48 pm
drew.allen (6/5/2012)
You should use QUOTENAME() instead of hand-coding the delimiters, because QUOTENAME() will automatically handle delimiters embedded in the column names and help to prevent SQL injection attacks.
Good point. ...
June 5, 2012 at 1:05 pm
I agree with Sean here. I can't think of a good reason not to have the columns named what they're supposed to be and not doing that is going...
June 5, 2012 at 12:04 pm
Are you looking for something like this?
SELECT FromDate, ThruDate
FROM @temp5
WHERE FromDate >= '2010-09-30'
AND CAST(ThruDate AS DATE) <= '2010-12-31'
UNION ALL
SELECT FromDate, ThruDate
FROM @temp5
WHERE FromDate >= '2010-09-30'
...
June 5, 2012 at 11:47 am
I'm not sure I'm getting how this is different from the last question. Just plug in the new numbers and run whichever query is most appropriate. However, I...
June 5, 2012 at 10:42 am
So you want entries where the FromDate is after 2008-12-31 and the ThruDate is before 2009-04-30?
If you don't need to worry about time (ie - the time portion will always...
June 5, 2012 at 10:03 am
jay-h (6/4/2012)
I did not understant what IBM's objection was when I read the news article. How does this differ from doing a Google or Bing search?
When you go to a...
June 4, 2012 at 7:29 am
We haven't here but I'm sure there are cases where it has. On a server where there isn't a lot of extra CPU power I would think it may...
June 1, 2012 at 11:57 am
I'm happy where I am and I'm not really looking for a switch, particularly because I've only been here a year. That being said, if the exact right job...
June 1, 2012 at 7:58 am
Is it always in the same spot where it fails? Could the target table be getting dropped or renamed? Or the user having access removed?
May 31, 2012 at 12:02 pm
This is a SQL forum so it's not really the best place to ask this kind of question. I still recommend checking out robocopy and seeing if that will...
May 31, 2012 at 11:10 am
MysteryJimbo (5/31/2012)
The usual way is to uninstall SQL, reinstall and patch back up to the correct level then restore databases, jobs and loginsConsider restoring master and msdb in this case
That's...
May 31, 2012 at 10:39 am
Are you talking about setting up a SQL job to move files from one sever to another? If that's the case there's probably an easier way to do it....
May 31, 2012 at 10:37 am
The only thing that pops to the top of my head is that it was in a transaction that rolled back.
May 31, 2012 at 9:17 am
Viewing 15 posts - 61 through 75 (of 469 total)