Thanks very much to you both.

Scott, I'm going to go with yours because I can better understand what it is doing. (By the way, I didn't need the SUM, but...

*Stu_ID 11111 doesn't have 15 or more credits on Enr_ID 7765. However, since 11111 has 40 credits associated with Enr_ID 9876, he won't be in the result set.

*22222 does have...

Hi Vinu - Thanks for your reply. What is the simpler query? To put make the cte a subquery in the from clause? That is the only thing I could...

...after rereading Jeff's article over lunch, I realized I can use MAX instead of SUM. So tweaking the THEN clauses, I came up with the below query that works! I...

Thanks, Imex. I think that will do it.

DataAnalyst110 (6/29/2012)

---

Hi Craig - What does the > 0 do in your query? I looked on MSDN to find out what CHARINDEX does. But I haven't seen anything like that...

Hi Craig - What does the > 0 do in your query? I looked on MSDN to find out what CHARINDEX does. But I haven't seen anything like that in...

...I just stumbled upon the DelimitedSplit8K. Looks really good, although I've never seen anything quite like it before. I'm going to push it around in my test environment, but I...

...I just wanted to bump my last question one time to see if anyone had suggestions. Thanks!

Lowell,

Thank you for the reply - that works perfect! Would you mind explaining how it works. I found a PARSENAME article on MSDN. But you're adding in the REPLACE also....

I think that will work. The only variable between the table/query I supplied and the other query I'm working with is the data. For some reason, the cte with a...

Also - and this is a side question - sometimes SSMS will print 1 row with NULLs when no results are returned. Other times it prints 0 rows. Does anyone...

Yes, I would like the one above. (The one which returned 0's). Thanks so much for the help.

I would like to return the value in the PIVOT. If no rows are returned I would like to print 0. If I need to give more details please let...

...I went ahead and setup an example (see below). Switching the SUM to COUNT in the below query will print a 0. However, from some reason that isn't working on...