How about posting the full and actual error message you are getting, it might help.

Okay Scott, you're right and I am wrong. Now, I will go off and mumble to myself with the dust bunnies. No beer popsicles where I am at...

ScottPletcher (12/18/2013)

---

Lynn Pettis (12/18/2013)

---

Lynn Pettis (12/18/2013)

---

Luis Cazares (12/18/2013)

---

ScottPletcher (12/18/2013)

---

Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly what's being...

Lynn Pettis (12/18/2013)

---

Luis Cazares (12/18/2013)

---

ScottPletcher (12/18/2013)

---

Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly what's being tested is clearer.

IF...

Luis Cazares (12/18/2013)

---

ScottPletcher (12/18/2013)

---

Better to avoid ISNULL, since you should never use it in a WHERE clause. I also think that exactly what's being tested is clearer.

IF (@category IS...

Have you read the following?

http://msdn.microsoft.com/en-us/library/ms184325(v=sql.105).aspx

In your case above if @category is null it is replaced with an empty string.

Not exactly sure what you are asking or what the problem may be. Can you provide more details? What are you attempting to achieve

amber.richard (12/18/2013)

---

I admire your spirit! The only time I was ever out of my time zone was when I had to take a connecting flight that stopped in Utah. I...

amber.richard (12/18/2013)

---

Hello Lynn! That is a pretty big change. I'll keep that in mind 🙂

And today we started recruiting for a position in Mexico, so apparently we can add that...

amber.richard (12/16/2013)

---

Hey Lynn! I got back to you in an e-mail but I thought I'd post here. I haven't disappeared off the planet 🙂 This role is no longer available,...

Being a visual oriented individual I have no idea even where to start. It would help if you provided sample and the expected results based on the sample data....

Just remember that SQL Server <> Oracle. JUst because there are things that can be done in Oracle doesn't mean other RDBM systems wiill provide the same functionality.

Just to make it easier:

http://www.sqlservercentral.com/Forums/FindPost1522894.aspx

Since your data is character based and inconsistent, you are going to need to figure out a way to parse/transform the data into a consistent format that can be sorted.

Not...

Eric M Russell (12/12/2013)

---

Lynn Pettis (12/12/2013)

---

Eric M Russell (12/12/2013)

---

...

Why pay a contractor $100,000+ a year to shuffle your backup tapes and network logins, when they could hire a full...