Viewing 15 posts - 6,601 through 6,615 (of 9,715 total)
Toreador (2/7/2011)
I always use sp_change_users_login in these circumstances...
Ditto. I did get the correct answer, but that's not been my first choice of resolution in these instances.
Toreador (2/7/2011)
February 7, 2011 at 6:32 am
If you have any IT experience at all, the certs are iffy as to whether or not they'll help you get the job. If you have no official IT experience,...
February 7, 2011 at 5:28 am
Craig Farrell (2/4/2011)
StartDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date) -4, +2))
EndDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date) -3, +1))
ReportDate = CStr(DATEADD("m", DATEDIFF("m", 0, Date)-2, +1))
This query gives the...
February 4, 2011 at 12:33 pm
I know you won't get back to this until next week, but I'm posting this before I forget. ActiveX tasks will be removed (or already have been removed) from SSIS...
February 4, 2011 at 12:25 pm
Toreador (2/4/2011)
Brandie Tarvin (2/4/2011)
The trick is that date doesn't actually exist in some countries, including the U.S.
But given that the date does exist in many other countries, SQLServer is completely...
February 4, 2011 at 10:56 am
gchornenkyy (1/26/2011)
What's the trick - missed point 🙂
The trick is that date doesn't actually exist in some countries, including the U.S.
February 4, 2011 at 10:08 am
SQLDCH (2/4/2011)
The moon.
DUDE! I forgot people can pay to get private trips into outer space. I would SO do that!
February 4, 2011 at 8:29 am
GSquared (2/4/2011)
February 4, 2011 at 8:27 am
Daniel Bowlin (2/4/2011)
Ray K (2/4/2011)
Pouliot Philippe (2/3/2011)
42But what, exactly, is the question?
I always thought something was fundamentally wrong with the universe.
Instructions for avoiding universal wrongness:
Throw yourself at the ground...
February 4, 2011 at 7:19 am
My pork chop recipe
Pork Chops
Baked Beans
Brown Sugar (if the baked beans don't already have BS in them)
Mustard
Salt & Pepper
Preheat oven to 375.
Pour baked beans into a pan. Mix in sugar...
February 4, 2011 at 7:16 am
Europe and Asia Minor.
Egypt has always been on my list, too, but I'd be postponing that trip until things calmed down.
February 4, 2011 at 7:11 am
Old Chinese Story that my SO told me once.
Two men were arguing in the middle of a market place. One man was very stupid and one man was very smart.
Both...
February 4, 2011 at 7:03 am
Tom Brown (2/4/2011)
...so find half a packet of fresh noodles in the back of the fridge...
What kind of noodles? Rice, wheat, shitake, other?
February 4, 2011 at 5:35 am
Right. Okay. I get it.
Since the third argument is supposed to be date, but there's a "+2" in it instead, it's taking 01-01-1900 and adding 2 days.
Which is weird, odd,...
February 4, 2011 at 5:08 am
I've added a Random Recipies thread to this subforum. I hope you all will contribute. I think it'd be fun.
http://www.sqlservercentral.com/Forums/Topic1058623-61-1.aspx
February 4, 2011 at 4:58 am
Viewing 15 posts - 6,601 through 6,615 (of 9,715 total)