Viewing 15 posts - 14,716 through 14,730 (of 26,486 total)
Actually, it is possible to do this in Oracle. I had a nice discussion about it with one of the Oracle gurus where I work. He would never...
March 8, 2011 at 6:41 am
One of the factors to consider is the activity on the databases.
If many are infrequently used, you should be okay. If they are all heavily used with many users,...
March 8, 2011 at 6:34 am
The code you posted is simply going to reprocess the same data continously. There is a better way to accomplish what you are attempting to do here. To...
March 8, 2011 at 6:03 am
The one other thing that you really should provide is the expected results based on the sample data provided. This actually makes testing of code easier as we know...
March 6, 2011 at 10:10 pm
SQLkiwi (3/3/2011)
mwwheeler (3/3/2011)
March 3, 2011 at 10:49 am
mwwheeler (2/28/2011)
i was trying to use this
and (GetDate() <= (DATEADD( month,CONVERT(INT,dbo.UDF_ParseNumChars(Lookup.SubRef)),Data_Landline.ModifiedDate)))
the subref column may contain some text instead of a number, so the calculation...
February 28, 2011 at 11:34 pm
Okay, since I can't seem to get everything I have asked for, here is my wild guess. You are in the same database that has the function.
If you reread...
February 28, 2011 at 5:54 am
mnDBA (2/27/2011)
We are presently running on SQL Server 2005 about...
February 27, 2011 at 4:42 pm
mwwheeler (2/26/2011)
if you read my post again, youll see that it was prefixed with dbo.
Second request, please post the DDL for your function plus the code calling your function that...
February 26, 2011 at 6:05 pm
Sorry, but the force is weak. Can't see what you see.
Please post the DDL for you function and the code you are trying to execute using the function.
February 25, 2011 at 10:32 am
Butts in chairs <> productivity. I have seen plenty of people spending time talking with cube neighbors and not working.
The best measure if someone is working, on-site or off-site,...
February 23, 2011 at 8:37 pm
MaricopaJoe (2/21/2011)
Case in point. ...
February 21, 2011 at 12:22 pm
Just to clarify, there is nothing wrong with tech talk around the water cooler as long as it is kept quite short.
If you start going into details, that's when it...
February 16, 2011 at 9:29 am
Have you searched the threads here on ssc? IIRC one was started by Lutz and there may be a solution somewhere there. Unfortunately, I don't remember the title...
February 15, 2011 at 8:15 pm
I said I'd stay out of MasterBlasters thread, and I will. What he doesn't seem to get is that there was a better way to respond to Gus's comment...
February 13, 2011 at 8:24 am
Viewing 15 posts - 14,716 through 14,730 (of 26,486 total)