Yes,you can nest if statements in storedprocedure

example

create procedure dbo.exampleSp

(@RefreshFactweekly int,@RefreshFactMonthly int)

WITH RECOMPILE

as

begin

declare @CurrYr int

select @curryr=FiscalyearId from Salesdate  where SDate=getdate()

if  @RefreshFactweekly = 1

 begin

  if @RefreshFactMonthly = 1

  begin

 Insert prodsales

 Select d.id from products...

hi,

When you calculate for weighted average as

 sum({{[Measures].[Takers]}*{[Measures].[Score]}}) /

count({[Measures].[Takers]})

Even if syntax is correct,it will give...

According to me you can not pass parameter in inline queries for DTS SQL task.

Generally the parameters is passed in query using "?" then setting input parameter from global variable.

example  

Create...

Whenever you deploy your dts package to another machine you do have to give location of .ini file path if the path is not mapped properly.

One more way to set...

Hi,

Following script will give you same result as above VB code,without using cursor.

Declare @Found varchar(100),

        @Results varchar(100),

        @STR varchar(100),

        @length int,

        @leng int

       set @STR =...

Hi,

You have to specify the level of the time dimension, Find below the example.

If the lowest level is week.If Lowest level is day the change...

sum(filter([time].currentmember,(([measures].[Duration])>0)))

/count(filter([time].currentmember,(([measures].[Duration])>0)))

 

I hope this will help you