X-Original-To: pgsql-sql-postgresql.org@postgresql.org
Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id D831A9FCD99
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 28 Aug 2006 04:54:06 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 65285-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 28 Aug 2006 07:54:04 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from web36405.mail.mud.yahoo.com (web36405.mail.mud.yahoo.com
	[209.191.91.197])
	by postgresql.org (Postfix) with SMTP id 684BF9FCD92
	for <pgsql-sql@postgresql.org>; Mon, 28 Aug 2006 04:54:04 -0300 (ADT)
Received: (qmail 547 invoked by uid 60001); 28 Aug 2006 07:47:23 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=HUwAlubIhphFbspRXZpekWeMaqRbI4qADH7robBirSBFYyqqiBVH518OaF0gJxJ6SFsZ012W7u27KklHCWxSyX1oI/ftHCg51bd/8jXvLkQm6EOmzYy9nZwDTmQaCnmjCALgs37V6Rmyn7CMTxGJJXO8dR4xkGeKy+2ioLIAN+U=
	;
Message-ID: <20060828074723.545.qmail@web36405.mail.mud.yahoo.com>
Received: from [61.11.56.17] by web36405.mail.mud.yahoo.com via HTTP;
	Mon, 28 Aug 2006 00:47:23 PDT
Date: Mon, 28 Aug 2006 00:47:23 -0700 (PDT)
From: Dinesh Tiwari <tiwaridinesh22@yahoo.com>
Subject: hi ........i have a query related to MS reporting services
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-2126077474-1156751243=:213"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=3.73 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS,
	HTML_30_40, HTML_MESSAGE
X-Spam-Level: ***
X-Archive-Number: 200608/211
X-Sequence-Number: 26169

--0-2126077474-1156751243=:213
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

HI to all of you. I am a new member of this group and this is my first mail in this group.I am working in MS Reporting services.And i am new in this job.
   
  I have a problem.
  There is a table which has many columns.
  and i have to give selection to client that he can select any top 10,25,500,1000, sales  by departmentment
  there are more than 10 department and he want to see top ten seelings in each department.
  How i can do it.
  without using top 10 syntax iin query.
  i dont have to use top 10 sales from table syntax.
  so please help me.
  Regards
  Dinesh Tiwari
   

 		
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls.  Great rates starting at 1¢/min.
--0-2126077474-1156751243=:213
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>HI to all of you. I am a new member of this group and this is my first mail in this group.I am working in MS Reporting services.And i am new in this job.</DIV>  <DIV>&nbsp;</DIV>  <DIV>I have a problem.</DIV>  <DIV>There is a table which has many columns.</DIV>  <DIV>and i have to give selection to client that he can select any top 10,25,500,1000, sales&nbsp; by departmentment</DIV>  <DIV>there are more than 10 department and he want to see top ten seelings in each department.</DIV>  <DIV>How i can do it.</DIV>  <DIV>without using top 10 syntax iin query.</DIV>  <DIV>i dont have to use top 10 sales from table syntax.</DIV>  <DIV>so please help me.</DIV>  <DIV>Regards</DIV>  <DIV>Dinesh Tiwari</DIV>  <DIV>&nbsp;</DIV><p>&#32;
		<hr size=1>Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. <a href="http://us.rd.yahoo.com/mail_us/taglines/postman7/*http://us.rd.yahoo.com/evt=39666/*http://messenger.yahoo.com"> Great rates starting at 1¢/min.
--0-2126077474-1156751243=:213--