Adi Cohn-120898 (1/31/2011)

---

It should work. I’ve just tested it with the script bellow. Do you have the problem when you run the select statement from a SSMS window...

Adi Cohn-120898 (1/31/2011)

---

Are you sure that this is the default schema? Can you check if this is the really the user’s default schema with this query?

select default_schema_name

from sys.database_principals

where name...

My Question is why it is not working when i write a Query like

select * From tableA

as my default schema is Risk.

It is Confusing because in his Query the parameter 1 does not mean that Number of samples.if you...

Koen (da-zero) (1/28/2011)

---

sharath.chalamgari (1/28/2011)

---

but if i cange the Query with some where condition,where i will get only one Row (sample) then the stdevp will results the null value

select stdev(pa_Rates) From...

I think the Explanation is bit confusing.

if you give any numeric value to the function without any from clause it will give NULL.

SELECT STDEV(100)

"The STDEV function uses all of the...

are you looking something like this

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE Procedure_Package

-- Add the parameters for the stored procedure here

@PackageCategory varchar(150),

@Package_Location varchar(50),

@Duration varchar(100),

@startRange int,

@EndRange int

AS

BEGIN

SET...

Please u write the Procedure first and then let us know where exactly you are Facing the Problem

again something new for me to learn.

Nice Question,needs little bit time to go through the Query

if you are talikng about the ssis packages you can execute and schedule it using sql job agent.

The below URL might help

http://www.sql-server-performance.com/articles/biz/Scheduling_a_SSIS_Package_in_SQL_Server_Agent_p1.aspx

Thanks Jeff for the article. i learned something about the datename function and these langauages settings.

i guess you are taking about the Procedure

sp_help_revlogin not the one you have mentioned. This Procedure is used to transfer the logins from one server to another server....

Good Work Paul!

I haven't seen any article that explains the database designing concepts like a story,easy to understand format. 🙂

Thanks adiga