We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Hi i have the following table CREATE TABLE #Test ( ProductID int, MainMasterFeatureID int, --MasterFeatureValue Varchar(100), ChilFeatureName varchar(100), ParentFeatureName varchar(100) ) ...

Hi Our client is deploying the application using SQL Server 2008 Web Edition, we r developing using SQL 2008 Enterprise edition. The DB contain some tables with data to run the application initially(Default settings) We don't have the license for Web Ed...

Hi Our client is deploying the application using SQL Server 2008 Web Edition, we r developing using SQL 2008 Enterprise edition. The DB contain some tables with data to run the application initially(Default settings) We don't have the license for Web Ed...

Hi This is the requirement... There is no need for the client to be aware of underlying database, silent install. No need of seperate installation, everything should cover in one installation. The data should be protected, secured (Password protected,...

Hi This is the requirement... There is no need for the client to be aware of underlying database, silent install. No need of seperate installation, everything should cover in one installation. The data should be protected, secured (Password protecte...

thanks sir It solved my problem. Can u explain why to use '.' this instead of tag....

Hi follwing is the code i had use DECLARE @GroupID int = 1 DECLARE @Agency xml SET @Agency = ' 1 2 3 ' CREATE TABLE #temp (id int identity,AgencyID int,GroupID int ) INSERT INTO #temp ( AgencyID ...

Hi follwing is the code i had use DECLARE @GroupID int = 1 DECLARE @Agency xml SET @Agency = '<Agency> <AgencyID>1</AgencyID> <AgencyID>2</AgencyID> <AgencyID>3</AgencyID> </Agency>' ...

Thanks Ramireddy I am planning to go for a Generalization(Supertype/Subtype) , having a product table(SuperType) with common attributes and Subtype tables with different attributes for each vertical...