You can do that in an sp using a linked server like so :

P.S. This basicaly downloads the new bills since the last transfer

CREATE PROCEDURE [dbo].[SPNFacturationTransfererNouvellesFactures]

AS

SET NOCOUNT ON

DECLARE @NouvellesFactures...

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=221028

What's not working exactly??

Select * from dbo.TableName where 1 = 0

What the h3ck are you testing then if you're not ommiting some columns in one view that you are selecting in the other???

Not gonna mail this to you.

Simply do a single select :

Select columns from dbo.YourTable where DateCol between @StartDate and @EndDate.

Then simply present the data monthly if requested that way.

No offense, but why would you want to do that???

You pretty much answered your own question. Insert the records that don't exists in master.

Update the ones that exists and have a greater date version than the one in...

execute that string in the foreach sp :

'use ?

execute sp_addrolemember ''db_owner'',''adcnt\SQLAdmins''

execute sp_addrolemember ''db_owner'',''adcnt\SQLFull''

execute sp_addrolemember ''db_owner'',''adcnt\SQLRW''

execute sp_addrolemember ''db_datareader'',''adcnt\SQLR'''

You think I'm actually stupid enough to fall for that one???

What statement did you try to run exactly?

Are you trying to start an infinite loop???

Post the link back to this post but not from this one to the cross one .

ALTER TABLE TableName {ENABLE | DISABLE} TriggerName

However you cannot tell it to stop firing on delete but continue firing on inserts and updates.

Or actually you could simply change the altvalue to a decimal datatype (assuming it's doable and still the correct design).

Go with ElSE '0' instead of ELSE 0