GilaMonster (5/12/2015)

---

Yup.

With a tiny table...

i tried putting together an example, but i keep getting a table scan, maybe becaus emy sample table is small.

does this look right to everyone?

--DROP TABLE tempdb.dbo.MyEncryptedTable

With MYFirstNames(FName) AS

(

Select...

here's how i get tables in the order of hierarchy; i could use this to build TRUNCATE/DELETE commands .

as i remember it SequenceOrder = 1 means i can truncate, and...

a space in the LIKE is just as valid as any regular char.

change your like to have the spaces:

Select top 100 * FROM tbl_abc

where

--AIMS_Value like '%LVAD%' --old

AIMS_Value like...

If I'm reading this right, I would change the strategy. there might be additional details why you HAVE to go SQLcmd, but i'll start with my assumption.

instead of stepping out...

from the connection side, you cannot tell if an ODBC connection is a linked server on the far end, or a application or anything like that.

If you've been smart and...

he could use a varchar 8000 or even a varchar(max) with text 0's and 1's! then he'd have an unlimited number of possible values!

all he would need is a table...

removing duplicates will mean rewriting the file, so whether you put it in sq serverl, and sort+ group, or do it in memory via aggregates or script tasks, it still...

i did not write this, but i saved a copy from 2011. search for some strings in the code to find the ooriginal thread here:

Find String like 'aaaaa' or...

i think you just put a case in your group, like this:

group by

CASE WHEN [Category]LIKE '%PII%' OR

LIKE '%PIPEDA%' OR

LIKE '%HIPAA%' OR

LIKE '%Resume for HR%'

Then 'PII'

WHEN...

also, check if you are running DataCenter Edition on the ESX; i believe that has licensing specific to VM instances, which is different than when you reuse Enterprise/Standard licenses...

that code will update all rows, instead of just what was just inserted.

i'd do it this way instead, but i don't know the PK of the table

CREATE TRIGGER country_Insert_Update

...

kd11 (5/4/2015)

---

Let me re-word that, I want to fire a trigger when column2, column3, column5 and column9 are updated/insert (not the other six columns) so do I need to use...

your sample data didn't have any duplicates; since this seems a little homework-like, i'll give you just a couple of hints.

duplicates are typically removed by using a GROUP BY ...

Thanks for the heads up, Martin;

since i was doing this in TSQL, i went ahead and just used the SQL server backup directory for my backups, instead of the default...