Viewing 15 posts - 1,486 through 1,500 (of 5,504 total)
Is this some sort of homework?
If not, why do you have to use SSIS?
May 29, 2011 at 2:36 am
I guess this link should help you to get started.
May 29, 2011 at 2:34 am
run the query without the html formatting and check if the xml result is what you're looking for. If so, manually add the html format to the xml result.
The error...
May 29, 2011 at 2:24 am
Luk (5/28/2011)
Yes a nightly job runs several days, but it's not all SQL, most of it is actually Perl. This is an outdated process that needs fixing. I...
May 28, 2011 at 7:31 am
Craig Farrell (5/28/2011)
*chanting*I will not smack Syed with a heavy hand...
I will not smack Syed with a heavy hand...
I will not smack...
*mumbles off to another room, still chanting*
I'm not even...
May 28, 2011 at 6:11 am
Glad I could help. 😀
But make sure the other conditions I mentioned need to be excluded as per the business case defnition. What I usually do is to build a...
May 28, 2011 at 5:24 am
Errrmmm...
What's the reason to repeat your question again and again even if you already have some answers???
(for instance http://www.sqlservercentral.com/Forums/FindPost1116627.aspx)
No replies please. Triple post.
May 28, 2011 at 5:03 am
some nightly processes that run for quite some time, the longest takes 3-4 days to run (db size is 2.5TB)
A nightly job taking several days? I truly hope this is...
May 28, 2011 at 4:59 am
What's the data type of the following columns:MRP and ER_AVG?
I assume, the columns used as join predicates all have corresponding data types, too...
May 28, 2011 at 4:46 am
It looks like a string with "<|>" as a separator.
You could replace those three character with a single delimiter (making sure it's not part of the current data) before the...
May 28, 2011 at 2:57 am
Why can't you use BCP together with a format file to change the REAL column into VARCHAR(128) (not NVARCHAR, since I wouldn't expect unicode data in a REAL column)?
May 28, 2011 at 2:51 am
Something like this? It's basically nothing else than to return all rows with a single occurence of empno and the status being 'closed'. Is that what you're looking for?
There are...
May 28, 2011 at 2:46 am
Syed Jahanzaib Bin hassan (5/28/2011)
Its good there is no any IO
What new information does this post provide?
To quote Jim:
... but no IO is a good (and rare) thing. ...
May 28, 2011 at 2:31 am
As you already noticed there are different execution plans for the same query.
Compare the execution plans and try to find the difference.
Assuming your indexes are up to date, it's likely...
May 28, 2011 at 2:29 am
duplicate post. No replies please.
Please reply here: http://www.sqlservercentral.com/Forums/FindPost1116605.aspx
May 28, 2011 at 2:14 am
Viewing 15 posts - 1,486 through 1,500 (of 5,504 total)