Viewing 15 posts - 2,086 through 2,100 (of 5,502 total)
What is your expected output and what have you tried so far?
January 17, 2011 at 9:30 am
You might want to post your question in a pure Oracle forum.
The changes for getting help will be much higher since here you'll mostly find MS SQL folks.
January 17, 2011 at 9:28 am
Is there any option to change the values in column COUNTRY_CD, table MG_LOCATION, from FR to FRS rsp. FRN? Then you could simply join on COUNTRY_CD and LOCATION_CD.
If you can't...
January 17, 2011 at 9:22 am
kaspencer (1/17/2011)
1. How about indicating...
January 17, 2011 at 3:53 am
Are you sure you're on the right forum?
This is a SQL forum, not PHP.
January 17, 2011 at 2:41 am
Without any further information (e.g. actual execution plan) I'd expect table scans due to the non-SARGable columns in your WHERE clause.
Furthermore, the part "like @fullname1" might not work as you...
January 17, 2011 at 2:39 am
You could use a CASE statement to do your conditional COUNT().
Something like
SUM(CASE WHEN [Call Status] NOT IN ('Closed','Solved') THEN 1 ELSE 0 END)
January 16, 2011 at 5:41 pm
Lynn Pettis (1/16/2011)
And then you have those individuals that won't even ask their DBAs for help because they don't know them personally and are in a different building.
Strange he posted...
January 16, 2011 at 5:18 pm
Since I've recently seen a few questions with Tour de France sample data I'm wondering if this is somoe sort of homework or school project. Please clarify.
January 16, 2011 at 1:08 pm
balasach82 (1/16/2011)
Gail,
Yes, I am aware of the end of support for SQL 2000. But from the MS site, and from the link Lutz gave, I gather that...
January 16, 2011 at 4:41 am
http://support.microsoft.com/lifecycle/?p1=2852
(hint: google search keywords: SQL+2000+lifecycle ;-))
January 16, 2011 at 3:18 am
If you would provide some ready to use sample data as described in the first link in my signature together with your expected result I'm confident we can help you.
Based...
January 15, 2011 at 3:16 pm
allmhuran (1/15/2011)
January 15, 2011 at 8:54 am
allmhuran (1/15/2011)
That's a good idea and one I had only vaguely considered. I'm not sure how I would approach them though. Guess I'll give them a call 🙂
At least regarding...
January 15, 2011 at 8:43 am
@allmhuran:
I disagree with your statement "-- alphabetic months are always safe."
Alphabetic months depend on the language setting. Therefore, I won't consider this format as being safe by any means.
Simply run...
January 15, 2011 at 8:40 am
Viewing 15 posts - 2,086 through 2,100 (of 5,502 total)