Here is a quick solution using the charindex function to locate the boundaries. The first one depends on the first word being consistent, the second one has slightly more flexibility...

Quick thought, you may want to take a look at Jacob Sebastian's XMLTable function. Also if you have an XSD for the XML, you can create a schema collection and...

Quick note, Alberto Ferrari gave a very good talk on optimizing DAX queries at the last SQLBits where he explained in good details the Vertipaq/xVelocity compression, rowgroups, deltastores etc. Also...

This code

CREATE SYNONYM Emp

FOR Human.Resources.Employee

;

go

select

BusinessEntityID

, NationalIDNumber

, JobTitle

from Emp

;

will not work as there is no such thing as

Human.Resources.Employee

Try it out if you don't have...

Here is another way of doing this, slightly more flexible

😎

USE TESTDB;

GO

SET NOCOUNT ON;

DECLARE @SEARCH_VALUE INT = 19;

DECLARE @TXML XML

set @TXML = '<row id="10000000" xml:space="preserve">

<c1>Name 1</c1>

<c2>Name 2</c2>

<c10>40</c10>

<c10...

Hi and welcome to the forum.

Could you provide some sample...

Jeff Moden (9/12/2014)

---

The following should do it (see attached). I made sure that it's a high performance iTVF instead of an mTVF. I also got rid of the...

I've...

Feel your pain mate, and be prepared, this may not be your last stumbling block using...

g_rose42 (9/13/2014)

---

I have facing some difficulties to build a SQL Query for my new requirement below is my table I have to list the items and paramlist in the gridview

i...

...and if you select substring([column],1,2) from the table?

😎

Almost any consumable data...

Thanks Tony, couldn't have said it better!

😎

Are all servers 2012?

😎

Assume you are using SSIS and CDC components, have you checked the credentials, expired password?

😎