Viewing 15 posts - 10,711 through 10,725 (of 13,872 total)
krypto69 (6/1/2012)
Hmm...
So I'm not sure how to proceed now.
What I really need is everything grouped by year first, then company code, then branch code. But retaining...
June 1, 2012 at 1:02 pm
krypto69 (6/1/2012)
Cold coffee -I didn't think they were required to answer a fairly straight forward question about grouping.
If you guys need more info. let me know.
It's not totally...
June 1, 2012 at 11:39 am
Or maybe this:
SELECT
CmpCompanyCode,
cmpCompanyName,
E.eecCoID,
E.EecEEID, --unique number stays with person, if listed more then once
E.EecOrgLvl2,
E.eecDateOfLastHire,
E.eecDateOfTermination,
E.eecEmplStatus,
E.eecEmpNo,
E.eecLocation,
E.eecFullTimeorPartTime,
E.eecJobCode,
eepNameLast,
eepNameSuffix,
eepNameFirst,
EepNameMiddle
FROM EmpPers JOIN EmpComp E...
June 1, 2012 at 9:41 am
I think your problem may be that you are trying to run a batch file on a remote computer - and that just doesn't work, as the batch file always...
May 30, 2012 at 4:20 am
Apart from the fact that
MsgBox(DateString).ToString()
looks weird (use MsgBox(DateString) instead), I can't see a problem. But if you post the full text of the error message (just copy & paste), it...
May 29, 2012 at 9:10 am
Consider using a file watcher task with a timeout of 1 hour.
You can configure the task such that a timeout results in a warning or an error.
May 29, 2012 at 4:00 am
Use the File System Task & take the copy option.
May 29, 2012 at 3:39 am
If you see i have duplicate records in All FIELD and also most seriously Duplicate records between two or more columns....
DISTINCT is not working in my case,here is my code...
May 24, 2012 at 5:51 am
What sort of macro?
May 16, 2012 at 5:39 am
Koen Verbeeck (5/16/2012)
Uncached lookups are of course very slow, but I don't really see a reason why the package should hang.
Did you try a cache connection?
How is...
May 16, 2012 at 3:40 am
khorkh888 (5/15/2012)
I am facing problem to load a batch of text in Excel into sql table using SSIS. Here is in Excel look like:
Date KPI...
May 15, 2012 at 10:51 pm
Eugene Elutin (5/15/2012)
ISNULL(tb_2.column_2, 'Undefined')
You didn't mention the 'c' word...
May 15, 2012 at 3:42 am
Really? Did not know that - thanks for sharing.
May 14, 2012 at 9:54 am
Not that I know of.
But there are a couple of things you can do.
1) Find a decent text viewer that will open big files quickly and allow you to navigate...
May 14, 2012 at 9:34 am
Viewing 15 posts - 10,711 through 10,725 (of 13,872 total)