Viewing 15 posts - 43,426 through 43,440 (of 59,063 total)
Paul McCurdy (6/12/2009)
value1 >= value2 AND value1 <= value3
was quicker by a few seconds than
value1 BETWEEN value2 AND value3
I know, not my understanding either and...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 9:00 pm
siboyd07 (6/10/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 8:06 pm
RBarryYoung (6/10/2009)
Jeff Moden (6/10/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 7:49 pm
Terri (6/10/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 7:36 pm
RBarryYoung (6/11/2009)
Jeff Moden (6/10/2009)
RBarryYoung (6/10/2009)
What you should be able to see however is that the Unicode .sql file is about twice the size of the Ascii one.
Any idea if SQL...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 7:17 pm
GSquared (6/11/2009)
So far as I can tell, that's pretty much been the end result of every one of our disagreements. It's just a matter of clarification.
Heh... I concur... but...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 7:07 pm
Steve Jones - Editor (6/8/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 7:03 pm
Barry and Lynn... thanks for the huge compliment. You guys are gonna make me blush. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 6:57 pm
David Jackson (6/11/2009)
do we not need the following in the last part of dynamic SQL?
+ 'WHERE (BusinessDate >= ''' + CONVERT(CHAR(10),@FiscalYearStartDate,101) + ''' and...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 6:49 pm
David Jackson (6/12/2009)
David Jackson (6/11/2009)
Jeffdo we not need the following in the last part of dynamic SQL?
I have noticed if you do put the date range in the where clause,...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 6:48 pm
Greg Edwards (6/10/2009)
Fiscal Calendars can change. And in Jeff's example, what happens next year?Greg E
Jeff -
I like my chops well done, with some Gates BBQ sauce. :w00t:
Heh... nah... I'll...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 6:05 pm
dxmer (6/12/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 5:53 pm
bpowers (6/11/2009)
Thanks for the constructive critisizm and honesty. I appreciate it.
That's actually the first step towards making yourself more marketable. 🙂 Thank you for not taking what I said...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 5:49 pm
I just saw the PASS session list. Congrats Gail and Grant!!!
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 1:12 pm
GilaMonster (6/12/2009)
Grant Fritchey (6/12/2009)
Now if only people will read and follow the advice here.
Read it is a possibility. Expecting everyone to follow the advice might be a little too much...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 12, 2009 at 12:40 pm
Viewing 15 posts - 43,426 through 43,440 (of 59,063 total)