Viewing 15 posts - 8,371 through 8,385 (of 9,720 total)
Now I feel silly. @=)
I went back through my most recent examples and found I'd re-written my code to use nested sub-queries because our BU decided they wanted different values,...
March 24, 2009 at 11:37 am
Ahh. I did not realize this was a homework assignment. That changes things, unfortunately. We don't answer homework assignments or interview questions on this board.
What I can do is give...
March 24, 2009 at 10:44 am
Okay, let's start with the first question.
What do you want to do (in English) with the results. Forget about your original post. What is the intent of gathering this...
March 24, 2009 at 8:08 am
I have to agree with Chris. I really don't think that query will get you the results you want.
But you'd have to post sample data and expected results for us...
March 24, 2009 at 7:47 am
I don't know about Sharepoint is affected by SS SP2, but I haven't noticed any data loss on my servers from installing SP2.
In fact, there shouldn't be data loss from...
March 24, 2009 at 7:42 am
You're welcome. Though, I'm not sure we helped much.
You might want to make very very sure your result set matches the expected data before you cheer.
March 24, 2009 at 7:34 am
You're welcome. Let us know if you have any other questions.
March 24, 2009 at 4:06 am
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...
March 23, 2009 at 11:22 am
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,
March 23, 2009 at 5:33 am
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...
March 23, 2009 at 4:51 am
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...
March 23, 2009 at 4:47 am
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...
March 23, 2009 at 4:40 am
munderhill73525 (3/23/2009)
I thought this would work but no dice thus far:
Select Last_name
FROM Employees
GROUP...
March 23, 2009 at 4:24 am
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...
March 23, 2009 at 4:20 am
Ditto to what DNA said. Here's the ReadMe file for SP2.
Hope this helps.
March 23, 2009 at 4:17 am
Viewing 15 posts - 8,371 through 8,385 (of 9,720 total)