The quick and very-dirty-in-this-case "solution" is to put a COMMIT TRANSACTION immediately before the END TRY.

But the whole process overall could be a lot cleaner and faster, particularly if:

auditlogid is...

keyser soze-308506 (11/27/2013)

---

Hi

I have a query like that

select c.client_group, s.product_id, count(*) as q

from Sales s

inner join Client c on c.client_id= s.client_id

group by c.client_id, s.product_id

the Sales.pk (clustered index) consist of...

L' Eomot Inversé (11/26/2013)

---

ScottPletcher (11/26/2013)

---

Luis Cazares (11/26/2013)

---

Here are 2 options to perform your calculation:

SELECT ABS(DATEPART( dayofyear, CutoffDate) - DATEPART( dayofyear, GETDATE())),

ABS(DATEDIFF( day, DATEADD( year, DATEDIFF( year, CutOffDate, GETDATE()), CutOffDate), GETDATE()))

FROM...

I don't think the...

I'd expect the restore time to generally be longer; if restoring to a new database, potentially significantly longer.

For a backup, SQL only needs to backup the active portion of the...

You could create a separate "key master" table, containing only an identity column and the four natural key columns, clustered on the natural key columns, NOT the identity.

Then, the first...

Use view "sys.dm_db_index_operational_stats".

Capture the values at the start time, then recapture them at any subsequent time, subtract the two values, and voila, you have the mods that occurred during that...

I'm not sure why you would want to insert all iterations of the list of values into the countryid table, but this should fix a couple of the potential errors...

IIRC == "If I recall correctly" == hedge in case I'm wrong 🙂

For more info on Change Tracking...

CDC could do it too, of course, but it has more overhead and is available only in Enterprise Edition; it's overkill for what you've described you need.

Change Tracking should handle your situation easily and completely. IIRC, CT requires that the table have a PRIMARY KEY defined.

Of course not all CTEs are going to be updateable, it will depend on the specific coding of the CTE ;-).

You don't have to use two ROW_NUMBER() clauses/entries:

;WITH detail AS (

SELECT *, ROW_NUMBER() OVER (ORDER BY id) AS row_num

FROM #test

)

SELECT

...

I don't think that's right. I think SQL uses data...

I don't understand the totaling logic you want.

"TOTAL 700"?? Is...