Profile Picture

Question about SQL command to display chart based on particular login?

Posted By Rubab Sayeed 15 Years Ago

Question about SQL command to display chart based on particular login?...

Author
Message
Rubab Sayeed
Posted 15 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: Forum Members
Last Active: 15 Years Ago
Posts: 4, Visits: 1

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







Reading This Topic

1 active, 1 guest, 0 members, 0 anonymous.
No members currently viewing this topic!