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....

Check the default language of the login accessing the data for your report. British English and English will interpret '08-01-2013' in different ways.

Where you trying to move the data using a linked server connection? You can map the SQL logins in this way using ( I don't mean the Windows logins).

Use a bit of caution, this may affect other views and stored procedures that use this column. They may, for instance, be...