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


Question about SQL command to display chart based on particular login?...
Author
Message
Rubab Sayeed
Rubab Sayeed
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
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


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search