I can ive you Three POWERFUL Reasons

1.DATA INTEGRITY

2.FLEXIBILITY

3.No Duplication of data

Tell your Crystal GURU that you can use stored procedures I do it all the time  

I am going to guess that he...

yaweah , Keep in mind that you are going to put stress on the activity in the table. I would recomend you to Insert...

sorry for the typo.  I just tried to give you the Idea

I do it too but it doesn't keep my indentation

besides that try to make your transactions as short as possible and that will also mitigate the chances for locks

I am not sure that mapped drives will work because those setting are profile specific and the account is running as a service. sevices are not profile aware, that's the...

I do what david posted above a lot but if this is going to hit production (for me) BACKUP goes first

I know my effectiness will rise with self study but I have tried to stay current without the cert and there is nothing I can do to change the company...

if you still want to use DTS Processing try to use the multiphase datapump feature,determine that you are using the header record and SKIP the row (returning DTSTransformStat_SkipRow)!

Erik if you think that is slow you should revise the queries because so far I have found that to be the fastest! thing to do.

Do you use Bulkinsert to get ...

I wished I could have convince them but they don't budget certifications only seminars Isn't that smart

I learned form the Master

I don't know anything about Universe but:

If you look at this thread you may find someone that does

ok can you try to change

SUM(*) for SUM (T.Count_A)

the last line is Not a typo I am just alingning all counts in just one column and then After changing...