Quick though, possibly the most straight forward thing to do is to run the Profiler and catch the actual statements being run.

😎

olibbhq (7/11/2016)

---

Thank you, I have been so caught up with the issue I must have mixed up the isbn's! Thank you so much for helping me with the fix, tested...

olibbhq (7/11/2016)

---

Thank you, this works in your example but when I pull it from google it doesnt. Please try with the full script below. (I will replace the api key...

VastSQL (7/11/2016)

---

Eirikur Eiriksson (7/11/2016)

---

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

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