Select your CTE into a Temp Table (or create the TempTable first for better performance and then do the CTE...Insert). Then work off the Temp table.

That should resolve the issue...

Steve & Lowell,

Thanks for the advice. I appreciate it.

Looks like I have major research to do on the issue. But at least now I know where to start. @=)

Thanks again,

May I ask about the values of annual_review_type_id? If you can avoid using a function in your WHERE clause, your life will be much easier. Because the function evaluates for...

Might I also recommend using a JOIN on your @Fields query instead of a sub-query WHERE clause?

IE:

FROM CaseType ct

JOIN [CASE] c

on ct.CaseTypeRef = c.CaseTypeRef

ORDER BY Name ASC FOR XML PATH('')

Works...

Dave,

A couple of things. First, don't use text() as a column name. That's a terrible habit to get into. In fact, if you can avoid it, don't use keywords...

munderhill73525 (3/23/2009)

---

Using the Employees table below how would you select by Last_name and group by Salary within EE01_Classification?

I thought this would work but no dice thus far:

Select Last_name

FROM Employees

GROUP...

The best way to do it is run a manual trace. Create a Profiler session with the Login as a filter. Then script out the trace and set it up...

Ditto to what DNA said. Here's the ReadMe file for SP2.

http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/ReadmeSQL2005SP2.htm

Hope this helps.

NP. Glad we could help.

Sounds like you had a cache problem. Happens sometimes.

No worries. Glad we could try to help, anyway. @=)

Wait, nevermind.

Tools-> Options works for all.

Then go to Help -> Online.

At the top is the various types (online first or local first). On the left, underneath that, are check boxes....

Ken,

How are you accessing BOL? Via the program files menu or via SSMS?

You're absolutely right, JacekO. There's nothing left to be said on the subject except, from what I read, you are the only person you proved your point to. I didn't...

Lee,

You can also nest IF...ELSE statements and CASE statements. It could be...

JacekO (3/19/2009)

---

The SQL Server transactions can be called nested transactions but they are not. Plain and simple. If they were nested they should work the way I described. There might...