Thank you Evil Craig. I like your reduced code version. Haave a good day and a Happy Holiday Season.

Thank you Sir. I will ponder your words of wisdom and maybe I will be able to do it. But then I have a work around that appears to do...

GilaMonster (11/18/2012)

---

Please don't post multiple threads for the same question.

http://www.sqlservercentral.com/Forums/Topic1386047-149-1.aspx

As I suggested in the other thread you posted, you're likely to be better off posting this on a .Net...

Yes Sir, I do. I just did not know how to identify it correctly in my posting. I am using SQL Server 2005,...

Thank you SSCertifiable, this script worked just fine. It removed the 9 duplicate rows in the EmployeeList Table.

You wrote: "This would be a lot simpler for people to respond if...

dwain.c (10/28/2012)

---

ChrisM@home (10/28/2012)

---

jrichards54 (10/28/2012)

---

Is it possible to use the "IF" function in a column at design time as the value for that field? I do it regularly in Excel with...

Thank you for your reply. I appreciate your insights and recommendations. Have a good day. JRichards54 🙂

I currently have VS 2003, VS 2005 and SQL Server 2005 installed on my machine. VS 2003 is 32 bit, VS 2005 And SQL Server 2005 are 64 bit. Will...

"Let me know if that code works for you. If not I can probably help tweak it into submission."

I have created a database in ACCESS and named it "ConnectionTest.mdb" with...

Sean Lange (9/25/2012)

---

jrichards54 (9/25/2012)

---

Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the books...

Sean Lange (9/25/2012)

---

jrichards54 (9/25/2012)

---

Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the books...

Thank you but I do not have Studio 2010. I just spent a bunch of money for SQL Server 2005 and Visual Studio 2005 and the books to help me...

"Can you use ADODB instead of OLEDB?

I don't understand what you mean at all with second issue. Are you saying you can't connect to your database with Visual Studio?...

Luis Cazares (9/20/2012)

---

The instructions are mostly generic as VS 2012 is independent of SQL Server.

You can follow the instructions here: http://www.codeproject.com/Articles/20987/HowTo-Install-the-Northwind-and-Pubs-Sample-Databa if you don't feel confident to use the SQL...

Mil gracias, senor Cazares.

I printed "Northwind...