Jeff Moden (3/31/2008)

---

Ahmad Osama (3/27/2008)

---

souLTower (3/27/2008)

---

If you have a table called CompanyNames you can query like this:

-- Remember to use procs to eliminate SQL injection

SELECT cid from CompanyNames where cname...

dragos_sv (3/31/2008)

---

i do not think it's a matter of sql server version. ideally you/we should be able to answer without running the command.

but if you still want to run...

Chris Morris (3/28/2008)

---

Hi Ahmad, depending on how many rows you're working with, fuzzy matching may also be an option. You could employ SOUNDEX or DIFFERENCE to quickly obtain a list...

souLTower (3/27/2008)

---

If you have a table called CompanyNames you can query like this:

-- Remember to use procs to eliminate SQL injection

SELECT cid from CompanyNames where cname =

One project...

Hi,

I want to check a user inputed company name with that of company that exist in our database in order to determine whether the user given company already exist in...

Thanks.....:cool:

though it will take time than other options but ..it is da only one...:)

I have chosen reporting services..reason...

mrpolecat (3/26/2008)

---

What do you want to know about them? How alike they are or how different? Are you looking for words that start the same, end the same,...

Do you have any logic to support your answer :hehe:

Thanks chris.. y dont u write an article for the same....:)

Hi All,

That's gr8..We now have 4 ways to schedule the data extraction :-

1) DTS

2) Stored Procedure

3) Macros linked with Views

Will you guys help me to identify pros and...

Hi Chris...I've used the same code that I showed.Well....I've to figure out the problem ..wish me luck 🙂

do u have any solution...

try this ..

spExecute_ADODB_SQL @DDL='Create table CambridgePubs

(Pubname Text, Address Text, Postcode Text)',

@DataSource ='C:\CambridgePubs.xls'

I have excel installed on my server ....I am unable to understand what's the problem...

Hi Chris,

I copied and executed the code that was at the specified url (shown below), I am getting the error "Msg 50000, Level 16, State 1, Procedure spExecute_ADODB_SQL, Line 53...

Thanks chris..

Where will I get an article on reporting services....