namrata.dhanawade-1143388 (6/2/2010)

---

It gives me the decrypted value

UserNameTest Testing123 0x00F41E6A8ECB7F479AF5A6826828

However, if I do the same after the 2nd SP, I get

UserNameTest ...

namrata.dhanawade-1143388 (6/2/2010)

---

after the inserts using the 1st SP, I just take the ID and try to decrypt using

SELECT A.Value,

CONVERT(varchar, DecryptByKey(A.Password)),

A.Password

FROM ServicesDatabase.dbo.IdentificationService A WITH (NOLOCK)

where IdentificationID = @IdentificationID

It gives me...

namrata.dhanawade-1143388 (6/2/2010)

---

Yes, they are the same. There is no syntax problem in the code. Everything else that the SP is supposed to return is coming out fine, except for the...

Also, note that your encryption sproc is called InsIdentification, and the sproc you are calling within your second sproc is called ServicesDatabase.dbo.SRVInsIdentificationService - are they the same?

Which columns on what table are you checking for the encrypted and decrypted values? Column Password of dbo.Identification should contain the encrypted value.

namrata.dhanawade-1143388 (6/2/2010)

---

Hi,

I have a SP that when executed, encrypts the password column.

When after execution i check for the encrypted and the decrypted value, they are returned.

However, when I call this...

Compromise

Pickled onions

simflex-897410 (6/1/2010)

---

' if here, this is first case for this client...so find an available judge:

SELECT JudgeCode,...

Today's Random Worm!

So you thought the SAM-deflecting flares ejected by aircraft executing low-level manoeuvres in hot areas were post-WWII? Nah.

David Webb's is darned good too:

David Webb-200187 (5/25/2010)

---

"I don't...

Oops start again...

"Here's the modulus you lent me, Barry - I'm afraid it's very slightly...

Aggregating twice may help significantly:

SELECT

Period,

OutCome,

SUM(LeadCount) -- sum rowcounts

FROM (

SELECT

A.Date,

Period = CASE

WHEN A.Date >= @PrevMonth AND A.Date < @CurrentMonth THEN 'PrevMonth'

WHEN A.Date >= @CurrentMonth AND A.Date...

Here's a small speed-up which also makes the code much easier to understand:

Declare @onDate smalldatetime, @Tomorrow smalldatetime, @Yesterday smalldatetime, @CurrentMonth smalldatetime, @PrevMonth smalldatetime ...

This works, but it looks horrible:

DROP TABLE #TABLE1

CREATE TABLE #TABLE1 (col1 CHAR(1), col2 CHAR(2), code INT)

INSERT INTO #TABLE1 (col1, col2, code)

SELECT 'a', 'b', 11 UNION ALL

SELECT 'c', 'd', 22 UNION...