Forum Replies Created

Viewing 15 posts - 1 through 15 (of 24 total)

  • RE: convert binary to string format...

    Really appreciate your help Ninja...

    thanks a lot...

    June 28, 2011 at 11:47 am

    #1345393

  • RE: convert binary to string format...

    Ninja's_RGR'us (6/28/2011)

    if convert(VARCHAR(2000), colname) doesn't work then you need to use the actual application to read it.

    so you say that we cant convert the column using SQL...? When I tried...

    June 28, 2011 at 10:55 am

    #1345352

  • RE: convert binary to string format...

    Ninja's_RGR'us (6/28/2011)

    It's a text comment put in a varbinary column? Are you sure this is not a blob of some sort like .doc or .pdf?

    I'm not really that familiar...

    June 28, 2011 at 10:39 am

    #1345332

  • RE: convert binary to string format...

    Ninja's_RGR'us (6/28/2011)

    Why do you need to convert that column to be able to join? I never had that restriction before!

    I just want to read what was there in that...

    June 28, 2011 at 10:17 am

    #1345311

  • RE: have any idea on what exactly is nolock and why do we need to use this...

    thanks a lot guys...

    now I understood what exactly nolock is....

    November 9, 2010 at 2:55 pm

    #1248608

  • RE: help needed with datetimes

    thanks a lot Craig for all your help...

    November 3, 2010 at 8:09 am

    #1246010

  • RE: help needed with datetimes

    Can you help me structuring this #tmp table...

    This is my root and to which I need to add the rows column...

    select k.ChangeId, k.refOTSid, k.OTtime, k.DateClosed, k.DateChanged, rowid from

    (select top...

    November 2, 2010 at 2:29 pm

    #1245732

  • RE: help needed with datetimes

    Craig Farrell (11/1/2010)

    NOTE: You need the #tmp here, it's not the source data build. It works off the sample data you gave us earlier. What this does is...

    November 2, 2010 at 9:34 am

    #1245494

  • RE: help needed with datetimes

    let me try to analyze this and implement with my table...

    Thanks a lot for your help...

    November 1, 2010 at 6:42 pm

    #1245158

  • RE: help needed with datetimes

    Craig Farrell (11/1/2010)

    There's a couple of different techniques and approaches to this and I don't want to give you an over-complicated one if unnecessary. You've posted in the 7.0/2k...

    November 1, 2010 at 6:11 pm

    #1245151

  • RE: help needed with datetimes

    yeah thank you...

    thats right...

    please help me how to achieve this...Actually I am from Cognos background so I dont have much familiarity with SQL and so I am trying to learn...

    November 1, 2010 at 6:04 pm

    #1245149

  • RE: help needed with datetimes

    Craig Farrell (11/1/2010)

    I still need to have a better understanding of this before I can even ask what to do with the non-datetimes:

    refotsid = 48242 then for the first row...

    November 1, 2010 at 5:55 pm

    #1245145

  • RE: help needed with datetimes

    oldlocal or newlocal are supposed to be datetime but when its parts then need some parts to fix so they are not sure of the datetime and when coming to...

    November 1, 2010 at 5:42 pm

    #1245141

  • RE: help needed with datetimes

    I tried create a table with the data in it...

    create table mytable

    (

    changeid int,

    refotsid int,

    OTtime datetime,

    Oldtype varchar(20),

    Oldlocal varchar(50),

    newtype varchar(20),

    newlocal varchar(50),

    DateChanged datetime,

    DateClosed datetime

    )

    inserting the rows in it...

    insert into mytable (Changeid, refotsid,...

    November 1, 2010 at 5:25 pm

    #1245137

  • RE: help needed with datetimes

    Thanks a lot for the reply Craig...

    let me try DDL by looking at the first link but please give me some time...

    November 1, 2010 at 3:44 pm

    #1245115

Viewing 15 posts - 1 through 15 (of 24 total)