Viewing 15 posts - 1,966 through 1,980 (of 6,486 total)
Jack Corbett (2/18/2009)
I believe that you need to set the Report Server Virtual Directory to allow anonymous connections. But I could be wrong.
With all of the caveats as to...
February 23, 2009 at 12:30 pm
Perhaps I'm having a low-caffeine day, but figuring out HOW to delete PM's wasn't exactly straightforward.
For those who need to do this:
1. move all of the messages you want to...
February 23, 2009 at 10:35 am
Is that the ACTUAL query you're using? Which tables are col1, col2 and col3 from?
something isn't right in here. Also - if you just want to count occurrences,...
February 23, 2009 at 9:43 am
As Gift is referring to - you're treading into one of the long-standing intractable holy wars out there in the RDBMS world (and no - this is not restricted to...
February 19, 2009 at 1:49 pm
Massoud (2/19/2009)
Adding Begin and End doesn't change the results. I get...
February 19, 2009 at 12:31 pm
Try using the TOP(N) predicate with some random order.
Something like:
SELECT top (10) questions
from questions_table
where question_set=5
order by newID()
February 19, 2009 at 9:33 am
Lynn Pettis (2/18/2009)
Bruce W Cassidy (2/18/2009)
Alvin Ramard (2/18/2009)
Ooops, I misread that at first. I thought Bruce was asking for intelligence in the code section.
[font="Verdana"]No. I was asking for...
February 18, 2009 at 2:32 pm
Thomas Martin (2/18/2009)
Thanks again. Just to be clear, are you are referring to creating a new SQL2008 standard instance on the existing SQL2000 enterprise machine?
Correct. My understanding is...
February 18, 2009 at 12:34 pm
Did your friend happen to be a direct report to the CEO? That would help explain the curious behavior as well.
Otherwise - good discussion all around.
February 18, 2009 at 12:16 pm
PWPDCOMPARE is not a built-in function, so I would start by looking at what it actually does. Although I doubt you will be allowed to post what it does...
February 17, 2009 at 3:29 pm
I would just turn around and ask her to tell you why it HAS to be one row at a time. If it seems to come across that that's...
February 17, 2009 at 3:24 pm
I do think that the "automatic" upgrade (i.e. point at an instance during the install, etc...) will be blocked. You'll have to do the old detach/attach/recreate all users trick....
February 17, 2009 at 3:04 pm
Also - hedging your bet so that the CHARINDEX always returns a valid value to the LEFT function might make the error go away.
update tblDrawings
set TypeCode = (
...
February 16, 2009 at 3:20 pm
what's the data type of the "Typecode" column? I suspect that some of your rows have the dash in the werong location, causing you to try to put 10...
February 16, 2009 at 3:16 pm
Since you don't care what the count is, but only that there IS a count, you might care to simply look at a "distinct" sub-query.
February 16, 2009 at 2:31 pm
Viewing 15 posts - 1,966 through 1,980 (of 6,486 total)