there's different ways i can think of offhand.

one is ETL (Extract, Transform, Load); that would typically be export to a file, and an import file pulls the data into the...

the trigger has no WHERE statement, and never references inserted or joins to the remote table...does that remote table only have one row?

is there a realtionship between teh local...

i think i will pass on downloading and running an executable from the internet, thanks.

maybe you could post a link to the source code instead.

Rich Yarger (4/11/2012)

---

...their tables, that has begun to receive millions of rows of data to this one table, a day (when I say millions I mean a million plus, but...

dunno if it matches the table that was posted, but here's the data as a select to show what we are looking for:

I've got a pair of macros for hacking...

what would the function do? generate random events? ie PASS 4 YARD GAIN,RUN -1 GAIN,FUMBLE ,INCOMPLETE PASS etc?

are the teams supposed to be weighted , ie one has great offense,...

how much of an impact would it be to change the column to big_int?

if there's an application that consumes the data, that would need to change to use int64,...

ok, then if you were searching email addresses for example, and you want to find items with teh @ symbol,then it's like this:

DECLARE @var varchar(10)

SET @var ='%' + '@'...

There's no such thing as just [@] in SQL....

i missed that the question was how to clean them as well as how to find them, thanks!

here's one way: a scalar function that strips out the non-compliant characters:

I've got the same functionality as a CLR, which uses Regular Expressions, but I've never tested which performs better.

SELECT...

well until you provide concrete details we've asked for for 3 forum pages so far, none of...

lol . if it doesn't matter, well...whatever.

I'll ask again for some specific code: show us what you've...

you'll have to join the table agaisnt itself wiht an alias:

something like this:

select * from product_to_cat t1

left outer join product_to_cat t2

on t1.product-id = t2.product_id

where t1.cat_id = 69

and t2.catid = 30

cuteprabakar...

i didn't even read your reply.

you have got to do your part first.

help us help you!

1. provide a CREATE TABLE example representative of what you are using.

2. provide INSERT...