SSRS Chart in tablix with Column Break

I wanted to create a multicolumn report with paging. For complexity I have Gauge control in first row and Chart control in second row. I have data from table like this MetricID | ColumnNo | RowNo    1         |    1            |    1             2         |    2            |    1             […]

SQL Server : Replication Error – the row was not found at the Subscriber when applying the replicated command

I got the following error in Activity Monitor, The row was not found at the Subscriber when applying the replicated command. (Source: SQL Server, Error number: 20598) After some research, I found out the error occurs because it’s trying to delete records which are not exists in the subscriber(Also are not exists in publisher) {CALL […]

Choosing and assigning a value based among the duplicate records in sql

My data looks as below: Student_ID State 1 WI 1 IL 1 IL 2 WI 3 IL 4 IL 4 MN I want my Output to be as follows: Ouput: If the same student is in both WI and any other state then we need to mention as ‘multiple’, when student is only in WI […]

Group Concatenate in MS SQL Server

I have two tables dbo.Supplier and dbo.L_ProductSupplier (AS LPST) and for all product IDs on LPST table, I want to concatenate the Supplier Names from dbo.Supplier (AS ST) which is linked to LPST by the SupplierID field (each product can have multiple suppliers) e.g. the query should take this: LPST.ProductID LPST.SupplierID ST.SupplierName 1 A CompanyA […]

Pass Dynamic Data Table to Ms sql Stored Procedure

I have a scenario where am uploading a Dynamic (some columns vary but I had to maintain their names in a table each time a user requires it, but it is not predictable so what i check is whether the column name is maintained) Excel document and saving the content using Linq. Unfortunately due to […]

can't enable mssql extension in php.ini?

I’m using xampp 1.7.1 (i know it’s an old version) and i need to enable the extension=php_mssql.dll – with the extension enabled my appache won’t start? If i disable the extension it let’s me start appache. I was having problems with my site using mssql_connect() and I was told that enabling the extension in my […]

Is it possible to create read-only synonym in SQL Server?

We have 2 different databases DB1 and DB2 with tables in DB2 referring to tables in DB1. We are looking into the possibility of using SYNONYMS with read-only access in DB2 and use EntityFramework to refer to these SYNONYMS as tables in DB2. Since currently EF doesn’t span across multiple databases, after reading this article […]

Move nVarChar data from one table to another and return PK to origin table

I am looking for advice on the best SQL Server 2008 R2 approach to move a reasonably high number of nVarChar data type rows from one table to another (actually there are a number of tables). In summary the objective is: chapterOne is a table that has a nVarChar column called page_content a new table […]

Some tables id column do not auto increment despite being identity

I am troubleshooting a db (not my forte) that has some tables that are auto incrementing on the id column and some tables are not? Now all the tables are set as identity and marked to disallow null. I am using SSMS what else can I check or do to get these tables back to […]

calculation of amount for quarter

I have a question, I want merge my table data through date, All information provide in given table If Aggregation =Quaterly My table Table-1 Amount | Date | Aggregation 100 | 2013-01-01 | Quaterly 100 | 2013-02-01 | Quaterly 100 | 2013-03-01 | Quaterly 200 | 2013-04-01 | Quaterly 200 | 2013-05-01 | Quaterly 200 […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.