Viewing 15 posts - 16 through 30 (of 87 total)
Hey, any new techniques you could share would be awesome. You actually helped me come up with the one I'm using on another thread. Anyway, here goes. For each day,...
June 19, 2007 at 9:54 am
I'm comparing people's scheduling and time punch data, which often do not match. I need to define the amount of time they worked when scheduled, worked when not scheduled, and...
June 18, 2007 at 11:56 am
Thanks Jeff! You're the man!
Well, these temp tables can get to be about 100 million+ records, so maybe I'll just create physical tables in the db, populate these staging tables, index...
June 18, 2007 at 11:31 am
Well, I do use it as follows:
CREATE
TABLE #ScheduleVariance (PersonNum varchar(15),ComplianceDate
June 15, 2007 at 12:50 pm
Thanks so much for all the great replies! Awesome! Here's the whole script. What do you guys think? Any changes you might suggest? Indexing maybe? Thanks!
If
June 7, 2007 at 1:55 pm
WOW!!! Thanks guys! Let me play around with these a little bit.
Thanks so much for the quick replies!
Pat
June 6, 2007 at 11:53 am
no, lagcategory isn't in any of the indexes. takes aboout 1/2 hour to load the data.
April 9, 2007 at 4:11 pm
no, i actually recreated the table to be sure it was blank and same result...
April 9, 2007 at 3:27 pm
it's loaded each week, and I have no control over the data source it comes from (SAS in this case)...i wish...
April 9, 2007 at 3:25 pm
Thanks guys. the indexes are dropped and recreated each load. the lagcategory field is always blank.
i don't know what happened that changed the update time so drastically. it's driving...
April 9, 2007 at 3:03 pm
Thanks! I'll give that a try.
But what if you wanted to allow NULLS? Does SSIS have issues importing NULL values? Anybody else have any thoughts on this? Thanks guys!
March 12, 2007 at 4:19 pm
I tried the .Net ODBC Data Provider to connect to the ODBC Source. Then I tried to use the DataReader Source connection. It seems like it picks up the columns...
October 18, 2006 at 1:10 pm
This is a vendor app, and I don't know much about connection pooling, but here's what I found. Anything jump out at you? Thanks for the help.
<Config CacheSize="100" numSQLRetry="5" SQLRetryInterval="5000">
<DBConnections ActiveConnection="xxxxxx" ...
September 14, 2006 at 10:34 am
cliff, think I got it. Found some NULLS in the date column in the fact table. Looks like the culprit. I'll use the COELESCE Function to handle them. Always good...
September 6, 2006 at 3:09 pm
cliff, i'm sorry, that was incorrect. I was using the wrong test table. The INNER JOIN I listed above did produce the correct results for each line of business...man this is weird...
September 6, 2006 at 2:46 pm
Viewing 15 posts - 16 through 30 (of 87 total)