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

So you are adding back records to the student table that you think should be there. Could it be the students table was archived somewhere else and the history table...

If your goal is just to keep the two tables in sync you could just use transactional replication from the source to the subscriber (whichever server is which). if they...

You could add a checksum column on to apply to the columns wher you think the changes may occur. This will identify your row Id's that are out of sync....