Forum Replies Created

Viewing 3 posts - 76 through 79 (of 79 total)

  • RE: Distinct values from all the columns of a sql 2005 table

    Hi ramesh sir,

    I am your big fan...

    and i know you...

    You are working with infoton right...

    Vaibhav

    Vaibhav K Tiwari
    To walk fast walk alone
    To walk far walk together

    February 25, 2010 at 4:00 am

    #1124826

  • RE: How to rotate columns into rows

    Try this

    SELECT range , Count FROM

    (

    SELECT COUNT(CASE WHEN DATEDIFF(dd, createdon, modifiedon) < 1 THEN 1

    END) AS '< 1' ,

    COUNT(CASE WHEN DATEDIFF(dd, createdon, modifiedon) > 1

    AND DATEDIFF(dd, createdon, modifiedon) <=...

    Vaibhav K Tiwari
    To walk fast walk alone
    To walk far walk together

    February 25, 2010 at 3:55 am

    #1124824

  • RE: Best example of grouping ???

    Yes paul you understood....

    because over the internet a lot of material is available but its hard to get the best example sorry example which can easily differentiate the things to...

    Vaibhav K Tiwari
    To walk fast walk alone
    To walk far walk together

    February 22, 2010 at 12:45 am

    #1122735

Viewing 3 posts - 76 through 79 (of 79 total)