Viewing 15 posts - 2,521 through 2,535 (of 5,502 total)
Here's my attempt. I'm confident there are easier solutions not requiring the multiple sort operations...
Edit: please explain the difference between this thread and the one Gianluca mentioned earlier. At the...
November 25, 2010 at 2:14 pm
There are several questions:
1) what do you consider being a "special character"? Do you have just a list of character, a rule on how to define it or a list...
November 25, 2010 at 1:29 pm
CirquedeSQLeil (11/25/2010)
...Things like that are best reserved for April Fools.
Jason, are you serious?? Do you really consider Mr. Celko's posts being the source of April Fools???? I urge you to...
November 25, 2010 at 1:02 pm
Jeff Moden (11/24/2010)
It's a little out of character for me but I know you'll recognize the rhetoric. I just couldn't resist... it was too perfect. Enjoy... 😛http://www.sqlservercentral.com/Forums/Topic1025567-392-1.aspx#bm1026289
I just...
November 25, 2010 at 12:17 pm
To all of you folks in the U.S.:
May the turkey be tender and juicy and the people you're celebrating with be the ones you love and care about.
My very special...
November 24, 2010 at 4:39 pm
WayneS (11/24/2010)
stan-617410 (11/24/2010)
Wayne, Thank you for your persistence and patience.
No problem. To be fair, Lutz and Ron were pretty instrumental in getting this solved also!
Is this working right for you...
November 24, 2010 at 4:18 pm
Jeff Moden (11/24/2010)
Heh... not to worry, Lutz. You've seen the mess I can make of things if I PBC (Post Before Coffee). 😀
No, I haven't. I barely can remember...
November 24, 2010 at 3:18 pm
WayneS (11/24/2010)
...
@Lutz: thanks, but it's reporting the days in the following months as zero, not the proper days. It comes down to...
November 24, 2010 at 2:42 pm
change the appropriate section in cte2 to
,StayForMonth = CASE WHEN Move_In_Date > StartOfMonth AND Move_out_Date <= EndOfMonth
...
November 24, 2010 at 2:21 pm
I sometimes feel like reporting his posts as "plain advert covered by some rather unhelpful or unrelated advice"...
But I think all it would generate would be some additional work for...
November 24, 2010 at 2:09 pm
Jeff Moden (11/23/2010)
LutzM (11/23/2010)
What's the specific reason for you not to use global temp tables (##table)
Concurrency and logical separation of data between concurrent runs because all sprocs that use it...
November 24, 2010 at 12:57 pm
WILLIAM MITCHELL (11/24/2010)
You need to create & set three startup properties for the Access database:
StartupShowDBWindow = False
AllowSpecialKeys = False
AllowBypassKey = False
this will prevent the user from accessing the database window...
November 24, 2010 at 12:47 pm
Alvin Ramard (11/24/2010)
...Alvin Ramard (11/23/2010)
Depends on what I'm hunting. 😎...
Wayne, I'm in Memphis. I was waiting for that M R Ducks one. 😀
Permanently or just getting something...
November 24, 2010 at 7:44 am
The task seems to be straightforward.
What would you need the dynamic sql for?
Couldn't you just pass the VARCHAR(MAX) value, the @where variable and the call of fnDelimitedSplit to the dynamic...
November 23, 2010 at 3:41 pm
Is there any specific reason for using the least preferred method?
November 23, 2010 at 3:33 pm
Viewing 15 posts - 2,521 through 2,535 (of 5,502 total)