Forum Replies Created

Viewing 15 posts - 31 through 45 (of 236 total)

  • RE: Exists on where clause

    thank you allen.

    February 17, 2017 at 6:49 am

    #1929086

  • RE: Exists on where clause

    MessageId is foreign key in the @vendor and @vendor_custom table. so there is no way that data will be in @vendor table and not in @ message table. i didn't...

    February 16, 2017 at 2:34 pm

    #1928984

  • RE: Exists on where clause

    Hi Steve,

    thanks for the reply and it's not producing my actual result. Since the data exists on the @vendor, we should not pull any data from @vendor_custom. so logically...

    February 16, 2017 at 2:20 pm

    #1928978

  • RE: Exists Condtion

    thank you scott.

    February 7, 2017 at 7:23 pm

    #1927227

  • RE: Select case Logic

    Thanks everyone who tried to help me and Chris M solution worked for me. appreciated your time on this,

    February 2, 2017 at 9:52 am

    #1926393

  • RE: Date logic

    Sergiy - Tuesday, January 10, 2017 6:29 PM

    KGJ-Dev (1/9/2017)

    Hi Luis, thanks for the reply and i would like to put my requirement...

    January 18, 2017 at 6:59 pm

    #1923588

  • RE: Index Related Question

    GilaMonster - Monday, January 16, 2017 5:48 AM

    That code throws an error.
    Msg 4104, Level 16, State 1, Line 66
    The multi-part identifier "ic2.object_id"...

    January 16, 2017 at 7:52 am

    #1922984

  • RE: Index Related Question

    GilaMonster - Monday, January 16, 2017 2:51 AM

    The script you posted works.

    Check the name you're putting in the WHERE clause, and...

    January 16, 2017 at 5:38 am

    #1922950

  • RE: Table Space Related Question

    Hi Grant,

    Thanks for your reply.

    Hi Jeff,

    Thank you for your detailed explanation and this will be much helpful to me. Appreciated your time on this.

    January 15, 2017 at 7:54 pm

    #1922851

  • RE: Table Space Related Question

    Jeff Moden - Friday, January 13, 2017 2:57 PM

    Just in case you need authoritative justification to do so for TF 1118, please see...

    January 13, 2017 at 8:28 pm

    #1922724

  • RE: Table Space Related Question

    Hi Jeff,

    Thank you for your time on this post and could you please elaborate your point. Below are more explanation from my side

    Current table records: 0,...

    January 13, 2017 at 1:11 pm

    #1922683

  • RE: Table Space Related Question

    Grant Fritchey - Friday, January 13, 2017 11:09 AM

    The space left behind by the deletes isn't really space left in the table. It...

    January 13, 2017 at 12:33 pm

    #1922672

  • RE: Date logic

    thanks everyone for your time on this post and i could manage in different way. I just took the first created record time and added needed intraval(newdate) and kept in...

    January 9, 2017 at 8:39 pm

    #1921522

  • RE: Date logic

    Sure, i will explain again.

    I have a table and right now i have duplicates on the table. Only way i can clean the duplicates based on id, RecordInsertedDateTime.

    The most of...

    January 9, 2017 at 2:10 pm

    #1921497

  • RE: Date logic

    as like my sample i have 100*1000 records in my table and dense rank puts incremental number. basically i need the query to delete the duplicate records. any help please

    January 9, 2017 at 1:45 pm

    #1921491

Viewing 15 posts - 31 through 45 (of 236 total)