Page 3 of 20 FirstFirst 1234513 ... LastLast
Results 21 to 30 of 197

Thread: IT Professionals

  1. #21
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,331
    Post Thanks / Like
    Quote Originally Posted by app_engine
    Danks, This guy is a SQL guru
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

  2. # ADS
    Circuit advertisement
    Join Date
    Always
    Location
    Advertising world
    Posts
    Many
     

  3. #22
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,331
    Post Thanks / Like
    Does any one know how to convert 'american date format' to 'british date' format in SQL server , without changing the coalltion??
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

  4. #23
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,331
    Post Thanks / Like
    ssabbaa I figured it out

    here goes

    SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY]
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

  5. #24
    Senior Member Diamond Hubber sakaLAKALAKAlaa Vallavar's Avatar
    Join Date
    May 2005
    Location
    Bangalore
    Posts
    8,156
    Post Thanks / Like
    linux experts, how to share internet btw 2 laptops running ubuntu, thru wifi?
    Vishwaroopam is a 220+ Crores Record breaking Blockbuster!
    https://twitter.com/KamalHaasanFans

    Uttama Villain Reviews Collection - http://goo.gl/MSBVxv

  6. #25
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,331
    Post Thanks / Like
    Sorry sakala , I am no linux expert
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

  7. #26
    Moderator Diamond Hubber aanaa's Avatar
    Join Date
    Mar 2005
    Location
    இந்திரலோகம்
    Posts
    7,315
    Post Thanks / Like
    friend of mine - suggested


    never envounted patterns like O', which is normally used to concatinate the strings in SQL. fpr normal names '%name%' should work.
    Is it working ?
    "அன்பே சிவம்.

  8. #27
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,331
    Post Thanks / Like
    aana

    Unga avatar and signature
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

  9. #28
    Moderator Diamond Hubber aanaa's Avatar
    Join Date
    Mar 2005
    Location
    இந்திரலோகம்
    Posts
    7,315
    Post Thanks / Like
    "அன்பே சிவம்.

  10. #29
    Senior Member Diamond Hubber PARAMASHIVAN's Avatar
    Join Date
    May 2009
    Location
    Kailash
    Posts
    8,331
    Post Thanks / Like
    Is any one familiar with the hardest thing in SQL code, known as Cursor?

    I will explain what I need to do..

    I have table A , and Table B

    Table A Table B
    --------- ------------

    First_name First_name
    Last_name Last_name
    Address1 Address1
    Adreess2 Address2


    What I want to do, see if the firstname and last_name in Table B exist in Table A, if so then I want to update Address1 and address2 in table A with a value. This is easy to do for couple of rows.

    using

    Update Table A
    set address1='test',
    address2='test2'
    where first_name in (select first_name from table B
    where first_name like 'Super')


    but the problem is in Table B , i have 10,000 first_name with values in the address1.. I need update table A9Address1) with a value based on table B's contact name, hence you end up with 10,,000 different names, with 10,000 different address, if it was just one addreess it would have been very easy, I can use the above script.

    any ideas any one ?
    Om Namaste astu Bhagavan Vishveshvaraya Mahadevaya Triambakaya Tripurantakaya Trikalagni kalaya kalagnirudraya Neelakanthaya Mrutyunjayaya Sarveshvaraya Sadashivaya Shriman Mahadevaya Namah Om Namah Shivaye Om Om Namah Shivaye Om Om Namah Shivaye

  11. #30
    Senior Member Platinum Hubber
    Join Date
    Oct 2004
    Posts
    12,702
    Post Thanks / Like
    Checking whether the first name / last name exists in table B is no big deal (for set processing, use EXISTS clause)

    OTOH, if you have 10000 NEW addresses to be updated to table A, you got to STORE those addresses in a table (unless the requirement is to directly update from a flat file, then you need a script). Obviously, this flat file or table with new address should have the name reference as otherwise how you're going to relate?

Page 3 of 20 FirstFirst 1234513 ... LastLast

Similar Threads

  1. IT Professionals
    By Raghu in forum Miscellaneous Topics
    Replies: 206
    Last Post: 19th July 2007, 10:09 AM

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
  •