The soundex query? select custname from mastercustomer where soundex(custname) = soundex=('SCOTTIE').

result:

custname

scott

scotty

scot

....

This is what i'm looking for but is this the right contxt to use soundex? or should i use full-text...

Figured it out.. use SOUNDEX right?

^^^^ thanks

Lynn Pettis (9/19/2008)

---

John N (9/19/2008)

---

trying to add and "IF at the end of a select query, can you help with the syntax

example

SELECT id1, id2, id3 FROM table

IF...

I understood what you wrote earlier,...

:D, I got it!!! thanks for all the help!

DTS package--> drop view mytable-->create view mytable (tbB) -->truncate tableA -->bulk import

-->drop view mytable -->create view mytable(tbA) --> truncate tableB --> transferdata...

this is done in the stored procedure before the bulk load then dropped after the bulk load correct?

do i replicate tableA with tableB afterwards?

TIA.. very much

Jeff.. OK since I'm a noivce with this I'm going to ask that you help me out in more detail.

OK this is what i've got:

1. DTS package schedule, truncate table,...

Thank you for all your suggestions, while I try to digest all the options.

Jeff can you tell me how to do what your suggesting?

can you give me a hint on how to do this?

tia

Matt,

thanks.. that is what i'll do.

Sergiy,

the data is not really that much but the problem is it's coming from a vendor api with a standard data for all their users....

Matt Miller (11/5/2007)

---

This might not be palatable, but here's a thought. Add a step at the beginning of your import process that updates a "site status" table from "online"...

no, it's done 3 times a day.

i know it's a bad idea, but not my decision.

this is almost perfect except for the states that have no jobs has a count of 1 instead of 0.

got it to work.. change the count(t1.state) thanks

i think i figured it out..

select distinct table2.statename, table2.stateabbrv, count(table1.state) as c from

table1 join table2 on table2.stateabbrv = table1.state

group by table2.statename, table2.stateabbrv