Post reply

Need Help !

  • October 3, 2007 at 6:50 am

    #118850

    if object_id('tempdb..#tmpValues') is not null

    drop table #tmpValues

    create table #tmpValues

    (

    myIDtinyintidentity(1,1),

    myValvarchar(10),

    minTicnumeric(5, 2),

    maxTicnumeric(5, 2)

    )

    insert #tmpValues( myVal, minTic, maxTic )

    select 'A', 0.2, 1.5

    union select 'B', 1, 1

    select * from #tmpValues

    if object_id('tempdb..#tmpValues') is not null

    drop table #tmpValues

    ========================================

    Output required ::

    myVal myValminTic maxTic

    1 A 0.2 1.5

    2 B 1 1

  • October 3, 2007 at 7:05 am

    #738579

    What is ticCount supposed to signify?

    Please edit your post and insert spacing as I cannot determine what data belongs in which column

    Far away is close at hand in the images of elsewhere.
    Anon.

  • October 3, 2007 at 7:14 am

    #738588

    Cross post

    See here also http://www.sqlservercentral.com/Forums/Topic406155-338-1.aspx

    N 56°04'39.16"
    E 12°55'05.25"

  • October 3, 2007 at 7:55 am

    #738616

    Peter Larsson (10/3/2007)

    Cross post

    Thanks Peter 🙂

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply