pitter1

Hello all,I'd like to create a view which shows all specific column values (null values for example)as calculated values from another column,if for example i have the table:---------------| col1 | col2||----- |------|| 123 | null || 126 | 9 |---------------i would like the view to be:---------------| col1 | col2 ||------|------|| 123 | 6 | ----> 6, since it's the sum of col1 digits 1+2+3| 126 | 9 |---------------I don't really know how to do that, although i'm quite sure it's possible, any help will be appreciated,Best Regards,pitt

Hi all,I have a column which i want to put inside ascending indices, that is, empty column which i want to enter 1,2,3,4.....[tble no. of rows] so this table:col1 | col2 | col3 ------------------- | a | b | c | d | e | fbecomes:col1 | col2 | col3 ------------------- 1 | a | b 2 | c | d 3 | e | fthnks,Ahron

Hi all,I'm writing a DTS activeX with VBscript andwould like to access a data in in an excel sheet on the first row, while using DTSDestination("columnA") = DTSSource("columnB")will assign "columnB" in "columnA" for each row,how do I do this for specific row source column (for example assigning "columnB" row 1, into "columnA")Best,Ahron