This is interesting, I wonder if we could...

This code returns the node structure of the XML

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TXML XML = N'<EssRoot>

<T.6.03.0>

<eventTS>2014-09-10T23:51:53.0Z</eventTS>

<equipment unitAddress="105328605" equipType="tractor" alias="0105328605" ID="0105328605" />

<position lat="42.76819444444445" lon="-78.59981481481482" posTS="2014-09-10T23:51:48.0Z" />

<posType>1</posType>

<ignitionStatus>1</ignitionStatus>

<tripStatus>O</tripStatus>

<ltdDistance>0.0</ltdDistance>

<speed>0</speed>

<heading>0</heading>

<workflowEventType>loadAtTerminal</workflowEventType>

<data id="X_XMM_FILTERED">

<datum name="sortId" value="100" />

<datum name="destSortId"...

ScottPletcher (9/16/2014)

---

If there's always at least one decimal place:

SELECT

value AS original_value,

SUBSTRING(value, 1, CHARINDEX('.', value) + 1) + '%' AS new_value

FROM (

...

g_rose42 (9/14/2014)

---

Thanks for the reply. But I think that split function gives the values by row. i need it by column by.

Even though if i convert into row by...

Here is a quick exsample of node shredding based on your XML sample, if the structure of the XML is not changing then this could be the right direction.

😎

USE tempdb;

GO

SET...

Quick solution (if I got this right, only on the first coffee in the morning:-) ), using another Tally table to generate the missing numbers.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SerialNumber VARCHAR(1024)...

rob.delong (9/15/2014)

---

Consider a situation where a stored procedure taking a varbinary(max) (BLOB) input parameter then calls a nested stored procedure and passes along that varbinary(max) as an input parameter to...

cstg85 (9/16/2014)

---

I am working on a project to pull data into SQL Server from flat text files. The issue I am having is with the date and time columns. In...

Quick thought, if no auditing is in place, start with the short list Gail mentioned.

😎

andyscott (9/16/2014)

---

A breakthrough! I've managed to find a way to sort the individual line segments into order, reversing those that were "backward" with respect to the others. In the process...

abhas (9/16/2014)

---

Hi bros,

I need to compare the next row with the previous row of same table and produce nonidentical column.

for eg... say

mytable has

Row 1 => 1001 Abhas 120 150...

Smash125 (9/16/2014)

---

I have a column called as NDM$ What I want do it round it the nearest value example I am giving below

34.100->34%

39.8->40

35.4->35 some thing like that. please le me...

Quick thought, this can be simplified with the charindex function, no need to actually split the input. The focus must be on what has to be done, not how;-)

😎

DECLARE @reportID...

Jeff Moden (9/15/2014)

---

Eirikur Eiriksson (9/13/2014)

---

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...

dexdev (9/15/2014)

---

Hi,

Hope you guys can help...

We created an application that is using multiple dbs, one for each client using the application. All dbs are identical, each db holds the client's...