Viewing 15 posts - 2,926 through 2,940 (of 3,666 total)
SQL Learner-684602 (10/22/2009)
Ohkk..Yes but I am using a Stored Procedure and have to do it in a select query...
Once again, this topic does not belong in the SSIS section. ...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2009 at 12:29 pm
Why are you posting this under SSIS if you have to do this in a stored procedure?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2009 at 11:29 am
In SSIS, I would be tempted to use a script task and use the VB.Net split function splitting the columns into it's parts.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2009 at 11:23 am
Bob Hovious 24601 (10/22/2009)
When I was a boy, and computers were carved from wood and cranked by hand, it was widely understood that hierarchical...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2009 at 7:56 am
Kit G (10/22/2009)
Alvin Ramard (10/22/2009)
GSquared (10/22/2009)
Why have tables? Store all your business data in a single XML file. Save a ton of money on database software!
I was on...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2009 at 7:39 am
GSquared (10/22/2009)
Why have tables? Store all your business data in a single XML file. Save a ton of money on database software!
I was on a mailing list where...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 22, 2009 at 7:21 am
Bob Hovious 24601 (10/21/2009)
Sigh... I always over-design things.
Before the XML data type, all data could be stored in tables with a no more than 4 columns. Now it can...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 21, 2009 at 4:20 pm
Paul White (10/21/2009)
Bob Hovious 24601 (10/21/2009)
Emperor Paulpatine,XML makes db design much simpler too:
create table XMLTable (ID bigint, Data xml)
...what's the ID column for? :laugh:
Very good point Paul. Why...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 21, 2009 at 4:09 pm
Kit G (10/21/2009)
GabyYYZ (10/21/2009)
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 21, 2009 at 10:13 am
Steve Jones - Editor (10/19/2009)
Bob Hovious 24601 (10/18/2009)
Where'd you get the hat? I have to make do with a colander reinforced with tin foil.
I think we'd like pictures...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 19, 2009 at 7:22 am
Bob, isn't it time for you to hit the road?
😀
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 15, 2009 at 3:10 pm
Any data that is definetly not common I would be tempted to put in application specific databases. This would make it easier to migrate application to different servers in...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 15, 2009 at 1:36 pm
If one application can change the common data, and, the other need to see these changes, then I would put the common data in a common database, to avoid having...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 15, 2009 at 1:29 pm
Roy Ernest (10/15/2009)
What is going on in THE THREAD? Wasnt there a Code ban on THE THREAD? :hehe:
Even worse, recent discussions have been "On Topic". What's with that????
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 15, 2009 at 1:05 pm
Jack Corbett (10/15/2009)
Wow, I go offline for a day and there are like 60 posts to catch up on.
I was offline for 7 days. I'm not even going to...
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 15, 2009 at 7:06 am
Viewing 15 posts - 2,926 through 2,940 (of 3,666 total)