SQLRNNR (7/17/2014)

---

That looks eerily...

Koen Verbeeck (7/17/2014)

---

Where is...

Would that be this bunch?

😎

Quick thought, I would, if possible, use SSIS to pass the file name and path to an OPENROWSET on the SQL Server.

😎

Quick thought, have you looked into EXECUTE AS

😎

Joy Smith San (7/17/2014)

---

Hi Team,

Currently we have a database in SQL Server 2005.

Decided to move that DB into a new VM where we need to install sql server 2008 R2.

We...

Quick suggestion

😎

DECLARE @COMMENT NVARCHAR(200) = N'Work (210) 401-6838 for debtor(1) ''Guzman, Tarrasa'' status changed from Good to Bad';

SELECT REPLACE(@COMMENT,N'-',N'') AS CLEAN_COMMENT

Result

CLEAN_COMMENT

-----------------------------------------------------------------------------------

Work (210) 4016838 for debtor(1) 'Guzman, Tarrasa' status changed from...

mick burden (7/17/2014)

---

Thanks, dte will always change as it's a date and time field and is updated every 30 mins, the ipaddress field could remain the same over several days...

Quick thought on this problem, if the IP address is the unique key with a temporal attribute of Recorded Date (dte), there is no way of telling if an IP...

Jack Corbett (7/16/2014)

---

Eirikur Eiriksson (7/16/2014)

---

No implied either, my respect on handling the situation! So far, JC is the only one that has managed to rub me the wrong...

JA quick code here, not a full solution, just to get you going;-)

😎

USE tempdb;

GO

;WITH EMP_TRAN AS

(SELECT EmpID, TransDate FROM (VALUES

('00001','1/1/2014')

,('00001','1/2/2014')

...

This sample is kind of a walk through, add column, update with encrypted, mask the clear text etc..

😎

USE tempdb;

GO

CREATE TABLE dbo.Name_and_SSN

(Full_Name VARCHAR(50),

CLEAR_SSN VARCHAR(12));

INSERT INTO dbo.Name_and_SSN (Full_Name,CLEAR_SSN)

VALUES

('Egor Mcfuddle' ...

Miles Neale (7/16/2014)

---

OCTom (7/16/2014)

---

crussell-931424 (7/16/2014)

---

I can't count the number of times management has presented me with an assignment which is the solution to some problem they have. Once implemented and...

First thought would be a proper four part notation: [mylinkServerName].[Mydatabase].[my schema].[mytable]

😎

Welsh Corgi (7/16/2014)

---

I started out by asking a basic question about encryption.

I am Grateful for the help and I got my answer. Then I asked about the next steps.

If I...