Viewing 15 posts - 481 through 495 (of 2,038 total)
Could you be more specific please?
Have a look to BOL for INTERSECT/EXCEPT
June 29, 2009 at 5:59 am
This should work, too:
SELECT N'™'
June 29, 2009 at 5:56 am
lmu92 (6/27/2009)
We NEAFL's (NonEnglishAsFirstLanguage) will never know...
ROFL!
Sounds like a Turkish food :hehe:
June 27, 2009 at 3:12 pm
lmu92 (6/27/2009)
Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
Maybe you missed this post by Lutz. There is a case where PIVOT seems to be much faster than cross-tab here.
@Flo:
In the post you referred...
June 27, 2009 at 2:47 pm
smsam1,
could you provide some sample data to explain your question please?
June 27, 2009 at 10:03 am
Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
lmu92 (6/24/2009)
would someone with execution plan background mind to take a look at this post and verify if I'm on the right track or misguiding...
June 27, 2009 at 8:00 am
Seems to be a problem with ADO/ODBC and ASP have a look to this KB article http://support.microsoft.com/kb/306345/en.
The error description is different, but the error code is equal. Maybe this helps.
June 26, 2009 at 5:05 pm
rsheppick (6/26/2009)
That worked, but why?
:hehe:
As I wrote, SUM is a function to aggregate multiple rows into one like:
Name AnyNumber
ABC ...
June 26, 2009 at 3:35 pm
Try without the SUM. I'm not the reporting pro, but usually SUM is a aggregate function. Try "Fiel1 + Fiel2 + Field3 + Field4 + Field5"
June 26, 2009 at 3:25 pm
Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
Jeff Moden (6/26/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server articleWhich one?
Can't answer your question but the new article by Adam Machanic is really good in my opinion:
June 26, 2009 at 3:23 pm
Jeff Moden (6/26/2009)
jaclynmcatanzaro (6/26/2009)
Good SQL Server articleWhich one?
Can't answer your question but the new article by Adam Machanic is really good in my opinion:
June 26, 2009 at 3:07 pm
lmu92 (6/24/2009)
would someone with execution plan background mind to take a look at this post and verify if I'm on the right track or misguiding the OP?
The more interesting...
June 26, 2009 at 2:51 pm
Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
Jeff Moden (6/26/2009)
Florian Reischl (6/26/2009)
Lynn Pettis (6/25/2009)
I only hope he reads the blog, but I doubt it.I hope (s)he did. Next posts have been really okay.
Heh......
June 26, 2009 at 2:44 pm
First, I'm also completely unsure what you are trying to do with your XML. Anyway, try this:
SET @FeatureList.modify('
replace value of (FeatureList/Feature/Read[text()='' "True" '']/text())[1]
with '' "False" ''
')
SELECT...
June 26, 2009 at 1:25 pm
Viewing 15 posts - 481 through 495 (of 2,038 total)