Lynn

You guys were right about the 'Where' clause being the issue. I added a few indexes to the table to increase performance and went back to a suggested 'where' clause...

Sean

I did read the article but the query involves joins on four tables along with converting XML data. Unfortunately I can't figure out an easy way to provide a single...

Here is the original query with the time stamp

Select a.app_key AS APP_NUMBER, a.CREDIT_AMOUNT, REPLACE(d.DLR_REFERENCE_NUM, '.', '') AS DEALER_NUM, c.cts_contract_number AS APP_CONTRACT_NUMBER,

...

Hey Sean

I tried this and had to stop the query after 25 mins of running. Any other suggestions would be appreciated.

Doug

Both still show no rows. I am looking for rows where the date is right now (today) regardless of the time stamp so I will get the current day each...

Nice package. Do you have the code posted some where?

Mystery solved: I was not getting an accurate row count using

select APPNUMBER = COUNT(*) from SCORECARDAPP_TEST _new

When querying the dmv I was able to get the exact count as...

After some more digging I don't think the problem is with the bulk load from the SSIS package. I think the row count in the database is the issue. Exporting...

The original file has a row count of 176,864 and even though the row count from sql is 93,456 when I export to txt file and import to excel for...

I think I know why the count does not match.

When I exported the data from the sql table (93,456 rows) to a txt file and then imported it to...

No

I have a sequential numbering for the first column (APPNUMBER) and they are all in the table as well as the flat file.

When did you pass the exam and did you take both?

Jack

How long did it take you to study for the MCTS and MCITP (70-432, 70-450) series?

Doug

Hi Guys

I am starting to study for MCTS and MCITP (70-432, 70-450). Anyone have an idea of the length of study it takes to pass the exam? Just looking for...

I am checking the memory with the standard memory consumption report and the server is 32bit.