Viewing 15 posts - 2,491 through 2,505 (of 5,685 total)
john.clyma 97764 (10/5/2011)
October 5, 2011 at 7:41 pm
AJ,
What particular concepts are you feeling you're having difficulty with? An end to end discussion on warehousing, even particularly for healthcare, is incredibly broad. A few particular components...
October 5, 2011 at 7:37 pm
opc.three (10/5/2011)
In particular, if you're running SQL Express (thus no SQL Agent) and want to do a BCP/Bulk Insert and then archive the file you've done it from, you'd need...
October 5, 2011 at 4:55 pm
opc.three (10/5/2011)
Evil Kraig F (10/5/2011)
opc.three (10/5/2011)
PS I cannot wait to see the examples of when one would HAVE to use it.SQL Express with an on-demand file bulk load and archiving.
My...
October 5, 2011 at 4:24 pm
opc.three (10/5/2011)
PS I cannot wait to see the examples of when one would HAVE to use it.
SQL Express with an on-demand file bulk load and archiving.
October 5, 2011 at 4:01 pm
Why are you double scanning?
select Short_Name from t_One where short_name like 'val%'
union
select short_Name from t_One where short_name like '%val%'
Returns the equivalent of:
select short_Name from t_One where short_name like...
October 5, 2011 at 2:55 pm
Well, I certainly got it wrong, but that's because of simple unfamiliarity but I tried to turn it into my familiar world. I figured elementary key meant candidate key...
October 5, 2011 at 2:22 pm
SQL Kiwi (10/5/2011)
SQLRNNR (10/5/2011)
2 of 3 servers I get arithmetic overflow and the 3rd server differs by 35 seconds.
Yeah great, so do I come back for the second interview or...
October 5, 2011 at 11:39 am
Jack Corbett (10/1/2011)
I just hope I can honor that award the way that all the MVP's...
October 5, 2011 at 10:36 am
Question Guy (10/4/2011)
October 5, 2011 at 10:26 am
It sounds like the login running the SQLAgent doesn't have the access levels you do to the other system. I'd start there.
Primarily because of this component in the error:
"Could...
October 5, 2011 at 10:14 am
GilaMonster (10/1/2011)
Lowell (9/30/2011)
October 1, 2011 at 5:39 am
Lynn Pettis (9/30/2011)
Need Software with following modules and features...
... an entire software suite from the land of the gods...
If you are...
October 1, 2011 at 5:33 am
Roughly:
DELETE a
OUTPUT tblc
FROM
tblA as a
JOIN
tblB as b
ON a.col1 = b.col1 AND a.col2 = b.col2 ....
September 30, 2011 at 4:25 pm
Hey guys, Jack's got me flabbergasted over here. Anyone else familiar with SSIS and connection failures want to take a swing?
September 30, 2011 at 2:23 pm
Viewing 15 posts - 2,491 through 2,505 (of 5,685 total)