Viewing 15 posts - 7,471 through 7,485 (of 14,953 total)
What if stepping outside my comfort zone means forcing other people outside of theirs? Nobody, and I mean nobody, wants me to engage in any sort of public musical...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 10, 2009 at 8:40 am
Jeff: Her complaint that SSIS takes too many steps to deploy, and her statements about how to open SSIS packages for editing (both of which are just plain wrong), make...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 10, 2009 at 7:42 am
You're welcome.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 10, 2009 at 7:29 am
The interface for building SSIS packages is extremely complex and difficult, assuming you aren't familiar with such arcane concepts as drag-and-drop, right-click, or flow charts. The deployment process does...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 3:06 pm
cafescott (12/9/2009)
hi GSquared,I tried your suggestion. unfortunately, i'm still not getting the parameter values back as intended.
thanks,
You're selecting @vEffectiveBegin, but you're not assigning a value to that. It's...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 2:27 pm
Lynn Pettis (12/9/2009)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 2:24 pm
File associations are controlled through the registry. Check there. Might be a problem.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 12:55 pm
Bru Medishetty (12/9/2009)
Hey Gus, how is it going on at your workplace? Are things settling down?
The rumor mill is seriously overclocked at this point. I think it's running at...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 12:46 pm
Lynn Pettis (12/9/2009)
How the .... did this person get a job in IT?????The force in this one is not only weak, I think it is nonexistant.
I just checked the guy's...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 12:19 pm
You'll have to test for numeric values first, then do the update.
Because of how SQL Server works, the easiest way to do this (often the only way) is to insert...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 12:06 pm
To be specific, you'd need to change this:
exec sp_test_Called
@vEffectiveBegin=@vEffectiveBegin_1,
@vEffectiveEnd=@vEffectiveEnd_1,
@vDate1=@vOur_Date_1,
@vDate2=@vOur_Date_2
to this:
exec sp_test_Called
@vEffectiveBegin=@vEffectiveBegin_1 output,
@vEffectiveEnd=@vEffectiveEnd_1 output,
@vDate1=@vOur_Date_1,
@vDate2=@vOur_Date_2
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 12:01 pm
crookj (12/9/2009)
Steve Jones - Editor (12/7/2009)
Try here: http://www.thinkgeek.com/gadgets/tools/8b97/I'm not quite sure it's worth the price: US$999
Thanks for the info Steve.
Now that is a KNIFE!
But I agree, it is not worth...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 11:59 am
No, I was hoping there was something in there that was confusing it.
Check what's in the Windows registry. Might be a double-entry or messed up entry there.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 11:56 am
Lynn Pettis (12/9/2009)
How the .... did this person get a job in IT?????The force in this one is not only weak, I think it is nonexistant.
Well ... first you go...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 11:45 am
In Management Studio, go to Tools, Options, and check what's in the Text Editor tab. There's a section on File Extensions. Anything set in there?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 9, 2009 at 11:36 am
Viewing 15 posts - 7,471 through 7,485 (of 14,953 total)