Viewing 15 posts - 1,051 through 1,065 (of 3,666 total)
There's many ways to do this but without seeing your actual setup, it's hard to say what's best.
Sounds like using SSIS is a good idea. If the 2 servers...
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]
August 6, 2013 at 8:41 am
You should be able to get all you need from these views:
INFORMATION_SCHEMA.TABLES
INFORMATION_SCHEMA.COLUMNS
sys.schemas
sys.tables
sys.columns
There may be other system tables or views that could be helpful. You just need to take the time...
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]
August 6, 2013 at 8:31 am
Why do you want to do this? All the information in the script is already available in system tables and views.
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]
August 6, 2013 at 8:05 am
I'm assuming that meant that table A is the table referred to right after FROM.
Example:
SELECT .......
FROM TableA
... JOIN TableB ON ...
... JOIN TableC ON ...
etc.
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]
August 2, 2013 at 2:34 pm
Before we get started, maybe you can tell us a bit about how much experience you have with SSIS.
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]
August 2, 2013 at 12:02 pm
jbalbo (8/1/2013)
I guess you'd be all set if you were ambidextrous...
Full outer joins? :w00t:
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]
August 1, 2013 at 2:53 pm
If I understand correctly what you're doing, you could have a table which acts as a log of what has been done or what needs to be done. Each...
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]
August 1, 2013 at 2:52 pm
Sean Lange (8/1/2013)
jbalbo (8/1/2013)
Thanks Sean.. good ideaIts one thing I think I do get..
At least I think I do.. lol
It is exactly like a left join....only backwards. 😛
I wonder...
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]
August 1, 2013 at 2:40 pm
SSNinja (7/31/2013)
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]
July 31, 2013 at 1:44 pm
If you're getting more rows than you should after adding a join, it's probably because you should be joining to that table using more than just 1 join condition. ...
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]
July 31, 2013 at 11:49 am
Revenant (7/31/2013)
Steve Jones - SSC Editor (7/31/2013)
So I get this is probably in jest and partially true, but it's insulting. It's not selling out any more than Android...
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]
July 31, 2013 at 11:26 am
Phil Parkin (7/30/2013)
Script Tasks are used in the Control...
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]
July 31, 2013 at 7:38 am
You could also delete the files from withing the script component.
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]
July 30, 2013 at 12:13 pm
bitbucket-25253 (7/30/2013)
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]
July 30, 2013 at 10:02 am
Check what data types are used both for and input, output, and in betweeen.
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]
July 29, 2013 at 3:28 pm
Viewing 15 posts - 1,051 through 1,065 (of 3,666 total)