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. ...
October 22, 2009 at 12:29 pm
Why are you posting this under SSIS if you have to do this in a stored procedure?
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.
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...
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...
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...
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...
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...
October 21, 2009 at 4:09 pm
Kit G (10/21/2009)
GabyYYZ (10/21/2009)
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...
October 19, 2009 at 7:22 am
Bob, isn't it time for you to hit the road?
😀
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...
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...
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????
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...
October 15, 2009 at 7:06 am
Viewing 15 posts - 2,926 through 2,940 (of 3,666 total)