Questions in topic: aggregates - SQL Server Q&A from the SQL Server Central community

x

login about faq Site discussion (meta-askssc)

Questions in topic: aggregates

1

votes

1

answers

967

views

Subquery, aggregate

Aug 03 '10 at 12:10 AM Fatherjack ♦♦ 38.8k

sub-query aggregates

0

votes

3

answers

1.5k

views

How to use group by, union, order by in a main and subquires?

Jun 07 '10 at 07:45 AM Fatherjack ♦♦ 38.8k

t-sql joins aggregates

0

votes

1

answers

935

views

Count the rawdata and insert into new table

Jun 07 '10 at 06:51 AM Fatherjack ♦♦ 38.8k

t-sql aggregates

0

votes

2

answers

1.1k

views

how to create a view without using CASE * updated*

Jun 02 '10 at 11:25 AM pete 1 1

sql-server-2000 select aggregates case-statement

0

votes

1

answers

480

views

add a sum into a field with values

May 27 '10 at 05:08 PM pete 1 1

view aggregates

0

votes

0

answers

738

views

Weighted Average Calculate Measure

May 18 '10 at 03:55 PM Chris 5 1

mdx aggregates

0

votes

2

answers

990

views

select only the last result

May 18 '10 at 02:15 PM tony 1 1 5

aggregates top

0

votes

1

answers

450

views

I need help with this please! NEED TO FIX BEFORE MONDAY :( Counting distinct values in a multivalue field for each group they belong to..

Apr 29 '10 at 09:04 AM keentolearn 2

sql-server-2005 aggregates

1

votes

1

answers

699

views

Is it possible to Join a query with a Count function and sort by the joined fields?

Apr 09 '10 at 09:07 PM David 11 11

sql-server-2000 joins aggregates

0

votes

0

answers

353

views

Query (Grouped By Quarters) needs to include 0 values

Apr 09 '10 at 03:48 PM MJC 1

aggregates

0

votes

2

answers

3.2k

views

Distinct column from union of multiple table and multiple columns

Mar 25 '10 at 05:37 PM graz ♦ 525

aggregates union

0

votes

3

answers

1.2k

views

sum(case ....) is coming up with wrong answer...need verification

Mar 02 '10 at 10:21 AM graz ♦ 525

t-sql aggregates case-statement

0

votes

1

answers

654

views

How should I organize a query of counts matching different criteria

Feb 14 '10 at 12:02 PM graz ♦ 525

sql-server-2005 t-sql select pivot aggregates

0

votes

1

answers

703

views

Count Week of Year

Jan 21 '10 at 01:20 AM user-734 (yahoo) 1

aggregates

0

votes

1

answers

774

views

Sql fails to rearrange the data in primary key column in ascending order and hence fails to return the actual max value.

Jan 19 '10 at 12:10 PM graz ♦ 525

sql-server-2000 aggregates

44 questions

65answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags

sql-server-2005 × 1834
t-sql × 913
sql-server-2000 × 454
joins × 100
select × 87
pivot × 65
view × 55
mdx × 50
sub-query × 45
aggregates × 44
case-statement × 36
union × 13
top × 9

posts per page 15 30 50

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.