I think this will do the trick to get someone's...

All you need to do is change precedence constraint from Success to Completion.

I wanted to include the XML technique for this because Text1,2 & 3 all look like truncated XML (are those the actual values or did you truncate the values for...

Ok, I know this thread is old but if PatternSplitCM[/url] was available when this was posted you could do this:

DECLARE @string varchar(100)='1:1,3,5,7,4:56,43,58,5:34,67r,234';

WITH prep1 AS

(

SELECT x.ItemNumber,

ROW_NUMBER() OVER...

From your example code it's hard to determine what you are changing the table names to. Below is a script that works without any cursors or loops to rename tables...

I misunderstood the OP and updated my function to do what I think you are trying to do (it was originally searching for an id instead of six consecutive integers....

Edit: misinderstood the requirement. Updated my function accordingly...

With the DelimitedSplit8K[/url] splitter function you could create an inline Table Valued function like this:

CREATE FUNCTION dbo.string_to_table(@string varchar(8000))

RETURNS TABLE

AS

RETURN

(

SELECTLEFT(item, CHARINDEX('...

There are a number of ways to do this without a cursor. Here's a great article:

Concatenating Row Values in Transact-SQL[/url]

You could use the FOR XML PATH method and rewrite...

mittensonmaui (10/22/2013)

---

Hi all I am running a query where I check medical orders on an encounter there can be 1000's of orders and if one of them matches a specific...

Just to add to what Koen said...

The only way to guarantee that rows are returned in a specific order is when ORDER BY is used.

It's also worth noting...

Below is an example of what I think you are trying to do. This proc will keep...

Because you are dealing with a one-to-many parent/child node relationship you could start your query with /Root/device/sensor as your context like so:

(Taking the example code that Mark was nice enough...

Though impossible to demonstrate without any DDL for the underlying tables it certainly does look like you can convert your function into a Inline Table Valued function (as has been...

tomek tomek (10/16/2013)

---

Well....

I kind of have a solution, but it's messy (especially that I acutally have more tables like these to merge, and obviuosly there come joins with other tables).

Maybe...

Sorry for the late reply, I've been traveling and super-busy but have been meaning to get back...