So that they can't see data they shouldn't see. We have been seeing this question quite a bit more late ly on the forums.

IIRC, starting with SQL Server 2014...

Maybe the force is strong with this one. 😛

Here is a shot in the dark. If this doesn't help, you will need to provide more information.

with TestData as (

select...

Andrei Hetel (6/16/2015)

---

It could be another approach. If you are deleting 50% of the records as mentioned in the earlier post, it could be quicker to do something like this:

-...

Since this is a log table does that mean the event date is always increasing?

Is there a set of columns taken together that are unique?

Luis Cazares (6/16/2015)

---

This can be solved by adding one more ROW_NUMBER() function to create groups based on the SalesRep.

WITH

cteCust (RowNum, CustomerNumber, Division, SalesRepType, SalesRepNumber, BeginDate)

AS

(

SELECT

ROW_NUMBER() OVER (PARTITION By CustomerNumber,...

LeeFAR (6/16/2015)

---

I've been trying various ways to accomplish this and I think I've reached a mental brick wall. If anyone is up for it, please consider helping me find...

In addition...

First, how many rows are you deleting versus how many are you keeping?

Second, have you read this article: http://www.sqlservercentral.com/articles/T-SQL/67898/%5B/b%5D">http://www.sqlservercentral.com/articles/T-SQL/67898/

• This reply was modified 6 years, 12 months ago by Lynn Pettis.
• This reply was modified 5 years, 10 months ago by Steve Jones - SSC Editor.

Basically, it is the same reason just not positional based. All values returned in the CASE statement must be of the same data type. In...

Look at it this way. You are converting VARCHAR(30) to a DATE. You happen to have a null value in this variable which still returns a DATE data...

Gail, thanks for stepping in on that other thread.

I'll ask it this way....

DeWayne_McCallie (6/16/2015)

---

Lynn Pettis (6/12/2015)

---

Welsh Corgi (6/12/2015)

---

GilaMonster (6/12/2015)

---

Hell no. Use SSMS from a client machine. There's pretty much no case I can think...

Lynn Pettis (6/16/2015)

---

Lowell (6/16/2015)

---

you don't put quotes around the parameter; it's already the right datatype.

your real function probably raises an error, sicne you have two variables:@tbl and @source_tbl, but...