Thanks, I'll give it a go.

😎

Bear with me here, but why not do this in TSQL as a set based operation?

This is true (the CLR are...

Roust_m (5/26/2014)

---

Hi,

I have a query, which eats massive amounts of CPU because of a CLR function, which deals with local time (our server system time (US) is different from local...

This should get you started

😎

/* convert geometry to geography */

DECLARE @GEO1 GEOMETRY = geometry::STGeomFromText('POINT (-122.358 47.652)',0);

DECLARE @GEOG GEOGRAPHY = geography::Point(@GEO1.STY, @GEO1.STX, 4326)

/* Geography shape/poligon */

DECLARE @g geography = geography::STMPolyFromText('MULTIPOLYGON(((-122.358...

Jeff Moden (5/25/2014)

---

Eirikur Eiriksson (5/24/2014)

---

Must say that I'm slightly puzzled. I have read my post over and over but I cannot find neither any implicit nor explicit suggestions of ignoring...

Must say that I'm slightly puzzled. I have read my post over and over but I cannot find neither any implicit nor explicit suggestions of ignoring good coding or working...

There is a wealth of technology options to help you out on this, the pitfall is to choose one before the requirements are carved in stone! A handful of million...

hunchback (5/23/2014)

---

The row_number function here is not deterministic, meaning the result could change even if it runs against the same data, because the ORDER BY clause is meaningless (ORDER BY...

The order is important and must be respected in the XML but in the result set it is not. Therefore, use the row_number function to assign the "order" when shredding...

Not certain what the problem is, testing your code with an addition of a row_number consistently brings back the results in the expected order.

😎

declare @Products xml = N'<BS>

<B Id="5" />

<B...

Without more information, the answer is it depends. What kind of queries, aggregation? How does the schema look like etc.

😎

Quick question, what has changes since the last successful attempt?

😎

Sean Lange (5/22/2014)

---

OK Now I get what you were saying. I just missed it because the portion of what you posted had no context to the whole dynamic sql issue....

I suggest you change from the + (addition) concatenation to the CONCAT function, it should implicitly cast the input to the appropriate character type if it does what says on...

First of all, sorry for my hurried and incomplete postings on the subject, the question is about parameter binding and sql injection, I recognise that this is slightly (read...