Have you considered using the SSIS execute sql task? You can map parameters to it. If you need to do many somewhat independent things as a batch, add them as...

Will do Gail, appreciate your help. Thanks

A stored procedure and a view will both return you a result set. A stored procedure can accept parameters, such as start date and end date... whereas a view cannot....

Hi Gail. I hope I don't trouble you if you could post this example you mention? I have not dived deeply into the subject of execution plans and am curious...

How would using the sign function fit here? I don't think you can have a negative average of dropped calls.

thanks

I would just add that if a start date is greater than an ending data, there should be no data returned. The user will get the point sooner or later,...

try this

declare @MyDate datetime

set @mydate= '20130301'

select replicate...

I installed this and works fine so far. No special tweaking needed. It looks like a fine tool. Thanks for the link Anthony.

Cheers

Not enough information here, but I can guess that this query would benefit from a filter by date on table B. (At the least).

I would think the agent credentials are used and not necessarily overridden by something else on the SSIS package.

You may need to specify the extension of the file in the file name. Also it appears you are recreating the job everyday, If the job with that name already...

Wondering if this got resolved. If so can you share how? thanks.

How you define your partition is partly if not fully influenced by business logic. If a sale has a 30 day return period then you can create each partition in...

Create the dimension tables. What if you want to know what stores generated no sales in some particular time frame?

With the ODD numbers, how is 7,5,3 related. Did you miss 7 is related to five?

thanks