Still in the desert,...

Welsh Corgi (6/8/2015)

---

USE MASTER

GO

CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'Encrypt01!@'

CREATE CERTIFICATE CERT05 WITH SUBJECT = 'Cert4u12!@'

USE Adventureworks2012

CREATE DATABASE ENCRYPTION KEY

WITH ALGORITHM = AES_256 -- Error

ENCRYPTION BY SERVER CERTIFICATE...

With nothing to use for testing here is a swag:

WITH BaseData as (

SELECT

rn = ROW_NUMBER() OVER (PARTITION BY

...

Personally, I think the query is correct. Masking of the subsequent sales amounts should occur in the front end application or report, not at the back end.

And if I remember correctly when I had a need to disable and enable triggers in a closed process it had to be done using dynamic SQL as the disable...

Yes, I see that. I am not going to test your script on my laptop (now if I had a dedicated VM...

Not sure, but it looks like you never turned encryption on using ALTER DATABASE ... SET ENCRYPTION ON;

https://msdn.microsoft.com/en-us/library/bb522682.aspx

ericpap (6/8/2015)

---

First, Thank you very much Grant and Steve for your help, and trying to undestand my problem. Sorry for the rush, but this a serious problem for me and...

gward 98556 (6/8/2015)

---

Lynn Pettis (6/8/2015)

Realize this is a crutch. The only way to ensure the order of data is for there to be an ORDER BY on the outer...

gward 98556 (6/8/2015)

---

If you really cannot move the ORDER BY to the outer query that uses the view, then you could use the TOP 2147483647 (or a smaller number if...

Alvin Ramard (6/6/2015)

---

SandyTucker (6/6/2015)

---

Hello - does anyone know why the statement "where WD.WRKD_WORK_DATE BETWEEN DATEADD(DD, -6, GETDATE()) AND GETDATE()) = 0' is successful, but "WD.WRKD_WORK_DATE BETWEEN (DATEADD(DD, -16, GETDATE()))...

mwilliams4nc (6/5/2015)

---

OK I see the advantages of a numerical ID for both my Vins table and my Orders tables.

So is it like this then?

tblVins

-------

VinID -- numeric -- Primary Key

Vin --...

Eric M Russell (6/5/2015)

---

Lynn Pettis (6/5/2015)

---

Eric M Russell (6/5/2015)

---

Andy Warren (6/5/2015)

---

Eric, I'd agree with that. But suppose there were two of you doing that. Same job, same skills. Virtual twins....

Rod at work (6/5/2015)

---

Lynn, what I'm trying to do is group the records by BitField, whether they're ordered or not. What I was hoping the UNION would do is return...

Eric M Russell (6/5/2015)

---

Andy Warren (6/5/2015)

---

Eric, I'd agree with that. But suppose there were two of you doing that. Same job, same skills. Virtual twins. Should they get paid the...