Viewing 15 posts - 14,731 through 14,745 (of 15,381 total)
Like Steve said, DTS is not the best avenue for this type of thing. A stored proc is what you want to use.
May 4, 2011 at 10:04 am
Ninja's_RGR'us (5/4/2011)
Ronald H (5/4/2011)
May 4, 2011 at 7:41 am
What is wrong with identity? It is designed for just this purpose, creating a new unique value without intervention. I would tend to shy away from using uniqueidentifier as a...
May 3, 2011 at 9:58 am
Couldn't you just order it by the date instead of the results of the dateadd function?
May 3, 2011 at 9:14 am
IRK (5/2/2011)
for getting the most recent values for each column
i may use row_number() with partition by table name,column name
Please help me how can join rows of a history...
May 3, 2011 at 7:09 am
Aww shucks. Thanks Dave. Had a somewhat slow afternoon at work today and decided to be mentor for a day. 😛
May 2, 2011 at 3:16 pm
happy to help. Hope you walked away learning something. Good luck on your test.
May 2, 2011 at 2:55 pm
normanshongo2003 (5/2/2011)
from Departments d
inner join
Employees e
on d.Department_No=e.Department_No
group by D.Department_No
order by AVG (annual_salary)
hiya, i get it with this query.but what if i had a list...
May 2, 2011 at 2:51 pm
/soapbox on
I feel bad for you but you are going to have to look up stuff. There are 2 choices for you. You can either go to an online forum...
May 2, 2011 at 2:38 pm
normanshongo2003 (5/2/2011)
select d.Department_No,top 1*(AVG(Annual_Salary)) AS Lowest_Avg_Annual_Salaryfrom Departments d
inner join
Employees e
on d.Department_No=e.Department_No
group by D.Department_No
order by AVG (annual_salary)
Does that work?
May 2, 2011 at 2:23 pm
normanshongo2003 (5/2/2011)
top clause...where does it go and how?lol
if "in the query via your keyboard" isn't enough explanation you might have to look it up. I have no problem helping you...
May 2, 2011 at 2:17 pm
Do you remember my first post? Both Dave and I said you need two things....order by and [???].
May 2, 2011 at 2:08 pm
ok...so now how to get the one you want?
May 2, 2011 at 2:01 pm
don't confuse yourself. You have the whole list just fine. Now order them by average salary.
May 2, 2011 at 1:53 pm
Viewing 15 posts - 14,731 through 14,745 (of 15,381 total)