Viewing 15 posts - 8,386 through 8,400 (of 9,725 total)
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
NP. Glad we could help.
March 23, 2009 at 4:12 am
Sounds like you had a cache problem. Happens sometimes.
No worries. Glad we could try to help, anyway. @=)
March 19, 2009 at 10:24 am
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....
March 19, 2009 at 9:13 am
Ken,
How are you accessing BOL? Via the program files menu or via SSMS?
March 19, 2009 at 9:10 am
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...
March 19, 2009 at 9:00 am
lee.pollack (3/19/2009)
please remember that my company is still using sql2000 - so WHILE does not exist for me
Lee,
You can also nest IF...ELSE statements and CASE statements. It could be...
March 19, 2009 at 8:48 am
JacekO (3/19/2009)
March 19, 2009 at 8:43 am
Lee,
Before I go any further, Label 1 confuses me.
label1:
-- 1st check - do we have a customer record in CP
IF EXISTS (Select * From DATABASE.OWNER.TABLE 6 WHERE cust_id = @memvar...
March 19, 2009 at 8:18 am
JacekO (3/19/2009)
March 19, 2009 at 8:14 am
Ah. I forgot local help could be disabled.
But shouldn't he still be getting something from the online stuff, assuming he has a network connection?
March 19, 2009 at 7:24 am
Viewing 15 posts - 8,386 through 8,400 (of 9,725 total)