|
||||||
|
We had merge replication in SQL Server 2005 set up that was working fine, except when trying to view conflicts, the Conflict Viewer would give this error: “RowGUID is neither a DataColumn nor a DataRelation for table summary. (System.Data)”. The source of this it turns out was actually a period in the Publication name, as we [...] Sometimes we need to rollup string values into lists of comma separated values. Using “FOR XML PATH” per column that you want to rollup can provide a way to do this. This example was created based on work in this thread: Let’s say you have a data set like so: id 101 101 101 102 102 103 103 and for each distinct “id”, you want [...] Today, as I was working on a project, I found an opportunity to use the For Loop Container. The basic setup, was three tables, A, B, C for simplicity. Table A is the Header, Table B a sub-header related to table A via an ID, and Table C related to Table B via an id. [...] While there are different views on how to build different dimensions, there seems to be a common view of how, at least the basic information, of date dimensions looks. This can take a little time to build out. To help in building this dimension, I created a simple table valued function that takes in a [...] |
||||||
|
Copyright © 2010 SQL Slayer - All Rights Reserved |
||||||
Comments