Jump to content

pitter1

Members
  • Content Count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About pitter1

  • Rank
    Newbie
  1. 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
  2. pitter1

    indexing a table

    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
  3. 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
×
×
  • Create New...