Viewing 15 posts - 3,601 through 3,615 (of 3,666 total)
It's not the inner and outer joins I'm worried about. It's the cross joins!!
If there is such a group we need to make sure replication is turned off by...
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]
September 4, 2008 at 2:43 pm
I'm not sure why you want to use another package to populate the variables.
Most of the packages I build have as one of the first steps a task that initializes...
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]
September 3, 2008 at 4:36 pm
You can go ahead and use the DBCC commands to shrink the database files. I never heard of any issue regarding the 5 GB.
Keep in mind that shrinking database...
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]
September 3, 2008 at 7:31 am
My eyes are getting old too.
The query has to produce the same results when it's reversed, so what else could it be?
Had the case been the same in both queries...
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 29, 2008 at 9:20 am
You have in the first query:
ON agrt778.prd = itdmn78.prodno
and in the second query:
ON itdmn78.PRDNO = agrt778.prd
notice PRDNO vs. prodno
Is that a typo in posting to this forum? Or is it...
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 29, 2008 at 9:07 am
Like someone already said, do not confuse database files with data files.
If you do not agree that the log file is a database file then go ahead and remove the...
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 28, 2008 at 7:43 am
Are you missing a BEGIN and and END? (See below)
This is what I am trying to do:
IF order EXISTS in the orders table
Begin
Insert that order into DuplicateOrders table
End
Else ...
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 28, 2008 at 7:38 am
This sounds like a job for SSIS to me. As someone said earlier, use SSIS to load the data in smaller batches.
That's what I would do.
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 27, 2008 at 8:57 pm
RPSql,
I have a friend who is trying to figure this one out. He would like to know what database roles are available in the database(s) with the problem?
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 27, 2008 at 1:26 pm
matt stockham (8/26/2008)
Also be aware that it won't connect to SSIS 2005.
Really? Now that's not good!
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 26, 2008 at 3:16 pm
Hang on here.
The error message indicates that SQL server thinks the table name is a keyword. Putting square brackets around the table name, or as SQL Server sees it,...
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 26, 2008 at 1:49 pm
I believe you should be able to, just like you can use SQL 2005 SSMS to administer SQL 2000 database.
Just remember that there could be a few features that you...
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 26, 2008 at 7:25 am
I wonder what would happen if you prefix the table name with the schema and did not use the square brackets.
I'm not sure what that would prove, just curious.
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 26, 2008 at 7:11 am
Can you give us a few table names for tables where this occurs?
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 25, 2008 at 1:30 pm
Are you interested in truncating, or rounding off?
What are you planning to do with the result? If you're going to display, or pass, it as a whole number,...
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 25, 2008 at 12:21 pm
Viewing 15 posts - 3,601 through 3,615 (of 3,666 total)