I thought there was something odd with desired results 😉

😎

Here is a solution to your problem...

Jeff Moden (9/26/2016)

---

We've just been through patch hell. It broke some very important C# code on one of our servers. We had to roll back the update in...

I'm just to lazy to write "(SELECT NULL)" when @@VERSION does the same thing, that is tells the server to...

Quick questions, are you using SQLite or SQL Server? Can you post the DDL (create table ) scripts for the relevant tables, sample data as an insert statement and the...

Can you please post the DDL (create table) scripts for the relevant tables and sample data as an insert statement?

😎

The design and the desired results are somewhat odd as it requires a union of the reference data.

😎

USE TEEST;

GO

SET NOCOUNT ON;

--

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

CREATE TABLE #SourceData(

Name...

The If_x0020_Other does not add a level as it is the sibling of the Delivery_x0020_Method node, therefore the query is the...

jbalbo (9/26/2016)

---

Hi

I use :

CROSS APPLY Data.nodes('/Data/Delivery_x0020_Method/Service_x005F_x0020_Note_x005F_x0020_additions_Delivery_x0020_Method_Option') m(Node2)

WHERE ( Node2.value('Checked[1]',...

Quick suggestion, use WinHttp.WinHttpRequest instead.

😎

Here is an example previously posted on this thread

CREATE function [dbo].[GetHttp]

(

@url varchar(8000)

)

returns varchar(8000)

WITH EXECUTE AS OWNER

as

BEGIN

...

No, a session cannot deadlock itself and there are two different spids in there, spid="186" & spid="200".

😎

On the other hand, this looks like a multi threaded Entity Framework application...

YAA (Yet...

Luis Cazares (9/26/2016)

---

mw112009 (9/26/2016)

---

Eirikur Eiriksson:

Sorry, but the first 2 entries in your solution should not be there. The output that I wanted will have exactly 3 "\" characters included.

I will...

Quick alternative to Luis's fine solution

😎

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

CREATE TABLE #t( pathx VARCHAR(400) ) ;

INSERT INTO #t ( pathx ) VALUES ( '/CaseRateAnalysis/');

INSERT INTO #t (...

Kaxtanhu (9/26/2016)

---

Greetings dear all,

I've a column in a table with type NVARCHAR(50), with values that now "people" decided to turn it in an encrypted value. The only way that I...

Quick suggestion

😎

;WITH FIRST_NAME_DATA AS

(

SELECT

FN.C_ID

,FN.C01

FROM dbo.TestTbl1 ...