Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 query on select statement

Author  Topic 

hekils
Starting Member

1 Post

Posted - 2008-06-11 : 07:31:24
Hello !

What is the query ,If I want to display the sum of comission paid on each dept from emp & dept tables,with dept no & location . comission column is in emp table & the rest in dept table.What if we have null values for commision

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-11 : 07:53:21
See http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
and then repost your question.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-06-11 : 07:55:47
And when you do repost your question, please make sure you have read this blog post first!
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -