paulo.morgado (4/21/2014)

---

I'm sorry but I failed to get an answer from the provided link.

I have a query that evaluates into an XML document.

I want to read it with SqlCommand.ExecuteXmlReader.

But the...

Brandie Tarvin (4/21/2014)

---

Nevermind. I'm in brain-dead...

PSB (4/21/2014)

---

I have a couple of 14 digit int time in my table

SELECT DATEADD(hh,-5,dateadd(s, convert(bigint, 61353491400000) / 1000, convert(datetime, '1-1-1970 00:00:00')))

The above query throws an error :

Arithmetic overflow error converting...

Open the Script Task Editor and choose Edit Script. In the VSTA editor, select Project menu and Add Reference...

😎

Check out Using XML Data Types on technet

😎

Jeff Moden (4/20/2014)

---

Ok... I have to ask. What do either of those functions do for creating a table other than returning some meta-data that you could write some dynamic...

Quick question, why are you using the nolock hint?

There where two table value functions introduced in 2012, sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object, the former takes a query string as a parameter, the latter an object id. The result sets are...

An alternative, without the STCrosses function, filtering using STIntersects.

😎

DECLARE @GEOLINE TABLE

(

GEOLINE_ID INT IDENTITY(1,1) NOT NULL

,GEOLINE_LINE GEOMETRY NOT NULL

);

INSERT INTO @GEOLINE (GEOLINE_LINE)

VALUES

(geometry::STGeomFromText('LINESTRING(0 1,...

If the search string is only one word/pattern then a recursive approach could be an option. Or maybe a combination of the two?

😎

DECLARE @searchString nvarchar(255)= 'first';

DECLARE @DISP_SIZE INT = 50;

...

1397750400000 Minutes

23295840000 Hours

970660000 Days

2657522 Years

The first birthday of Homo habilis?

😎

Just for fun (with nothing better to do), a recursive and a window function approach 😎

Neither are perfect, more like a little twist....

A resource hungry recursion:

USE tempdb;

GO

IF EXISTS (SELECT *...

redcn2004 (4/19/2014)

---

when c0=1 and a0=b0 then print

when c0=1 and c1=1 and a0=b0 and a1=b1 then print

when c1=1 and a1=b1 then print

when c1=1 and c2=1 and a1=b1 and a2=b2 then print

....

...

Yes, I missed the typo:w00t:

I see your design i think between Payment...

Boils down to the same thing, the exception rolls back the...