Forum Replies Created

Viewing 15 posts - 61 through 75 (of 179 total)

  • RE: changing data types

    Hi Michael
    I just checked "modfying Default definitions" section but it talks abt "DEFAULTS" not datatypes.
    am missing something. i want to change datatype of a columns

    August 25, 2005 at 3:25 pm

    #585212

  • RE: changing data types

    Remi
     
    say i have table (mytable) with following cols
     
    pkey int pkey
    name varchar(10)
    notes text
     
    now i want to change datatype of  3rd col (ie. notes) to varchar say varchar(500).
     
    Hope thats clear.Thanks
     

    August 24, 2005 at 10:27 pm

    #584857

  • RE: no fo columns

    quick question Ian
    am just impoting a table from foxpro to sql and got following error

    Error: Preparation SQL Task: Warning: The table 'claim' has been created but its maximum row...

    August 23, 2005 at 8:20 pm

    #584449

  • RE: no fo columns

    Thanks for post Ian.we'd consider ur suggestions in our design.
    BTW do you suggest any website for good practices on database design,indexes etc.,
    Thanks again
     

    August 23, 2005 at 5:18 pm

    #584429

  • RE: LIKE condition

    Thanks Jeff
    for detailed info.that makes sense

    August 22, 2005 at 4:57 pm

    #584115

  • RE: LIKE condition

    Jeff
    quick question
     
    >>SELECT * from task where ' '+Descr+' ' LIKE '% myword %'
     
    abv works beautifully .but i cant figure out whats exactly its doing .can u explain it...

    August 22, 2005 at 3:07 pm

    #584098

  • RE: LIKE condition

    I think i know what i need .i cant use sqlbill suggestion as Remi pointed out it'd include words like "oneofwords".
    I think i'll use Jeff's suggestion.
    Thanks everyone for ur advise...

    August 22, 2005 at 3:00 pm

    #584095

  • RE: LIKE condition

    BTW Remi
    i just ran into other issue
    if a coulmn data ends with word am searching for then abv query will not return that record.
    i mean records like this
     
    "sql is...

    August 21, 2005 at 10:14 pm

    #583800

  • RE: LIKE condition

    thanks Remi.
    That worked nicely
    I thought there would be other way to avoid functions in query.

    August 21, 2005 at 9:58 pm

    #583797

  • RE: Tables as Stored Proc Parms

    Michael
    you might want to try dynamic sql.something like
    declare @p_sql varchar(1000)
     
     
    set @p_sql ='select * into #inserted from '+ @insertedTable
    exec(@p_sql )

    August 21, 2005 at 9:19 pm

    #583792

  • RE: group by

    Thanks suresh.

    ur query also worked nicely.in this case it also returns records which are not duplicated across patients.

    what i mean ,say i've 10 records with same invoice no "I1" for same patient and...

    July 20, 2005 at 6:10 pm

    #575951

  • RE: group by

    Thank u very much Journeyman and Noel .

    finally i got it sorted it in following way

    SELECT patient, invoice FROM Patients PInvoiceWHERE PInvoice.Invoice IN ...

    July 19, 2005 at 5:01 pm

    #575674

  • RE: group by

    Hi dude
    thanks for the post.
    The field pk is not a number it may contain char also

    July 19, 2005 at 12:10 am

    #575390

  • RE: date time query

    Andy

    I've 6 records with following date

    2003-11-03 00:00:00.000

    when i run ur second query it returns only 1 record!! i mean

    declare @x varchar(8)

    SET @x ='20030311'

    select taskid,taskname,entrydt from task

    where convert(varchar(8),task.entrydt,112) =...

    July 14, 2005 at 10:47 pm

    #574666

  • RE: date time query

    Thanks ND.

    that works fine. actually am looking for some general code

    as where condition can contain any of the following filters

    >,<,>=,<=

    any ideas please.

    Thanks

    July 13, 2005 at 8:03 pm

    #574222

Viewing 15 posts - 61 through 75 (of 179 total)