Result with DENSE_RANK () in my code is the same as with ROW_NUMBER()

Thanks!

It should belong to the same group. I just was not sure on null values behaviour in the ranking function.

Thanks!

Actually after some experimenting I am convinced that null-containing records ARE included in the result set

And (out of the topic!) how to place the code into that nice lookink box as you do?

I need this record (with null in the field) to be included.

Not exactly. I need to get rid of duplicates in the existing table. I am using four fileds in the partition by list. One of these fields in some records...

Division by zero should be ERROR, not null. How come?

Thanks.

0 is false in this example

Thanks David,

I'll certainly take a look on 'injections'

Thanks Roy,

I rewrote the proc:

====================================

ALTER PROCEDURE [dbo].[sp_InsertFromSubformTryCatch]

@tblName nvarchar (50),

@CaseID int

AS

BEGIN try

Declare @SqlString nvarchar(100),@tcount int

begin transaction

SET NOCOUNT ON

set xact_abort on

--=== First we need to delete records from the main...

Thanks, parentheses worked! Now - another problem:

1) This is the procedure:

===================================

alter PROCEDURE [dbo].[sp_InsertFromSubform]

@tblName nvarchar (50),

@CaseID int

AS

begin transaction

SET NOCOUNT ON;

Declare @SqlString nvarchar(100)

--set @tblName=@tblName

select @SqlString='Delete ' + @tblName + '...

Thank you Matt.

This code worked perfectly well: the error record was written into the Error Log table, and catch print message did not show up. So ... what's now?

Thanks. I'll try this one. But look, if I run this procedure:

=================

ALTER Proc [dbo].[sp_ErrorTest]

as

begin try

select 1/0

end try

begin catch

exec sp_SqlInsertError

end catch

==========================

the sp_SqlInsertError works OK, e.g. inserts a row into ErrorLog table.