Difference between STDEV & STDEVP

Can somebody please compare these 2 functions for me and explain with an example?

Thank You

You can find detailed description here (the second article has an example):

http://office.microsoft.com/en-us/assistance/HP010322691033.aspx

http://www.beyondtechnology.com/tips016.shtml

Quote:

STDEV is used when the group of numbers being evaluated are only a partial sampling of the whole population. The denominator for dividing the sum of squared deviations is N-1, where N is the number of observations ( a count of items in the data set ). Technically, subtracting the 1 is referred to as "non-biased."
STDEVP is used when the group of numbers being evaluated is complete - it's the entire population of values. In this case, the 1 is NOT subtracted and the denominator for dividing the sum of squared deviations is simply N itself, the number of observations ( a count of items in the data set ). Technically, this is referred to as "biased." Remembering that the P in STDEVP stands for "population" may be helpful. Since the data set is not a mere sample, but constituted of ALL the actual values, this standard deviation function can return a more precise result.

Difference between SPs

Can somebody tell or may refer to a site that show the differences between SQL Server 2000 SP2 and SP3a.
Thanks.http://support.microsoft.com/default.aspx?scid=kb;en-us;306908

Difference Between Query Parameters and Report Parameters

Hi Guys,
Can somebody explain me cleraly the difference between Query and Report
Parameters.
Report Parameters r automatically created when u put some variable in a
query.
2)
One more thing is there a way we can hide query string in the IE as I dont
want the users to see the report URL.
3)
My Stored Proc expects 2 parameters but I dont want to pass them in the URL
string is there any other way I can pass parameters to the report from the
front end other than URL strings
Many Many Thanks
Chandra
--
Message posted via http://www.sqlmonster.comwell report parameters r used to get input from the user for the report
and report parameters got attached with query parameters to pass on
input from the user to query in order to build query at run time when u
define query parameter in ur query report automatically generates a
report parameter and attach that report parameter to the specific query
parameter to see further details click EDIT DATASET option n click
parameters tab u ll c how report parameters r getting associated to
query parameters
as far as ur question of hiding parameters is concerned u got to use
reporting services class (SOAP API) n make ur own application to access
the reports instead of accessing reports through URL or u got to set
any property of Ineternet explorers in the registery to hide the
address bar and status bar as well
hope this answers
take care
regards|||Go here:
http://msdn.microsoft.com/library/en-us/RSCREATE/htm/rcr_creating_interactive_v1_50fn.asp?frame=true
It will tell you all you need to know about parameters.
"Chandra Kotha via SQLMonster.com" wrote:
> Hi Guys,
> Can somebody explain me cleraly the difference between Query and Report
> Parameters.
> Report Parameters r automatically created when u put some variable in a
> query.
> 2)
> One more thing is there a way we can hide query string in the IE as I dont
> want the users to see the report URL.
> 3)
> My Stored Proc expects 2 parameters but I dont want to pass them in the URL
> string is there any other way I can pass parameters to the report from the
> front end other than URL strings
> Many Many Thanks
> Chandra
> --
> Message posted via http://www.sqlmonster.com
>|||Others have answered most of your questions. Just a little bit more about
query parameters versus report parameters. RS does automatically create a
report parameter when you put in a query parameter. However, you do not have
to use it. You can set the query parameter to a different report parameter,
you can set it to an expression (which means that if you want you can first
have some custom code massage the report parameter first). A very common
scenario where there is not a one to one relationship between report and
query parameters is when you have several datasets in a report. Let's say I
have several datasets that all use a fromdate and todate. I sure don't want
the user to have to put in the same date multiple times. So, I delete the
extra report parameters and have all the datasets query parameters point to
the same set of report parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chandra Kotha via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:698d0fc48f2b42f69c5c9fdc8632204a@.SQLMonster.com...
> Hi Guys,
> Can somebody explain me cleraly the difference between Query and Report
> Parameters.
> Report Parameters r automatically created when u put some variable in a
> query.
> 2)
> One more thing is there a way we can hide query string in the IE as I dont
> want the users to see the report URL.
> 3)
> My Stored Proc expects 2 parameters but I dont want to pass them in the
URL
> string is there any other way I can pass parameters to the report from the
> front end other than URL strings
> Many Many Thanks
> Chandra
> --
> Message posted via http://www.sqlmonster.com|||Thanks Guys for ur responses
--
Message posted via http://www.sqlmonster.com

Difference Between primary key and unique key

Hi,
Can somebody explain me the difference between primary key
and unique key and in which scenarios we use them. please
explain with a example.
Regards
ChipThe primary distinction is that Primary key column(s) must be non-nullable
while Unique constraints allow a NULL value. Also, there can be only one
primary key in a table while there can be more than one Unique constraints
defined for a table.
--
Anith|||Hi,
Primary key :
- The key which will not allow any NULL Values.
- Will Create a Clustered Index by default.
Unique Key
- The Key will allow 1 Null Value
- Will Create a non clustered index by default
Since Primary key will not allow NULLS values it can be used in scenario to
preserve more data integrity
Thanks
Hari
MCDBA
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:12c4c01c3f6a9$9ac762d0$a401280a@.phx.gbl...
> Hi,
> Can somebody explain me the difference between primary key
> and unique key and in which scenarios we use them. please
> explain with a example.
> Regards
> Chipsql

Difference Between primary key and unique key

Hi,
Can somebody explain me the difference between primary key
and unique key and in which scenarios we use them. please
explain with a example.
Regards
ChipThe primary distinction is that Primary key column(s) must be non-nullable
while Unique constraints allow a NULL value. Also, there can be only one
primary key in a table while there can be more than one Unique constraints
defined for a table.
Anith|||Hi,
Primary key :
- The key which will not allow any NULL Values.
- Will Create a Clustered Index by default.
Unique Key
- The Key will allow 1 Null Value
- Will Create a non clustered index by default
Since Primary key will not allow NULLS values it can be used in scenario to
preserve more data integrity
Thanks
Hari
MCDBA
"Chip" <anonymous@.discussions.microsoft.com> wrote in message
news:12c4c01c3f6a9$9ac762d0$a401280a@.phx
.gbl...
> Hi,
> Can somebody explain me the difference between primary key
> and unique key and in which scenarios we use them. please
> explain with a example.
> Regards
> Chip