Viewing 15 posts - 57,661 through 57,675 (of 59,070 total)
Yah... forgot that the NTEXT data type is being used... sorry.
September 14, 2006 at 7:24 pm
Of course it's only creating one file... that's because you hardcoded the output file name as c:\Person_notes.txt.
You need to make the file name dynamic, as well. Perhaps using the...
September 14, 2006 at 8:11 am
John,
Understood... I just don't make those same assumptions... if the requester knew about those types of things, they might not have needed to ask the original question
September 13, 2006 at 7:19 pm
If the columns a VARCHAR or the like, you can use SOUNDEX (won't work on numbers).
September 13, 2006 at 7:05 pm
It's not SQLAgent that you need to be concerned with... it's the security setting on the server itself... WHO is the SQL Server SERVICE logging in as? If it's not...
September 13, 2006 at 7:02 pm
What's wrong with LEFT(somentextval,100) ??? ![]()
September 13, 2006 at 6:54 pm
I absolutely agree with using a tally table as Remi and Sreejith have... I just can't bring myself to create a tool that helps avoid cursors and loops by using...
September 13, 2006 at 6:42 pm
Yes... instead of using the "-o somefilename" parameter, use the DOS "redirect as append" characters ">> somefilename".
September 13, 2006 at 6:33 pm
Sorry Vandy... I just can't read minds today... what's not right about the total sum?
September 13, 2006 at 6:37 am
Vandy... how about telling us which columns the +ive and =ive numbers are stored in? If they are both in the InvoicedValue column, then Marino's should have done the trick...
September 13, 2006 at 5:30 am
Better make sure you do a backup before you truncate the log or you won't be able to recover to a point in time which is the purpose of Full...
September 13, 2006 at 5:00 am
Sure... what's the Primary Key of the person table?
September 12, 2006 at 5:24 pm
Maybe this weekend... right now, I'm still sucking my thumb wonder what the heck I was thinking ![]()
September 12, 2006 at 5:21 pm
I'll say... as for me, I can't find the examples I had made for something else (might not even be the same problem
...
September 12, 2006 at 7:27 am
Outstanding... thank you for the feedback.
September 12, 2006 at 6:52 am
Viewing 15 posts - 57,661 through 57,675 (of 59,070 total)