Thanks Lynn,

This question is directed to you

Did you mean something like this ?

@sql = ' use ' + @dbname + 'GO' + ' Insert/Update/Delete ..'

WITH CTE

AS

(SELECT [SITE]

,[Hospital]

,[LOCATION]

,[Real_Date_Time]

,[NURSE_ID]

,[PRIMARY_NAME]

,[ERROR_CODE]

,[PMP]

,[PAT_NUM]

,[UniqueID]

,[PTNAME]

,[SCANNED_DATA]

,[DRUG_DESC_SCAN_ERR]

,[Sig]

,[Sig_Desc]

,[Frequency]

,[SCH_PRN]

,ROW_NUMBER() over (partition by

datepart(hour,real_date_time)

,nurse_ID

,pat_num

,pmp <== may be null

,ERROR_CODE

order by

datepart(hour,real_date_time)

,nurse_ID

,Pat_num

,pmp

,ERROR_CODE) rNum

FROM LoadTblAllDatanoDuplicates, etc

)

DELETE FROM CTE WHERE ROWNUM > 1

AND PMP IS NOT NULL

What I understand is you want to make use of other columns irrespective of null in participating column. Please let me know if my understanding is correct.

Either use

[code="row_number...

can u please provide me 3 records with columns included in ranking function

Try Dense_Rank instead. Let me know if it work. Selecting distinct dense rank using CTE.

Betn remove "TGT. " in the Update statement as it will automatically comsider it target

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Please post some data according to the article to check the same.

EXEC sp_helpdb;

The MERGE SQL statement requires a semicolon (;) as a statement terminator. Otherwise Error 10713 is raised when a MERGE statement is executed without the statement terminator.

Its just the way...

Hi martin in case you have time can you let me know why you were passing a int (variable) and equating it to varchar inside it

I think if you check table properties it does show index usage space on the disk meaning there by a physical storage for indexes.

Hi Sir,

Can you clarify a bit about SSB ? Would it ensure an Email to my mail box for each entry in ErrorLog table ?

_______________________________________________________________________________________________

Thanks Jeff 🙂

Thanks Sir 🙂

WITH CTE AS

(SELECT A1,A2, ROW_NUMBER() OVER (PARTITION BY A1 ORDER BY A1) AS ROWNUM

FROM TEST

WHERE A2 = 1 OR A2 = 4

)

SELECT A1

FROM CTE

WHERE ROWNUM = 2

This...