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

mrpolecat (9/25/2016)

---

The incentive periods are 3 calendar months if there are no suspensions not including the end date in your example.

If an agreement starts on 1/1/2016 then the baseline incentive...

pietlinden (9/24/2016)

---

Good news! Easy question...

I have a simple data warehouse. Looks pretty much like your standard sales data warehouse with dimensions (why do I want to write "Dementias"??) like:

Customer

Product

Calendar

Territory...

The only...

Quick questions

😎

1) By activity period of 3 months, do you mean three full calendar months, i.e. 1st. January to 1st. April, including both start and end dates?

2) Does the duration...

Quick questions

1) How large are the data sets which are being processed in the SSIS packages?

2) Are those sets sorted within the packages?

3) Are the DefaultMaxBufferSize and...

rodjkidd (9/23/2016)

---

Hi Eirikur,

Thanks for replying.

I'm actually on my way home.

I'll check when I get in.

I had to anonomise the data manually so I may have messed up something. Both the...

GilaMonster (9/23/2016)

---

Restore is whitespace agnostic,...

ramana3327 (9/23/2016)

---

Hello Experts,

I am facing issues with database restoration using different server backup.

We have SQL 2005 instance. I took backup of the database (Nearly 1 TB) using Litespeed.

The command I...

Quick thought, the value of the variable will not be compiled but set at run time

😎

CTE example to get an execution plan

DECLARE @VAR_01 INT;

SET ...

Cleaned up the XML, here is a query that brings back the desired tags by the looks of it, not all the values are matching though???.

😎

DECLARE @TXML XML = N'<?xml...

rodjkidd (9/23/2016)

---

Oh and a couple of other things. The non repeating tags (header and footer in my head) are counted as rank 1, along with the first repeating group. Its...

Everything needed was already in the code sample;-), here is a function that returns one year

😎

USE TEEST;

GO

SET NOCOUNT ON;

GO

CREATE FUNCTION dbo.ITVFN_CALENDAR_YEAR

(

@YEAR INT

)

RETURNS TABLE

WITH...