SELECT DISTINCT...

  • quote:


    So ur suggesting to have new row in tb_reports table for each modification so that querying will be easy.I will try that.


    Yes, I do!

    In addition it will save a lot of headache looping through those strings and split and might speed up thing a bit.

    Good luck!

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply