Professional Web Applications Themes

(Stored Procedures) Can't get one table to move contents to another - Microsoft SQL / MS SQL Server

Hi, ERROR (at execution): "Disallowed implicit conversion from data type datetime to data type tinyint, table "xyz.dbo.tmpTrenddata', column 'xyz'. Use the CONVERT function to run this query." PURPOSE: To get one table (current batch) to copy its contents (only some rows with a specific batch number) to another (log) table. The log table will typically gain 10GB in a year. ADDITIONAL: The two tables are identical, all columns in the same order with same data types. Both have autonumber ID fields. tmpTrenddata currently contains no data. PROCEDURES: ----------------------------------------------------------------- CREATE PROCEDURE "get_batch_current" ( batchnr int ) AS SELECT * FROM tmpCurrentBatch ...

  1. #1

    Default (Stored Procedures) Can't get one table to move contents to another

    Hi,

    ERROR (at execution):
    "Disallowed implicit conversion from data type datetime to data type
    tinyint, table "xyz.dbo.tmpTrenddata', column 'xyz'. Use the CONVERT
    function to run this query."

    PURPOSE:
    To get one table (current batch) to copy its contents (only some rows with a
    specific batch number) to another (log) table. The log table will typically
    gain 10GB in a year.

    ADDITIONAL:
    The two tables are identical, all columns in the same order with same data
    types. Both have autonumber ID fields. tmpTrenddata currently contains no
    data.

    PROCEDURES:
    -----------------------------------------------------------------
    CREATE PROCEDURE "get_batch_current"
    (
    batchnr int
    )
    AS
    SELECT * FROM tmpCurrentBatch WHERE Batch = batchnr
    -----------------------------------------------------------------
    CREATE PROCEDURE "move_batch_to_log"
    (
    batchnr int
    )
    AS
    INSERT INTO tmpTrenddata
    EXECUTE get_batch_current batchnr
    -----------------------------------------------------------------

    Running MSSQL7 (MSDE) on WinNT4S/SP6. I am not very experienced with MSSQL
    procedures, but competent at SQL.

    --
    Best regards,

    Alexander Ris°y
    IT Team
    Nebb Engineering


    Alexander Ris°y Guest

  2. #2

    Default Re: (Stored Procedures) Can't get one table to move contents to another

    The error says it all really. The stored procedure is trying to insert a
    datetime value into a column with datatype tinyint (which is 0-255) and that
    won't fit. Change the column in tmpTrenddata to datetime.

    MSDE has a limit on the size of the database of 2GB, so with the scenario
    you describe you are going to run out of database space after about 2
    months.

    --
    Jacco Schalkwijk MCDBA, MCSD, MCSE
    Database Administrator
    Eurostop Ltd.


    "Alexander Ris°y" <alexnebb.no> wrote in message
    news:_GyPa.5626$os2.83280news2.e.nsc.no...
    > Hi,
    >
    > ERROR (at execution):
    > "Disallowed implicit conversion from data type datetime to data type
    > tinyint, table "xyz.dbo.tmpTrenddata', column 'xyz'. Use the CONVERT
    > function to run this query."
    >
    > PURPOSE:
    > To get one table (current batch) to copy its contents (only some rows with
    a
    > specific batch number) to another (log) table. The log table will
    typically
    > gain 10GB in a year.
    >
    > ADDITIONAL:
    > The two tables are identical, all columns in the same order with same data
    > types. Both have autonumber ID fields. tmpTrenddata currently contains no
    > data.
    >
    > PROCEDURES:
    > -----------------------------------------------------------------
    > CREATE PROCEDURE "get_batch_current"
    > (
    > batchnr int
    > )
    > AS
    > SELECT * FROM tmpCurrentBatch WHERE Batch = batchnr
    > -----------------------------------------------------------------
    > CREATE PROCEDURE "move_batch_to_log"
    > (
    > batchnr int
    > )
    > AS
    > INSERT INTO tmpTrenddata
    > EXECUTE get_batch_current batchnr
    > -----------------------------------------------------------------
    >
    > Running MSSQL7 (MSDE) on WinNT4S/SP6. I am not very experienced with MSSQL
    > procedures, but competent at SQL.
    >
    > --
    > Best regards,
    >
    > Alexander Ris°y
    > IT Team
    > Nebb Engineering
    >
    >

    Jacco Schalkwijk Guest

  3. #3

    Default Re: (Stored Procedures) Can't get one table to move contents to another

    Hi,

    At the bottom you see the defenition of the two tables. I have printed them
    out and held the two sheets on top of each other and they are entirely
    identical (I'd be very surprised if you find them to be different :-)

    Here is all the info I have:

    ---------------------------------------
    get_batch_current PROC
    ---------------------------------------
    Create Procedure get_batch_current
    (
    batchnr int
    )
    As
    SELECT * FROM tmpCurrent WHERE Batch = batchnr

    ---------------------------------------
    move_batch_to_log PROC
    ---------------------------------------
    Create Procedure "move_batch_to_log"
    (
    batchnr int
    )
    As
    INSERT INTO tmpTrenddata
    EXECUTE get_batch_current batchnr

    ---------------------------------------
    tmpCurrent DATA:
    ---------------------------------------
    ID Batch Tidspunkt padrag
    1 1 01.01.2003 10
    2 1 02.01.2003 12
    4 2 01.01.2003 5
    5 2 02.01.2003 7
    6 2 03.01.2003 9

    ---------------------------------------
    tmpTrenddata DATA:
    ---------------------------------------
    - Empty -

    ---------------------------------------
    tmpTrenddata (this is the log) TABLE DEF:
    ---------------------------------------
    3 ID int 4 10 0 0 1 1 1 0
    0 Batch int 4 10 0 0 0 0
    0 Tidspunkt datetime 8 0 0 0 0 0
    0 padrag tinyint 1 3 0 1 0 0
    0 O2 tinyint 1 3 0 1 0 0
    0 N2 smallint 2 5 0 1 0 0
    0 vifteHast1 smallint 2 5 0 1 0 0
    0 vifteHast2 smallint 2 5 0 1 0 0
    0 vifteHast3 smallint 2 5 0 1 0 0
    0 vifteHast4 smallint 2 5 0 1 0 0
    0 vifteHast5 smallint 2 5 0 1 0 0
    0 vifteHast6 smallint 2 5 0 1 0 0
    0 vifteHast7 smallint 2 5 0 1 0 0
    0 vifteHast8 smallint 2 5 0 1 0 0
    0 luftTemp1 smallint 2 5 0 1 0 0
    0 luftTemp2 smallint 2 5 0 1 0 0
    0 luftTemp3 smallint 2 5 0 1 0 0
    0 luftTemp4 smallint 2 5 0 1 0 0
    0 luftTemp5 smallint 2 5 0 1 0 0
    0 luftTemp6 smallint 2 5 0 1 0 0
    0 luftTemp7 smallint 2 5 0 1 0 0
    0 luftTemp8 smallint 2 5 0 1 0 0
    0 luftTemp9 smallint 2 5 0 1 0 0
    0 luftTemp10 smallint 2 5 0 1 0 0
    0 luftTemp11 smallint 2 5 0 1 0 0
    0 luftTemp12 smallint 2 5 0 1 0 0
    0 luftTemp13 smallint 2 5 0 1 0 0
    0 luftTemp14 smallint 2 5 0 1 0 0
    0 luftTemp15 smallint 2 5 0 1 0 0
    0 luftTemp16 smallint 2 5 0 1 0 0
    0 godsTemp1 smallint 2 5 0 1 0 0
    0 godsTemp2 smallint 2 5 0 1 0 0
    0 godsTemp3 smallint 2 5 0 1 0 0
    0 godsTemp4 smallint 2 5 0 1 0 0
    0 godsTemp5 smallint 2 5 0 1 0 0
    0 godsTemp6 smallint 2 5 0 1 0 0
    0 godsTemp7 smallint 2 5 0 1 0 0
    0 godsTemp8 smallint 2 5 0 1 0 0
    ---------------------------------------
    tmpCurrent TABLE DEF:
    ---------------------------------------
    3 ID int 4 10 0 0 1 1 1 0
    0 Batch int 4 10 0 0 0 0
    0 Tidspunkt datetime 8 0 0 0 0 0
    0 padrag tinyint 1 3 0 1 0 0
    0 O2 tinyint 1 3 0 1 0 0
    0 N2 smallint 2 5 0 1 0 0
    0 vifteHast1 smallint 2 5 0 1 0 0
    0 vifteHast2 smallint 2 5 0 1 0 0
    0 vifteHast3 smallint 2 5 0 1 0 0
    0 vifteHast4 smallint 2 5 0 1 0 0
    0 vifteHast5 smallint 2 5 0 1 0 0
    0 vifteHast6 smallint 2 5 0 1 0 0
    0 vifteHast7 smallint 2 5 0 1 0 0
    0 vifteHast8 smallint 2 5 0 1 0 0
    0 luftTemp1 smallint 2 5 0 1 0 0
    0 luftTemp2 smallint 2 5 0 1 0 0
    0 luftTemp3 smallint 2 5 0 1 0 0
    0 luftTemp4 smallint 2 5 0 1 0 0
    0 luftTemp5 smallint 2 5 0 1 0 0
    0 luftTemp6 smallint 2 5 0 1 0 0
    0 luftTemp7 smallint 2 5 0 1 0 0
    0 luftTemp8 smallint 2 5 0 1 0 0
    0 luftTemp9 smallint 2 5 0 1 0 0
    0 luftTemp10 smallint 2 5 0 1 0 0
    0 luftTemp11 smallint 2 5 0 1 0 0
    0 luftTemp12 smallint 2 5 0 1 0 0
    0 luftTemp13 smallint 2 5 0 1 0 0
    0 luftTemp14 smallint 2 5 0 1 0 0
    0 luftTemp15 smallint 2 5 0 1 0 0
    0 luftTemp16 smallint 2 5 0 1 0 0
    0 godsTemp1 smallint 2 5 0 1 0 0
    0 godsTemp2 smallint 2 5 0 1 0 0
    0 godsTemp3 smallint 2 5 0 1 0 0
    0 godsTemp4 smallint 2 5 0 1 0 0
    0 godsTemp5 smallint 2 5 0 1 0 0
    0 godsTemp6 smallint 2 5 0 1 0 0
    0 godsTemp7 smallint 2 5 0 1 0 0
    0 godsTemp8 smallint 2 5 0 1 0 0
    ---------------------------------------

    --
    Best regards,

    Alexander Ris°y
    IT Team
    Nebb Engineering

    "Andrew J. Kelly" <sqlmvpnooospamshadhawk.com> skrev i melding
    news:Ol2pfA7RDHA.2084TK2MSFTNGP11.phx.gbl...
    > It doesn't look as if the two tables really are identical since it is
    > complaining about needing to convert one of the columns. Maybe if you
    post
    > the actual code and the actual DDL for both tables we can make some sense
    of
    > it.
    >
    >
    > --
    >
    > Andrew J. Kelly
    > SQL Server MVP
    >
    >
    > "Alexander Ris°y" <alexnebb.no> wrote in message
    > news:_GyPa.5626$os2.83280news2.e.nsc.no...
    > > Hi,
    > >
    > > ERROR (at execution):
    > > "Disallowed implicit conversion from data type datetime to data type
    > > tinyint, table "xyz.dbo.tmpTrenddata', column 'xyz'. Use the CONVERT
    > > function to run this query."
    > >
    > > PURPOSE:
    > > To get one table (current batch) to copy its contents (only some rows
    with
    > a
    > > specific batch number) to another (log) table. The log table will
    > typically
    > > gain 10GB in a year.
    > >
    > > ADDITIONAL:
    > > The two tables are identical, all columns in the same order with same
    data
    > > types. Both have autonumber ID fields. tmpTrenddata currently contains
    no
    > > data.
    > >
    > > PROCEDURES:
    > > -----------------------------------------------------------------
    > > CREATE PROCEDURE "get_batch_current"
    > > (
    > > batchnr int
    > > )
    > > AS
    > > SELECT * FROM tmpCurrentBatch WHERE Batch = batchnr
    > > -----------------------------------------------------------------
    > > CREATE PROCEDURE "move_batch_to_log"
    > > (
    > > batchnr int
    > > )
    > > AS
    > > INSERT INTO tmpTrenddata
    > > EXECUTE get_batch_current batchnr
    > > -----------------------------------------------------------------
    > >
    > > Running MSSQL7 (MSDE) on WinNT4S/SP6. I am not very experienced with
    MSSQL
    > > procedures, but competent at SQL.
    > >
    > > --
    > > Best regards,
    > >
    > > Alexander Ris°y
    > > IT Team
    > > Nebb Engineering
    > >
    > >
    >
    >

    Alexander Ris°y Guest

  4. #4

    Default Re: (Stored Procedures) Can't get one table to move contents to another

    I agree with Jacco. You should always specify the column names for both the
    INSERT and SELECT parts. Never use * in production code.

    --

    Andrew J. Kelly
    SQL Server MVP


    "Jacco Schalkwijk" <NOSPAMjaccoseurostop.co.uk> wrote in message
    news:ucqwwi7RDHA.940TK2MSFTNGP11.phx.gbl...
    > I think the columns might not be in the same order.
    > Can you run the following script in query yzer and make sure that the
    > columns match up exactly?:
    >
    > EXEC get_batch_current -1
    >
    > SELECT * FROM tmpTrenddata WHERE 1=0
    >
    > And can you generete a table script from Enterprise Manager? Rightclick
    the
    > table and choose Generetae SQL Script
    >
    >
    > --
    > Jacco Schalkwijk MCDBA, MCSD, MCSE
    > Database Administrator
    > Eurostop Ltd.
    >
    >
    > "Alexander Ris°y" <alexnebb.no> wrote in message
    > news:rjzPa.5636$os2.83301news2.e.nsc.no...
    > > Hi,
    > >
    > > At the bottom you see the defenition of the two tables. I have printed
    > them
    > > out and held the two sheets on top of each other and they are entirely
    > > identical (I'd be very surprised if you find them to be different :-)
    > >
    > > Here is all the info I have:
    > >
    > > ---------------------------------------
    > > get_batch_current PROC
    > > ---------------------------------------
    > > Create Procedure get_batch_current
    > > (
    > > batchnr int
    > > )
    > > As
    > > SELECT * FROM tmpCurrent WHERE Batch = batchnr
    > >
    > > ---------------------------------------
    > > move_batch_to_log PROC
    > > ---------------------------------------
    > > Create Procedure "move_batch_to_log"
    > > (
    > > batchnr int
    > > )
    > > As
    > > INSERT INTO tmpTrenddata
    > > EXECUTE get_batch_current batchnr
    > >
    > > ---------------------------------------
    > > tmpCurrent DATA:
    > > ---------------------------------------
    > > ID Batch Tidspunkt padrag
    > > 1 1 01.01.2003 10
    > > 2 1 02.01.2003 12
    > > 4 2 01.01.2003 5
    > > 5 2 02.01.2003 7
    > > 6 2 03.01.2003 9
    > >
    > > ---------------------------------------
    > > tmpTrenddata DATA:
    > > ---------------------------------------
    > > - Empty -
    > >
    > > ---------------------------------------
    > > tmpTrenddata (this is the log) TABLE DEF:
    > > ---------------------------------------
    > > 3 ID int 4 10 0 0 1 1 1 0
    > > 0 Batch int 4 10 0 0 0 0
    > > 0 Tidspunkt datetime 8 0 0 0 0 0
    > > 0 padrag tinyint 1 3 0 1 0 0
    > > 0 O2 tinyint 1 3 0 1 0 0
    > > 0 N2 smallint 2 5 0 1 0 0
    > > 0 vifteHast1 smallint 2 5 0 1 0 0
    > > 0 vifteHast2 smallint 2 5 0 1 0 0
    > > 0 vifteHast3 smallint 2 5 0 1 0 0
    > > 0 vifteHast4 smallint 2 5 0 1 0 0
    > > 0 vifteHast5 smallint 2 5 0 1 0 0
    > > 0 vifteHast6 smallint 2 5 0 1 0 0
    > > 0 vifteHast7 smallint 2 5 0 1 0 0
    > > 0 vifteHast8 smallint 2 5 0 1 0 0
    > > 0 luftTemp1 smallint 2 5 0 1 0 0
    > > 0 luftTemp2 smallint 2 5 0 1 0 0
    > > 0 luftTemp3 smallint 2 5 0 1 0 0
    > > 0 luftTemp4 smallint 2 5 0 1 0 0
    > > 0 luftTemp5 smallint 2 5 0 1 0 0
    > > 0 luftTemp6 smallint 2 5 0 1 0 0
    > > 0 luftTemp7 smallint 2 5 0 1 0 0
    > > 0 luftTemp8 smallint 2 5 0 1 0 0
    > > 0 luftTemp9 smallint 2 5 0 1 0 0
    > > 0 luftTemp10 smallint 2 5 0 1 0 0
    > > 0 luftTemp11 smallint 2 5 0 1 0 0
    > > 0 luftTemp12 smallint 2 5 0 1 0 0
    > > 0 luftTemp13 smallint 2 5 0 1 0 0
    > > 0 luftTemp14 smallint 2 5 0 1 0 0
    > > 0 luftTemp15 smallint 2 5 0 1 0 0
    > > 0 luftTemp16 smallint 2 5 0 1 0 0
    > > 0 godsTemp1 smallint 2 5 0 1 0 0
    > > 0 godsTemp2 smallint 2 5 0 1 0 0
    > > 0 godsTemp3 smallint 2 5 0 1 0 0
    > > 0 godsTemp4 smallint 2 5 0 1 0 0
    > > 0 godsTemp5 smallint 2 5 0 1 0 0
    > > 0 godsTemp6 smallint 2 5 0 1 0 0
    > > 0 godsTemp7 smallint 2 5 0 1 0 0
    > > 0 godsTemp8 smallint 2 5 0 1 0 0
    > > ---------------------------------------
    > > tmpCurrent TABLE DEF:
    > > ---------------------------------------
    > > 3 ID int 4 10 0 0 1 1 1 0
    > > 0 Batch int 4 10 0 0 0 0
    > > 0 Tidspunkt datetime 8 0 0 0 0 0
    > > 0 padrag tinyint 1 3 0 1 0 0
    > > 0 O2 tinyint 1 3 0 1 0 0
    > > 0 N2 smallint 2 5 0 1 0 0
    > > 0 vifteHast1 smallint 2 5 0 1 0 0
    > > 0 vifteHast2 smallint 2 5 0 1 0 0
    > > 0 vifteHast3 smallint 2 5 0 1 0 0
    > > 0 vifteHast4 smallint 2 5 0 1 0 0
    > > 0 vifteHast5 smallint 2 5 0 1 0 0
    > > 0 vifteHast6 smallint 2 5 0 1 0 0
    > > 0 vifteHast7 smallint 2 5 0 1 0 0
    > > 0 vifteHast8 smallint 2 5 0 1 0 0
    > > 0 luftTemp1 smallint 2 5 0 1 0 0
    > > 0 luftTemp2 smallint 2 5 0 1 0 0
    > > 0 luftTemp3 smallint 2 5 0 1 0 0
    > > 0 luftTemp4 smallint 2 5 0 1 0 0
    > > 0 luftTemp5 smallint 2 5 0 1 0 0
    > > 0 luftTemp6 smallint 2 5 0 1 0 0
    > > 0 luftTemp7 smallint 2 5 0 1 0 0
    > > 0 luftTemp8 smallint 2 5 0 1 0 0
    > > 0 luftTemp9 smallint 2 5 0 1 0 0
    > > 0 luftTemp10 smallint 2 5 0 1 0 0
    > > 0 luftTemp11 smallint 2 5 0 1 0 0
    > > 0 luftTemp12 smallint 2 5 0 1 0 0
    > > 0 luftTemp13 smallint 2 5 0 1 0 0
    > > 0 luftTemp14 smallint 2 5 0 1 0 0
    > > 0 luftTemp15 smallint 2 5 0 1 0 0
    > > 0 luftTemp16 smallint 2 5 0 1 0 0
    > > 0 godsTemp1 smallint 2 5 0 1 0 0
    > > 0 godsTemp2 smallint 2 5 0 1 0 0
    > > 0 godsTemp3 smallint 2 5 0 1 0 0
    > > 0 godsTemp4 smallint 2 5 0 1 0 0
    > > 0 godsTemp5 smallint 2 5 0 1 0 0
    > > 0 godsTemp6 smallint 2 5 0 1 0 0
    > > 0 godsTemp7 smallint 2 5 0 1 0 0
    > > 0 godsTemp8 smallint 2 5 0 1 0 0
    > > ---------------------------------------
    > >
    > > --
    > > Best regards,
    > >
    > > Alexander Ris°y
    > > IT Team
    > > Nebb Engineering
    > >
    > > "Andrew J. Kelly" <sqlmvpnooospamshadhawk.com> skrev i melding
    > > news:Ol2pfA7RDHA.2084TK2MSFTNGP11.phx.gbl...
    > > > It doesn't look as if the two tables really are identical since it is
    > > > complaining about needing to convert one of the columns. Maybe if you
    > > post
    > > > the actual code and the actual DDL for both tables we can make some
    > sense
    > > of
    > > > it.
    > > >
    > > >
    > > > --
    > > >
    > > > Andrew J. Kelly
    > > > SQL Server MVP
    > > >
    > > >
    > > > "Alexander Ris°y" <alexnebb.no> wrote in message
    > > > news:_GyPa.5626$os2.83280news2.e.nsc.no...
    > > > > Hi,
    > > > >
    > > > > ERROR (at execution):
    > > > > "Disallowed implicit conversion from data type datetime to data type
    > > > > tinyint, table "xyz.dbo.tmpTrenddata', column 'xyz'. Use the CONVERT
    > > > > function to run this query."
    > > > >
    > > > > PURPOSE:
    > > > > To get one table (current batch) to copy its contents (only some
    rows
    > > with
    > > > a
    > > > > specific batch number) to another (log) table. The log table will
    > > > typically
    > > > > gain 10GB in a year.
    > > > >
    > > > > ADDITIONAL:
    > > > > The two tables are identical, all columns in the same order with
    same
    > > data
    > > > > types. Both have autonumber ID fields. tmpTrenddata currently
    contains
    > > no
    > > > > data.
    > > > >
    > > > > PROCEDURES:
    > > > > -----------------------------------------------------------------
    > > > > CREATE PROCEDURE "get_batch_current"
    > > > > (
    > > > > batchnr int
    > > > > )
    > > > > AS
    > > > > SELECT * FROM tmpCurrentBatch WHERE Batch = batchnr
    > > > > -----------------------------------------------------------------
    > > > > CREATE PROCEDURE "move_batch_to_log"
    > > > > (
    > > > > batchnr int
    > > > > )
    > > > > AS
    > > > > INSERT INTO tmpTrenddata
    > > > > EXECUTE get_batch_current batchnr
    > > > > -----------------------------------------------------------------
    > > > >
    > > > > Running MSSQL7 (MSDE) on WinNT4S/SP6. I am not very experienced with
    > > MSSQL
    > > > > procedures, but competent at SQL.
    > > > >
    > > > > --
    > > > > Best regards,
    > > > >
    > > > > Alexander Ris°y
    > > > > IT Team
    > > > > Nebb Engineering
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >
    >

    Andrew J. Kelly Guest

  5. #5

    Default Re: (Stored Procedures) Can't get one table to move contents -two words

    int 4 is interpreted as the word int and the number 4.
    After that some records just don't have all 6 columns. (you wanted 5 )
    if you replace int 4 with int_4 things will work

    "Andrew J. Kelly" <com> wrote in message
    news:phx.gbl... 
    post 
    of [/ref]
    with 
    > typically [/ref]
    data [/ref]
    no [/ref]
    MSSQL 
    >
    >[/ref]


    Jay Guest

  6. #6

    Default Re: (Stored Procedures) Can't get one table to move contents to another

    Try using
    QUOTENAME ( 'character_string' [ , 'quote_character' ] )

    when you query the first table.
    Then you get to have spaces in names.

    "Alexander Ris°y" <no> wrote in message
    news:_GyPa.5626$e.nsc.no... 

    typically 


    Jay Guest

Similar Threads

  1. Stored Procedures
    By Anthony M. Davis in forum Coldfusion - Advanced Techniques
    Replies: 28
    Last Post: February 9th, 03:17 PM
  2. dt_ Stored Procedures
    By chopper in forum ASP Database
    Replies: 2
    Last Post: July 20th, 04:06 PM
  3. New to ASP and Stored Procedures
    By John Berman in forum ASP Database
    Replies: 6
    Last Post: February 28th, 01:37 AM
  4. Stored Procedures and 4GL
    By Ahmer Sajjad in forum Informix
    Replies: 1
    Last Post: September 9th, 01:23 PM
  5. Stored procedures and database in the table
    By Bhupesh Saini in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 6th, 08:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139