I think this code will do what you need:

[font="Courier New"];WITH cteInvalidRecords AS

   (  

   SELECT

       UniqueName,

       ParentRef,

       MIN(ModifiedUTC) AS ModfiedUTC

   FROM

       dbo.CmsContent

   GROUP BY

       UniqueName,

       ParentREF

   HAVING

       COUNT(OID) > 1

  ...

You have a typo in your query. Check out the BOLD and CAPITALIZED stuff:

UPDATE dbo.tblClmsRx

SET dbo.tblClmsRx.RxPrescriberLName = LTRIM(RTRIM(dbo.tblPharmacyCLAIMSTemp.LastName))

FROM dbo.tblClmsRx

INNER JOIN dbo.tblPharmacyCLAIMTemp ON (dbo.tblClmsRx.RxClaimNum = dbo.tblPharmacyClaimTemp.RxClaimNum)

Claim is...

Check out the RAND function in BOL.

Sreemati,

I rewrote your query using a LEFT OUTER JOIN because I understand them better. The order is get the deceased patients for your practice and then go out and...

Nice explanation Grant.

Nomvula,

Based on the information you provided it does not appear that you need 2 tables. You could do the report with 1 table with a group on Batch Number....

Nice article. I also would be interested in the any difference in restore times. I am not working with VLDB'd or even LDB's so backup time is not...

You do not have an id column in the inserted table because you do not have an id column in your base table. Your code should be:

[font="Courier New"]CREATE      PROC [dbo].[getSelectCertNumber]

AS

        DECLARE...

There is a multi-part column at database journal called SQL Credit that walks you through the whole process from design to re-factoring.

How about this:

[font="Courier New"]SELECT

   RTRIM(LTRIM(CAST(CONTACT.ID AS VARCHAR(20))))+'--'+CAST(SALESCONTRACT.CONTRACTID AS VARCHAR(20)),

   CONTACT.FNAME +' '+CONTACT.LNAME,

   SUM(CASE

           WHEN MDTRANS.TRANSDATE > DATEADD(DAY, -10, GETDATE()) AND MDTRANS.AMOUNT > 0, MDTRANS.AMOUNT

           WHEN MDTRANS.TRANSDATE <= DATEADD(DAY, -10,...

Here's something similar to what I suggested in this thread:

[font="Courier New"]CREATE TABLE #MyTable (GroupCode CHAR(1), Num INT)

GO

INSERT INTO  #MyTable

        SELECT 'A',1

        UNION SELECT 'A',2

        UNION SELECT 'A',3

        UNION SELECT 'B',1

        UNION SELECT 'B',2

        UNION SELECT 'B',3

        UNION SELECT...

I don't know why it would rollback all unless it considered them all being nested within a a larger transaction which then rolled back when you killed one. I...

Yeah that would be it. Wrapping in the URL tag adds the http://.

Tom...

Great catch Todd. ...