Hi, I need some assistance with a particular SQL command. I am essentially trying to display a chart with info, which would be based upon the user logging in to the database.
For example, I have the following command:
SELECT billable,SUM(ytdhrs) AS ytd,SUM(ptdhrs) AS ptd FROM rpthoursworked WHERE ttk=[login] GROUP BY billable
^This basically is returning everybody's information who is logged onto Sharepoint.
However, I would like the command to represent information based upon individual logins. For example, if I log in, the chart would display only MY information which it would pull from the database as opposed to everybody elses.
Im sorry if it sounds confusing, please let me know if I should offer additional information. Thanks a lot