Quick suggestion, simply use OPENJSON with the path name, no need to use JSON_QUERY

😎

USE TEEST;

GO

SET NOCOUNT ON;

--

DECLARE @returnedCitation NVARCHAR(MAX) = N'{

"kind": "books#volumes",

"totalItems": 1,

"items": [

{

...

Quick suggestion that looks first for 3 digits and then 6 digits in the remainder of the string

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#TestString') IS NOT NULL DROP TABLE #TestString;

create table #TestString(OldString...

VastSQL (7/11/2016)

---

Hi Experts,

The BatchRequest\Sec value for our OLTP system is showing 150 for the most critical time. I felt this as very low , can you guide me on what...

You are very welcome.

😎

ulisseslourenco (7/7/2016)

---

People,

I have a tsql code with for XML explicit and when there are empty value the code must be <tag><tag/> instead of

<tag/>, but I didn't know...

Quick thought, only one modification can be done with modify at the time, therefore it may be simpler to use either a query or FLWOR (For, Let, Where, Order by,...

Here is a quick solution that starts by selecting the DataArea node and then remove the Sync node from the selection, should be enough to get you passed this hurdle.

😎

DECLARE...

ffarouqi (7/9/2016)

---

Hi Guys,

I am stuck in a situation where the sliding window job is throwing me an error as such. I am not really sure on how to deal with...

Missed the three hours earlier, here is an improved query

😎

;WITH SAMPLE_DATA(ID,datetime,rain) AS

(SELECT ID,CONVERT(DATETIME,datetime,112),rain FROM (VALUES

(1,'20160101 01:00:00', 0)

,(1,'20160101 03:00:00', 8)

,(1,'20160101 05:00:00', 6)

,(1,'20160101 06:00:00', 0)

,(2,'20160101 08:00:00', 6)

,(2,'20160101 10:00:00', 0)

,(2,'20160101 15:00:00', 0)

,(3,'20160101...

Quick suggestion, look up the SIGN function

😎

;WITH SAMPLE_DATA(ID,datetime,rain) AS

(SELECT ID,CONVERT(DATETIME,datetime,112),rain FROM (VALUES

(1,'20160101 01:00:00', 0)

,(1,'20160101 03:00:00', 8)

,(1,'20160101 05:00:00', 6)

,(1,'20160101 06:00:00', 0)

,(2,'20160101 08:00:00', 6)

,(2,'20160101 10:00:00', 0)

,(2,'20160101 15:00:00', 0)

,(3,'20160101 16:00:00', 0)

,(3,'20160101 20:00:00',10)

,(3,'20160101...

Jeff Moden (7/3/2016)

---

From what I've heard, it's because they don't...

Michael L John (7/5/2016)

---

Can anyone in the U.K. (or is it K minus U these days?) make a recommendation for technical training? We have a colleague in London who's...

Quick thoughts Thomas, do not use a while loop as there is no need for it and neither a table variable which will only introduce extra pressure on the tempdb.

😎

Here...

Have a look at Brent's excellent post on the subject[/url]

😎

Spam, spam and again spam 🙁 Why on earth is it so hard to tackle this problem on sqlservercentral.com???

😎