Post reply

How to find the user map to different tables

  • October 26, 2010 at 1:35 am

    #240147

    Hi,

    Is it possible to find the single user map to different table using SQL Query.

    Thanks,

    Senthil Varadharajan.

  • October 26, 2010 at 3:12 am

    #1242100

    I did not understand your question correctly.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • October 26, 2010 at 3:26 am

    #1242104

    Hi Adiga,

    I need to find the particular userid referenced to how many tables in the application.

    Eg: If Login UserID = 1. I need to find the values used in how many tables.

    Thanks

    Senthil Varadharajan.

  • October 26, 2010 at 3:59 am

    #1242117

    Senthil Varadharajan (10/26/2010)

    Hi,

    Is it possible to find the single user map to different table using SQL Query.

    Thanks,

    Senthil Varadharajan.

    This isn't a properly formed question, it makes no sense as it stands. Please provide more information.

    Are you saying each table in the database has a UserID column?

    If so, are you asking how to return every row from every table which has a particular value in the UserID column?

    If so, how would you expect the results to be returned, because it's unlikely that they could be UNIONed into the same output?

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

  • October 26, 2010 at 5:52 am

    #1242170

    Hi,

    Yes i need to get the return values from every table where the particular value in the UserID Column.

    Thnks,

    Senthil.

    ChrisM@home (10/26/2010)

    Senthil Varadharajan (10/26/2010)

    Hi,

    Is it possible to find the single user map to different table using SQL Query.

    Thanks,

    Senthil Varadharajan.

    This isn't a properly formed question, it makes no sense as it stands. Please provide more information.

    Are you saying each table in the database has a UserID column?

    If so, are you asking how to return every row from every table which has a particular value in the UserID column?

    If so, how would you expect the results to be returned, because it's unlikely that they could be UNIONed into the same output?

Viewing 5 posts - 1 through 4 (of 4 total)

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