You will need something consistant to join on. If the dates are not consistant, you will need something like an account number, or invoice or something the data can...

CREATE TABLE #Current (InvoiceDate datetime, Sales decimal(12,2))

CREATE TABLE #Previous (InvoiceDate datetime, Sales_PY decimal(12,2))

INSERT INTO #Current

SELECT '2010/04/01','163.20'

INSERT INTO #Current

SELECT '2010/04/02','1125.20'

INSERT INTO #Current

SELECT '2010/04/03','134.70'

INSERT INTO #Previous

SELECT '2009/03/01','69.87'

INSERT INTO #Previous

SELECT '2009/03/02','145.76'

INSERT INTO #Previous

SELECT...

This is OT 😛

My job title is DBA. I've never met anyone who's title was "True DBA".

The only things I got from Microsoft sponsered events were that the upcoming version of product X would be fully buzzword compliant.

That and a few tee shirts.

I believe the jobs will work, but the reports will need to be converted, if I recall correctly.

DECLARE @SourceDB as varchar(50)

DECLARE @sql nvarchar(max)

SET @SOurceDB = 'MyDB'

SET @sql = 'Select Field1, Field2, Field3 FROM ' + @SourceDB + '..MyTable'

print @sql -- To view the query prior...

Lots of reasons to have keys, this being another good one.

What you could do is save your 1 record you wish to preserve to a temp table, then delete all...

I would question why you really want to do that. If you really need to, you can ...

UPDATE MyBigTable SET col1 = '' WHERE col1 is NULL

for each column...

For a commercial ERP system, this is an extremely complex task. You will need either a utility provided by the software vendor, or a complete design document that describes...

Easiest way is to fail the job if any step fails. Then setup your database mail and add operators. Setup the job to notify your operator if the...

Thank you for the feedback.

declare @MyDate datetime

select @MyDate = '2/22/2010 8:20:06 PM'

select @MyDate, CONVERT(varchar,@MyDate, 101) + ' ' + CONVERT(varchar,@MyDate,114)

Yes. You can apply the same changes across each subscriber by dropping and recreating the index on each. When you re-initialize the replications, skip the syncronization. Assuming...

Someone correct me if I'm wrong, but I think you'll need to break your replication first, then drop and recreate the clustered index, then apply the snapshot and resync.