DSXchange

I think I have encountered a problem with the DSGetJobInfo function for the Elapsed Seconds (DSJ.JOBELAPSED). I have examples where a job starts before midnight and finishes after midnight and the function returns 0 seconds. However, if i generate a job report with dsjob, it reflects the correct amo...

Using the Trim function with the "L" option will also trim leading zeros: Trim(field,'0','L')

Here are some other ideas... If you are familiar with how partition tables work in SQL Server, you could create a partition view with monthly partitions (which in SQL Server equate to physical tables) for both the "current" and "archive" tables. This would allow you some flexibil...

Thanks a lot for the quick response. I have DatasetA(C1, C2, C3) and very less number of rows than DatasetB(C2, C3) So I hope A has to be used as a lookup as per my understanding. Correct me if I am wrong. I have C1, C2 C3 columns in Set A and C2, C3 in set B. I have to compare C3 from both the dat...