If production conditions...

One way to assign more than one value to a variable is to use a table variable.

But the major issue with your code is slightly different: you're using the very...

Is it as annoying for you as it is for me to see all those spam posts?

Today (Sunday, August 10th), 22 out of 36 posts were plain spam. All from...

Both of your SLEECT statements between parenthesis ar missing the table alias at the end.

E.g.

SELECT @EMP_ID = ID FROM (SELECT ID, ROW_NUMBER() OVER (ORDER BY ID ASC) ROW_NUM FROM dbO.TD_EmployeeProfile_FinalV2)...

You can't reference a table with a variable unless you use dynamic SQL.

SELECT EMAIL_ADDR, ID FROM (@TABLE_NAME) won't work.

Since the value dbO.TD_EmployeeProfile_FinalV2 is assigned directly, whydon't you use it in...

Here's a slightly different approach:

create table #x (col1 int)

insert into #x

values

(202),(203),(204),(205),(209),(210),(211),(309),

(310),(311),(312),(313),(314);

WITH cte as

(

SELECT col1, ROW_NUMBER() OVER (ORDER BY col1) as id, col1 - ROW_NUMBER() OVER (ORDER BY col1) as...

I would add a Conditions table with the columns Condition, Step, NextStep.

In that table I'd store all the options for a specific Condition.

For example, Condition "A" can go from Step...

Are the row count values in sys.partitions accurate in general or is there a SQL Server version where the data started being "reliable" rather than "approximate"?

So, BOL is...

Quote from BOL(SS2K14):

rows (bigint): Indicates the approximate number of rows in this partition.

I'd like to change Eirikurs 2nd method just slightly to cover partitioned tables, too:

CREATE FUNCTION dbo.FN_COUNT_ROWS2

(

@TABLE_NAME NVARCHAR(128)

)

RETURNS TABLE

AS

RETURN

SELECT SUM(rows) AS ROW_COUNT FROM sys.partitions

WHERE object_id =...

I'd like to know about the concept of the app accessing data.

Is it through queries constructed at the app side? (including DML statements)?

Is there any "Wannabe-Converter" (like NHyperhate) involved?

How much...

You've mentioned to expect between 10 and 50 rows as the result set.

However, the actual execution plan returned more than 280.000 rows.

Are those rows really returned?

Or is there usually a...

MERGE is overkill here, I'd say.

You could use something along those lines:

UPDATE TableB

SET Descr = ISNULL(TableA.Descr ,'NA'), Name = CASE WHEN TableA.id IS NULL THEN TableA.Name ELSE TableB.Name END

FROM TableB

LEFT...

The reason I'm asking is fairly simple:

Based on the estimated execution plan there's nothing to indicate the long duration.

A few things can still be improved:

It seems like there are a...