anand_vanam (1/17/2011)

---

Just for curiosity..

if we don't know the maximum numbers of mac_address's associated for the Name.

Say here we have 4 mac_address associated with the Name "sn4051536", so went for...

CELKO (1/17/2011)

---

You were asleep in your freshman Software Engineering class! Coupling? Cohesion? Remember all that stuff?

Each module of code should have one entry and one exit point. Each...

What is your expected output and what have you tried so far?

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.

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...

kaspencer (1/17/2011)

---

Can I please make two suggestions for improving the information shown on your Rankings Page, where you list the top scorers in the QOD and Postings?

1. How about indicating...

Are you sure you're on the right forum?

This is a SQL forum, not PHP.

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...

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)

Strange he posted...

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.

balasach82 (1/16/2011)

---

Thanks Lutz, Gail

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...

http://support.microsoft.com/lifecycle/?p1=2852

(hint: google search keywords: SQL+2000+lifecycle ;-))

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...

allmhuran (1/15/2011)

---

HAH! Quite true I suppose. Not a problem you're likely ever to run into though, unless for some reason you decide to develop in a different language for the...