PaulB-TheOneAndOnly (5/22/2011)

---

Diane Davis (5/19/2011)

---

I am thinking about adding a category to each entry so that "Kenya" will have a "continent" category of "Africa". Then the searches can be written so...

What version of DB2 are you using?

I performed several goggle searches the closest that got...

I believe that if you install the IBM DB2 Client on the machine(s) that you a using SSIS on it installs the driver.

mulle-78 (5/23/2011)

---

We could at the moment not solve the problem. What is with a fresh installation. Can uninstall the old MSSQL components, do a freh install of a named instance...

Jeffrey Williams-493691 (5/22/2011)

---

Welsh Corgi (5/22/2011)

---

IThe ClientID does not uniquely identify the row in this case. A compound primary key would be required which would include at least ClientID and...

I noticed that you have not defined a Primary Key or a Clustered Index.

Why do you need the Surrogate Key ID when you have a Natural Key ClientID?

How do you...

Can you rephrase that?;-)

prashantcomp90 (5/22/2011)

---

I thought that if we can combine multiple tables in sql and create view. then i create multiple views and then combine them in one view. and...

Lucky9 (5/22/2011)

---

I am sorry again, for the wrong dates

Create Table Status

( ID int Identity(1,1),

ClientID int,

StatusStartDate Datetime,

Status Int)

Insert into Table Status(ClientID,StatusStartdate,Status)

Values(100,'2010-01-28',1)

Insert into Table Status(ClientID,StatusStartdate,Status)

Values(100,'2010-03-20',1)

Insert into Table Status(ClientID,StatusStartdate,Status)

Values(100,'2010-05-30',2)

Insert...

brian.cook (7/10/2010)

---

I did not write this DB, however it has fallen to my hands to make it work for Access 2010, and I do not have much experience with VB...

One of the options mentioned was SSIS.

You could launch BIDS and create a...

This is a very simple example.

Perhaps you can make it better?

IF EXISTS (SELECT name FROM sysobjects

WHERE name = 'usp_return_Client' AND type = 'P')

...

How are you going to return StatusEndDate when it is not in your table?

I would not use a reserved words when naming an object, i.e. Table and Column name is...

Lucky9 (5/22/2011)

---

i have a table with below structure

ID ClientID StatusStartDate Status

1 100 2010-01-28 1

...

Did you check the NIC Card?

I had this problem before and setting it to Full Duplex fixed the problem.

If you NIC is set to Auto you will have problems with...