shan-422658 (3/12/2014)

---

Thanks for your reply.

Just a version 2 of the above query…

Surname GivenName

ABC x.yz

ABcx.y.z

ABC X.*YZ

A*.BC xyz

The query needs...

MyDoggieJessie (3/12/2014)

---

If the "key" is a part of your clustered index then your top 1 select statement should pose very little overhead. If that's not an option, within your...

Dohsan (3/12/2014)

---

Sean Lange (3/12/2014)

---

Thanks Keith. I would not consider myself a SQL Ninja by any means but thanks for...

In an effort to evaluate which of the two posted methods would perform better I put together a quick test with 1000 random names. It is kind of nasty to...

Thanks Keith. I would not consider myself a SQL Ninja by any means but thanks for the compliment. I...

shan-422658 (3/12/2014)

---

I have an employee table

Surname GivenName

ABC x.yz

A.BC X.*YZ

A*.BC xyz

The query needs to get me the surname and...

buddy__a (3/12/2014)

---

As the title says, I want to transfer all the tables along with data to a new database. In the source database the tables are in the dbo...

Cool glad that worked for you.

adonetok (3/12/2014)

---

There is a member table in which members info was stored but may have duplicate records.

I used code below to delete duplicator but want to keep the latest [CreatedDate]....

rahma.andany (3/12/2014)

---

Hi all ,

I have problem with my application, when uploading picture into sql server 2000 my application showing error message ( Run-time error '-2147467259(80004005)' Time out expired ). This...

Do you have a situation where there might be more than 3 dependents? This sounds a lot like you probably don't know the number of columns for output because it...

A union requires that each query have the number of columns. You are wanting to have derived...

joepacelli (3/11/2014)

---

I'm on a development team that inherited a project from an office that was closed. I'm not a DBA but I am working to become one.

One of the...

So let me see if I understand this. You have a table with a guid (please tell this isn't your clustered index) and a name. Then you want to update...

PiMané (3/11/2014)

---

Thanks,

I'll try it, don't know if the software has "proper" SQL CRUD (columns specified in the INSERT) or "lazy" (INSERT INTO .. VALUES (..) without the columns name...).

If there's...