Forum Replies Created

Viewing 15 posts - 16 through 30 (of 31 total)

  • RE: Replication put Id column twice

    I answered myself.  The problem is I didnt pu ID as Primary Key or Unique Constraint.  Thanks

  • RE: Self table join

    Thanks, this works perfect

  • RE: RE:DTS csv

    I created the table myself and i have all the right.  The other thing is if i call column names eg FA, FB and the likest, I can select everything and...

  • RE: RE:DTS csv

    Everything you explained, is what i have done, the problem is, the columns do not get populated to the destination, so basically my destination is empty, but if i select...

  • RE: DTS csv

    I uded the defaults, Send me your empty private mail @ msenoelo@investec.co.za so that i can email you the .gif

  • RE: DTS csv

    Thanks, here we go

    trad_type char(20),

    reference char(20),

    principal char(20),

    book char(20),

    strategy char(20),

    cpty char(20),

    buy_sell  char(20),

    Quantity numeric,

    ident_type char(20),

    ext_ident char(20),

    sec_name char(20),

    price int,

    price_divisor numeric,

    traded_net_ind char(20),

    trade_ccy char(20),

    trade_ldt smalldatetime,

    value_date smalldatetime,

    commission char(20),

    exchange_fee char(20), --Dont worry about fees being char

    other_fees char(20),

    gross_consid...

  • RE: DTS csv

    This is a stand alone table it is not linked to anything.  Please try to create this table and select from it and output it as a .csv

  • RE: Restore Database from one server to the another

    Thanks very much, it worked!

  • RE: User-defined-function

    This is not working because your code gives me the date as 2003-05-03 and this is a Saturday, I am expecting the results to be Monday since I am only...

  • RE: User-defined-function

    I am not sure if i understand you, you meena my query must look like this correct me if i am wrong because this is not working

    create function fn_NextTrDate(@TrDate datetime)

    returns...

  • RE: User-defined-function

    Sorry about this Mike but this doesn't work in the following cases

    If I use TrDate = '2003-04-25' and I add 7 which is the 2 May 2003.  2 May 2003 was...

  • RE: User-defined-function

    Hi Antares686

    I thought you everything which Mike did is working fine, the only problem is the dates.  I need help on how...

  • RE: User-defined-function

    Hello Mike

    Thanks a lot for your help but I have a small is problem

    My data type is a problem, TrDate is saved in the format 2003-04-24 11:27:56.000 where as my Holiday is saved as 2003-04-24...

  • RE: DTS usernames and password

    Maybe let me re-phrase my question, i need to retrieve the server, username of the their connection in the DTS-Package.  That is if the Connect into SQL sever, i need...

  • RE: Replication Table Permissions

    Hi Grasshoper.

    Please send me the script

Viewing 15 posts - 16 through 30 (of 31 total)