I have a database having data from different clients. Now one of client wants to seperate their data from others. I am trying to run a DTS to do this and the query is as below:
SELECT p.BookID, p.Book, p.[Section], p.Page, p.TypeID, p.Heading, p.BNS, p.ClientTypeID, p.IPAddress, p.[Date], p.NDXTypeID, p.UHash FROM PAGEVIEW p INNER JOIN PHONEBOOKS pb ON p.BookID=pb.BookID WHERE pb.PhoneCompany='BSA' ORDER BY p.[Date]
But, the DTS stopped in one place saying that the destination database ClickID colunm (Which is the primary key) couldn't accept null. I don't know if this query is causing probelms. Your help will be highly appreciated. Thanks!
SELECT p.BookID, p.Book, p.[Section], p.Page, p.TypeID, p.Heading, p.BNS, p.ClientTypeID, p.IPAddress, p.[Date], p.NDXTypeID, p.UHash FROM PAGEVIEW p INNER JOIN PHONEBOOKS pb ON p.BookID=pb.BookID WHERE pb.PhoneCompany='BSA' ORDER BY p.[Date]
But, the DTS stopped in one place saying that the destination database ClickID colunm (Which is the primary key) couldn't accept null. I don't know if this query is causing probelms. Your help will be highly appreciated. Thanks!