solid advice so far; I agree with everyone above that encryption should be selective to specific items.

think it through a little though:

Is it not true that if EVERY field is...

try this command first:

EXEC sp_tables_ex LinkedServerName

that should give you a list of the tables the login you are using can view/has access to;

if the linked server has access to more...

well, you can't get TRUNCATE to activate a trigger on a table;from BOL:

TRUNCATE TABLE cannot activate a trigger because the operation does not log ... the db_owner and db_ddladmin fixed...

in 2005 and above, syscomments is a view, and no matter the override setting, cannot be updated.

please test any advice you make before posting it...it can mislead floks who don't...

just use the ISNULL function to convert the null, i would think should work just fine:

SELECT

C.LOCATION_NAME,

SUM(ISNULL(A.SALE_AMOUNT,0.00)) AS SALE_AMOUNT

FROM SALES A,

LEFT OUTER JOIN ACCOUNT...

you'll need to paste the exact code you are using; encrypting part of a string, then concatenating the decrypted results is easy, so it's probably something fairly basic that is...

bagofbirds-767347 (4/20/2010)

---

thanks. i do indeed use central functions for things like string/date operations. But my problem is getting the procs to work with data in the correct db....

for encryption, i really like this article; lots of example,s and easy to follow along:

http://www.databasejournal.com/features/mssql/article.php/3483931/SQL-Server-2005-Security---Part-3-Encryption.htm

you know you have to encrypt the entire string, and not just part of it right?

so...

tomas i learned something with this, thanks; i never get to use xml/xquery at work, so all my experience comes from testing ehre; your code gave me what i needed.

this...

rik there must be more to joining the families of parts;

if it was just that SVD matches XVD, then if i have ten rows in PartSubFamilyA, and only one row...

the TOp command is working for me to limit this example;

I couldn't use what you had posted, soemthing about the schema...

try this example with and without the TOP;

i get 3...

datetimes are not stored in that format, it just happens to be the default way your regional settings are presenting the datetime. they are actually stored in numeric formats behind...

use the row_number() function in an inner query, and have an outer query have the alias'ed columname for rownumber e the specific value:

select * from

(

SELECT row_number() over (order...

jeremy you'll want to left outer join the two tables;

by checking a third column in the table, you can find which items in tableb do not exist in tablea

this example...

well, you could infer it is fname.lname by counting the number of periods left of the @ symbol:

declare @email varchar(1000)

set @email = 'firstname.lastname@freehills.com'

select SUBSTRING(@email,1,CHARINDEX('@',@email)),

REPLACE(SUBSTRING(@email,1,CHARINDEX('@',@email)),'.',''),

LEN(SUBSTRING(@email,1,CHARINDEX('@',@email))) - len(REPLACE(SUBSTRING(@email,1,CHARINDEX('@',@email)),'.',''))

firstname.lastname@ ...