You have replication in your test environment? Please don't tell me it's from a live server? OK, we're back to my original suggestion of taking a backup of...

Pedro

Sure you can. Check out the...

In this case, yes. I'd take an extra differential just before you start (ie before creating the snapshot).

You don't apply the changes using the snapshot. If you're happy...

Do the tables in question in the subscription database have exactly the same constraints as those in the publication database? What about triggers? In the properties of the...

Transactional replication? If you've inserted or deleted any rows at the subscriber at any time since the last initialisation then yes, there will be discrepancies.

John

Why not? You're not changing any data if you cast as date. I understand...

CREATE TABLE #John (j datetime)

INSERT INTO #John VALUES ('2016-11-10 12:12:42.100')

SELECT j FROM #John

WHERE j BETWEEN '20161201' and '20161213'

[font="Courier New"](0 row(s) affected)[/font]

John

WHERE UPDATED_DATE BETWEEN '20161201' and '20161213'

Bear in mind that this won't capture anything that happened on 13th, unless it happened at midnight (20161213 00:00:00). If you want to...

What data type is the UPDATED_DATE column?

John

Unless you post the query, I'm just guessing. I imagine that you have different data in the tables on the two servers.

John

Dave

Have you considered using the DATEFROMPARTS function?

John

No need for a loop in your function. This will work for any number of weeks up to 10.DECLARE @weeks tinyint;

DECLARE @no int;

SET @no = 16;

SET @weeks = 3;

WITH...

Please will you provide table DDL in the form of a CREATE TABLE statement, sample data in the form...

Celine

I'm sorry, you've lost me. Please will you provide table DDL in the form of a CREATE TABLE statement, sample data in the form of INSERT statements, expected results,...

CASE

WHEN SUM([Contribution Amount]) <= 7500 THEN ''

ELSE 'Total over £7,500'

END

John