SSIS - MDS

MDS

XML-XSL Transformations in SQL Server

With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server.

Master Data Services - SSIS MDM Load

The article will provide an overview of Master Data Services and a sample SSIS Package.

RE: Index not used on Select *

Ray -Since there is no clustered index on this table, I would assume that data rows are stored sequntially.  Regardless of what is in my select statement, as long as I have the right where clauses, the query engine should use index seek to get to the addresses of the desired rows and then get the information […]

RE: Query question...

I don't think this is implied.  It is easily conceivable to need such a query in a properly normalized database.   This is a history table of each change in an employee's status, and the OP wishes to get the information about the latest change for each employee, i.e.:CREATE TABLE EmployeeStatusHistory( EmployeeID int REFERENCES Personnel, UpdDate datetime NOT […]

RE: T-SQL Parameter goofyness

Use a table to store the message and then include that? Could us a create table msg (spid int, mymsg varchar( 100))Actually, that's what I'm doing, but I need to do something like (pardon my semi-sql):Open Cursor on template_table while GetRows into statement, issql BEGIN   If issql     insert into msg_table EXEC(statement)  -- Was a […]

RE: Diagram Copying

I asked this same question on 10/29/2003. (Topic: "Copying Diagram?"). The best answer was from a posting from Brian Knight (11/13/2003) - Article "Transfering a SQL Server Diagram". Good luck, Allan

RE: using lookups

SELECT cast(convert(varchar, DATE_TIME, 101) as datetime) as DATE_TIME, MAX(QUANTITY) AS MAX_QUANTITY, MIN(QUANTITY) AS MIN_QUANTITY, AVG(QUANTITY) AS AV_QUANTITY FROM TRANSACTIONS group by cast(convert(varchar, DATE_TIME, 101) as datetime) the above given code does not work in my case i guess this is becoz i hve an oracle Db at the backend from where i am using the […]

RE: Optional search conditions

Actually a Clustered index scan is fine for all as that is what would happen. But to get the seek I would do like so DECLARE @id int SET @id = 23 -- COmment out to get all IF (@id IS NULL) SELECT * FROM sysobjects ELSE SELECT * FROM sysobjects WHERE ID = @id […]