Viewing 15 posts - 6,586 through 6,600 (of 9,707 total)
We can't see (or at least I can't) your tables. Can you repost?
EDIT: Please post table DDL (the create scripts with all keys and indexes). Pictures don't help us help...
February 7, 2011 at 6:39 am
As Jeff said, post both queries (with comments on what each is supposed to do) so we can help you combine them together or offer other advice.
February 7, 2011 at 6:39 am
Hugo Kornelis (2/7/2011)
Toreador (2/7/2011)
I wonder why they are withrawing this procedure?
If I have to make a guess, it is probably because over the past years, there has been a consistent...
February 7, 2011 at 6:34 am
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
Viewing 15 posts - 6,586 through 6,600 (of 9,707 total)