CREATE PROCEDURE WHATEVER WITH ENCRYPTION.....

but encryption only goes so far....SQL has to be able to decrypt it to use it, right? you can make it harder on them, but it...

the bad news: anyone with sysadmin privileges cannot be prevented from reviewing your database, and even if you disabled Windows logins, since he has physical control, he could add himself...

wrong tool for the job.

reading a web page, entering username and password /submit and browsing to other pages requires some interaction type activities.

much much better to create an application in...

you had it almost perfect, just needed to remove the stuff between CASE and WHEN

CREATE TABLE EmployeeResult

(ERId INT IDENTITY(1,1),

QuestionNo TINYINT,

EmpAns CHAR,

RealAns CHAR,

Comparison AS

CASE

...

excelent tomas glad it's working for you;

performance wise, it it the same as the inline calculation you tested against?

again, if you explain why you want to open IE thru sql and not other methods we could help you better. detailed info gets detailed answers...vague statements gets vague answers.

CLR...

i formatted your SQL and converted it to use some CTE's;

look at the final sql and tell us what is not working: how is the data incorrect?

WITH t2 AS

...

i have a different conversion in my notes: what format are your dates actually in?

DECLARE @jdate int

SET @jdate = 109252

--in AS400/DB2 date is 01/01/1900 + 109 years + 252 days

select...

Dan i poked around the net trying to find out the ramifications of why TRUSTWORTHY on master database might be a bad idea, and it just comes right back...

run sp_who or sp_who2;

every spid greater than 50 is a user connection.

what value did you put in for the path to the file, N'\\server\folder\Trace',

if it is not a local directory, but a UNC path, you might have problems depending on...

ok tomas, a couple of things;

scalar functions can slow things down, as they introduce a hidden cursor/REBAR...million rows=million function calls.

I've changed your function froma scalar(called once per row) to a...

Suresh excellent job on posting a complete example, thanks!

in this case, you want to compare the actual execution plans to see if it makes a difference.

in your example, they produce...

another way without the UNION:

select

CASE

WHEN manager='Y'

THEN 1

ELSE 2

END

as myorderBy,name,salary

from sometable

ORDER...

oh yeah we are on the same page. there's another thread on CLR that got me all excited becasue i got it to work to read a web page...for...