Viewing 15 posts - 2,521 through 2,535 (of 5,504 total)
bajanpoet (11/25/2010)
Sounds interesting... but can I use that to rename with a timestamp? How would I do that?That would definitely ease my troubles....
I'm sure this link will help...
November 25, 2010 at 4:43 pm
Why don't you simply use the RenameFile option of the FileSystem task?
I don't see any reason to call a .bat file to do it...
November 25, 2010 at 4:23 pm
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
Viewing 15 posts - 2,521 through 2,535 (of 5,504 total)