MSSQLTips

Hi, I would like to know which Database Architecture/Design would be great and I would like to know the reason. 1. Primary Key and Foreign Key Concept OR 2. Only Primary Key concepts Thank you in advance.

Hi, Please, I have an urgent need for assistance. I have not been coding since I left school but I have been assigned the task of developing a system that will compare two tables(in two different sql server) and send the formatted result to excel sheet for the business teams in my new job. I intend to...

Dear ALL, I want to compare two columns in a same table, both are "NVARCHAR" let suppose there is a table ABC having columns A and B values may be as under A B 455 34567 34567 124 37890 37890 455 36789 35647 124 35647 36789 .. .. SO ON actual values in column "A" starts with 3 while...

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

Dear members, we provide a solution of bugs related to sql server along with study material and interview preparation of SQL server. click below link to get your solution http://mssqlinterview.blogspot.com/

Hi I have a table (Sql server 2000) which has 14 cost columns for each record, and now due to a new requirement, I have 2 taxes which needs to be applied on two more fields called Share1 and share 2 e.g Sales tax = 10% Use Tax = 10% Share1 = 60% Share2 = 40% So Sales tax Amt (A) = Cost1 * Share1 * Sales...

Hi, Thanks for the reply. But I'm working on SQL Server 2000 & need a solution for the same problem in SQL Server 2000. My OS is Windows Server 2003 I'm sorry I forgot to mention this beforehand. Would appreciate if any fellow member can guide me to a solution. Ankit Mathur