Immigrant

Quick thought on optimization, as Alan mentioned, the text() method is faster.

😎

Same XML data sample as before

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @xml XML;

SET @xml =

'<?xml version="1.0" encoding="UTF-8"?>

<result resultID="200">

<status>OK</status>

<message></message>

<countryCode>US</countryCode>

<zoneName>America/Los_Angeles</zoneName>

<abbreviation>PDT</abbreviation>

<gmtOffset>-25200</gmtOffset>

<dst>1</dst>

<timestamp>1430141082</timestamp>

</result>'

Looking at...

For fun, there are few ways of doing this:

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @dt DATETIME = '2014-04-09 13:22:31.544';

;WITH BASE_DATA(TTDATE) AS

(

SELECT DATEADD( HOUR , 14 , CONVERT( DATETIME , FLOOR( CONVERT( NUMERIC(8,1)...

Top

Koen Verbeeck (4/27/2015)

---

Brandie Tarvin (4/24/2015)

---

GilaMonster (4/24/2015)

---

Also watch out for the sun. You can get sun burn far easier at high altitudes than low. Take sun cream, use it liberally, even...

sureshjevani 78421 (4/27/2015)

---

Can some kindly help me how to move sql 7.0 to sql 2008R2. We have 10 databases and there are 15 DTS Packages but when I script out...

SQLRNNR (4/27/2015)

---

Lynn Pettis (4/27/2015)

---

How many people...

The horror

TomThomson (4/27/2015)

---

Very nice question.

It's interestng that 12% or answers to date appear to come from people who beleive that allorders in any given year must occur on teh same date....

Poultry

Hut

Crossing

Hugo Kornelis (4/27/2015)

---

Eirikur Eiriksson (4/27/2015)

---

Another thing to keep in mind is the somewhat strange OVER defaults, recommend always filling those in rather than relying on the supplied defaults. Koen has...

Looks like BOL has an error:

😎

OVER ( [ partition_by_clause ] order_by_clause)

partition_by_clause divides the result set produced by the FROM clause into partitions to which the...

Quick question, have you tried to run the packages with the dtexec Utility?

😎

I suspect that this may be a quirk in the Visual Studio interface, certainly you don't intend to...