Viewing 15 posts - 5,011 through 5,025 (of 9,715 total)
Back on topic...
sqldba2k8, if you want to learn SQL Server, grab Books Online, grab a How-To book (I used Sybex Certification books back in the day), get yourself a cheap...
December 15, 2011 at 7:38 am
That is good information, Jon. Thanks for the link!
EDIT: Although, this issue probably is something that needs reported to Microsoft to see if they'll fix it.
December 15, 2011 at 7:29 am
Personally, I like to grab chocolate when things break. It makes life so much more pleasant to eat chocolate while the world is falling apart around me. @=)
December 15, 2011 at 6:47 am
Lowell (12/15/2011)
i tried switching to LOWER as Brandie identified, and i get a function that never finishes executing...
That's what I'm running into. I'm not quite sure why it's doing that.
EDIT:...
December 15, 2011 at 6:22 am
I've been testing further and it turns out it's the setting of the result to the variable that's causing the issue.
Try this:
DECLARE @result as numeric(38,9),@ftest as numeric(38,8), @ResultNonConvert as numeric(38,8),...
December 15, 2011 at 6:10 am
Is there a reason why the second line uses UPPER() instead of LOWER()?
I'm trying to test this just using the code inside the function and it is taking a damn...
December 15, 2011 at 6:05 am
Wow. I have just replicated this behavior using your code.
Hmm. What version SQL Server are you using?
EDIT: In further testing, it's not the function that is the problem. Try this...
December 15, 2011 at 5:44 am
As I have said in many of my SQL Saturday presentations, Books Online is your best friend. Learn it, Live it, Love it.
December 15, 2011 at 5:41 am
Stefan Krzywicki (12/14/2011)
Here I go asking for opinions againDoes anyone know about configuring your sql server on a SAN? Or have opinions about the best place to put the files?
Yes,...
December 14, 2011 at 11:51 am
So I'm about ready to murder a pork chop or two at this point. Anyone have a pork chop flinger handy?
Moved the package to another environment. Recreated the job (scripted...
December 14, 2011 at 11:23 am
Roy Ernest (12/14/2011)
You all are NUTS. I think I am the only sane person in the THREAD. 😀
That's what all the crazy people say...
December 14, 2011 at 11:07 am
Good idea, but if it were a permissions issue, I would not expect a syntax error.
We've had permissions issues on other packages / jobs before, and never gotten this...
December 14, 2011 at 10:57 am
TedT (12/14/2011)
Open each of the script tasks individually, and right click - build them... Do they build successfully?
Build succeeded on both.
EDIT: Although now I can see, on the Build menu,...
December 14, 2011 at 8:24 am
Steve Jones - SSC Editor (12/9/2011)
Brandie Tarvin (12/9/2011)
Oh, it's not a thread. I didn't post on this. I just found it and put a dent in my desk the shape...
December 12, 2011 at 11:22 am
Dev (12/9/2011)
Brandie Tarvin (12/9/2011)
DUH!Code
December 9, 2011 at 9:41 am
Viewing 15 posts - 5,011 through 5,025 (of 9,715 total)