<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
T-SQL
»
Group By query
Group By query
Rate Topic
Display Mode
Topic Options
Author
Message
Rdsaini
Rdsaini
Posted Monday, November 16, 2009 5:15 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, November 17, 2009 4:50 AM
Points: 2,
Visits: 25
Hi Guys
I am Working on Adventureworks2008 and i have a question about how can i get the employment history of an employees so that i am able to know that how long they are working for the company and how many different positions he/she worked for.....................
Please help me out
Thanks
Post #819739
bitbucket-25253
bitbucket-25253
Posted Monday, November 16, 2009 5:51 PM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 6:34 PM
Points: 2,021,
Visits: 5,963
OK but give us a little additional information... what table(s) contain the information you need? How are the tables linked (Foreign key) or?
What have you attempted (your T-SQL statement)
Also note you posted this to a SQL 2000 forum, and you appear to be using SQL 2008, now which is it?
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #819746
Bru Medishetty
Bru Medishetty
Posted Monday, November 16, 2009 5:54 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, March 18, 2010 9:03 AM
Points: 1,427,
Visits: 1,506
You seem to be starting with SQL Server.
Follow a good T SQL Server programming book and then practise that on AdventureWorks2008.
It would be better to post real time issues / questions that you are facing in these forums. rather than asking a fundamental question on T SQL.
You have asked a question on SQL 2008 Database in a SQL 7 / 2000 Forum.
Good...
Bru Medishetty
To get quick answers read the article
How to post data/code on a forum to get the best help
My Blog -
learnsqlwithbru.com
Post #819747
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
