I used ID, there was no reason behind it 🙂

you can go with Foreach Loop container to pick each diffrent set and write to an excel file.

MDX and DMX and data mining, Poor at SSAS :w00t:

you can take the data into temp table and then use some T SQL to validate or do some join in sql to get the correct data and then store...

support ends in the begining of 2016 or at the end of 2015

easy one on monday morning 🙂

replication is at object level and it is not dependent on the recovery model of the database so it can be simple, full, bulk logged.

when you are using the export wizard , you can actually save that as a package and schedule the same in the agent jon, you just need to know how...

CREATE TRIGGER [dbo].[MyTrigLI]

ON [dbo].[MPanel]

AFTER INSERT,UPDATE

AS

BEGIN

SET NOCOUNT ON;

Update M

set M.FPID = '1'

From MPanel M

Inner Join INSERTED I On I.ID =...

simple. Screen shots are more

I am not sure if you are looking to do the same case in the where clause to compare the product and order load date with the start and end...

must be some permission issue with the execution account that agent job is running, did u tried with the file system ,plz post the error

informative question learned something new again today

simple one

Just check if you are looking some thing like this Query,

update testtable1

set lotCurrentQty = 0,

lotNetWeight = 0 ,

NbPal = 0

where id not in (

Select * from testtable1

where spcode is not...