Member Avatar

Hi All, I'm a little stuck with one table's design. I have a table called tblConference_Board that will be updated approximately 3 to 4 times per year. The following is my table design: `CB_ID int (PK)` `CB_Mnemonic_ID int (FK)` `CB_Value decimal (18,10)` `CB_Year int` `CB_Quarter int` This table is loaded from a staging table called tblConference_Board_Staging. When there is an update (say in the spring), the values will either be in quarters or annual values. The year range has been consistently the same and usually starts from 1961 to 2035. When the next update comes (in the summer), the yearly …

Member Avatar
0
14
Member Avatar

Hi There; I have a MS-SQL server and I have Turkish names in my table. User enters names and I send it to SQL server, print result to output. However, my PHP code process and prints text as a UTF-8, and send it to MS-SQL and print it to output.However data in MS-SQL is in Windows(Turkish) format, so there are nothing to return. For example; when user types "Güray" in html input form, PHP issues a query: "SELECT * FROM table WHERE name ='Güray' " and sends it to MS-SQL server. Server returns nothing, but I know that there are …

Member Avatar
0
2
Member Avatar

Hi, I have replication configured on a SQL 2008 Database. The tables involved are something like this; [INDENT]tbl.Product ProductID Int ProductName NVarchar(max) ImageID Int FK_Product_Image FOREIGN KEY(ImageID) REFERENCES tbl.Image (ImageID) tbl.Image ImageID Int Image Image[/INDENT] tbl.Product is part of a Transactional publication with updatable subscriptions. tbl.Image is part of a Merge publication I have no problem creating/modifying products with an image on the publisher, doing it on the subscriber will replicate the Image but won't replicate the product on Modify/create. The stored procedure that does the create/modification of the Product will insert the Image into tbl.Image then create/update the product …

Member Avatar
0
4
Member Avatar

Hi, I am trying to set up transactional replication on a MS SQL 2008 database that has two Schemas, both schemas have some tables with the same names. Schema A A.Customer A.Product A.Invoice Schema B B.Customer B.Product B.Incoive My first problem is actually configuring Replication on the publisher using the wizard. It fails when selecting all tables from both Schemas, even when I set it to 'Copy-file group associations'. I get the following error for every table in Schema B that has the same name as a table in Schema A: [LIST=1] [*]SQL Server Management Studio could not create article …

Member Avatar
0
7
Member Avatar

What I'm working on is a video rental project in visual basic 2008. I have a local database which contains info on DVDs, Members and a table for current rentals. [B]The columns i have in the current rentals table are:[/B] MemberID | DVDID | DaysOnRent | DateRented | DueDate | Overdue | TotalPrice I have this data displayed in a datagridview, but the user adds it through a seperate form (called add a rental) with a 'details' view of the table on it. I've written code to automatically determine the TotalPrice and DueDate of the DVD in the add a …

Member Avatar
0
7

The End.