ChrisM@Work

Forum Replies Created

Viewing 15 posts - 7,846 through 7,860 (of 10,143 total)

RE: Decryting a column value inside an SP

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 2, 2010 at 6:17 am

#1175232
RE: Decryting a column value inside an SP

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 2, 2010 at 5:03 am

#1175200
RE: Decryting a column value inside an SP

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?
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 2, 2010 at 4:19 am

#1175184
RE: Decryting a column value inside an SP

Which columns on what table are you checking for the encrypted and decrypted values? Column Password of dbo.Identification should contain the encrypted value.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 2, 2010 at 4:14 am

#1175179
RE: Decryting a column value inside an SP

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 2, 2010 at 3:04 am

#1175155
RE: Today's Random Word!

Compromise
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 2, 2010 at 2:11 am

#1175137
RE: Today's Random Word!

CirquedeSQLeil (6/1/2010)
crookj (6/1/2010)
reflux
Joe
acid
Pickled onions
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 1, 2010 at 10:03 am

#1174889
RE: WHERE NOT IN(...) not picking up value.

simflex-897410 (6/1/2010)
' if here, this is first case for this client...so find an available judge:
SELECT JudgeCode,...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 1, 2010 at 8:28 am

#1174799
RE: Today's Random Word!

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.
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

June 1, 2010 at 6:53 am

#1174746
RE: Are the posted questions getting worse?

Trey Staker (5/26/2010)
Gianluca Sartori (5/26/2010)
Common sense is in spite of, not the result of, education.
-- Victor Hugo
I'm stealing this for my signature!
David Webb's is darned good too:
David Webb-200187 (5/25/2010)
"I don't...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 26, 2010 at 9:53 am

#1172846
RE: Today's Random Word!

RBarryYoung (5/25/2010)
Hrrmmm... I'm not sure that we're still talking about the same thing ... :angry:
Oops start again...
"Here's the modulus you lent me, Barry - I'm afraid it's very slightly...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 26, 2010 at 7:59 am

#1172739
RE: Query taking long Time ,Kindly suggest

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 26, 2010 at 7:48 am

#1172722
RE: Query taking long Time ,Kindly suggest

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 ...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 26, 2010 at 7:33 am

#1172702
RE: WHERE Clause

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...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 26, 2010 at 6:36 am

#1172653
RE: WHERE Clause

Please fully identify the entity - which you want to use in your WHERE clause - which can have values of 66 or 77. You've referred to it loosely as...
^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

May 26, 2010 at 5:49 am

#1172622

Viewing 15 posts - 7,846 through 7,860 (of 10,143 total)