Viewing 15 posts - 42,601 through 42,615 (of 59,067 total)
Heh... Don't do it for me... I actually can't help because I use something else instead of SSIS. It was just an observation that even if someone wanted to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 9:31 am
Slow... I guess I'm trying to juggle too many things at one time. I need to concentrate on "one" of something and get it done. The running total/quirky...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 8:49 am
Now that's funny stuff right there... it reminds me of folks that think banging on an elevator button will make the elevator go faster.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 8:46 am
GilaMonster (8/1/2009)
Jeffrey Williams (7/31/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 8:44 am
Hi Pete,
Ok... but there are better ways to do this. I guess I would first question the requirement of making alpha-numeric keys in the first place. An IDENTITY...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 8:39 am
Yep... that should work.
As a side bar, it's been a day or two since this thread has been active and I orginally didn't believe your code would work...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 8:21 am
Checking...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 8:07 am
Nah... sorry. Just passing through. I don't even know how to spell "Service Broker".
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 12:06 am
I thought most reporting programs had date formatters built in?
No matter... here's how to do it in T-SQL... just keep in mind that it won't be "portable" from country to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2009 at 12:01 am
I guess you've lost me a bit... why do you need this to be dynamic SQL? I believe the example code I posted does everything you've asked.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 31, 2009 at 11:57 pm
arun.sas (7/31/2009)
Hi Jeff,I think, need the statement for the comma delimited row to the column,
Colin already use the COALESCE statement, actually may Colin need the better one then COALESCE!!!
It looks...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 31, 2009 at 11:52 pm
I don't believe you need to so long as you have proof that you've purchased the correct number of licenses. Check the EULA to make sure but I believe...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 31, 2009 at 10:04 pm
Hi Jim,
I know you've already solved your problem here but I'm curious. How big are these files? I know you said they've all got 5 columns but how...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 31, 2009 at 10:01 pm
Heh... I live in Michigan, an Oracle/DB2 state where the weak are killed and eaten. 😛 Most free events are product propaganda here. Even the better ones...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 31, 2009 at 9:55 pm
SQLSlammer (7/31/2009)
Here you go
Heh... that does it for me. I couldn't help if I wanted to because you edited the post and removed the package.
Good luck! 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
July 31, 2009 at 9:42 pm
Viewing 15 posts - 42,601 through 42,615 (of 59,067 total)