Snargables (9/12/2014)

---

When i run it from sql server data tools on the test box it runs fine. However when i run it from the ssisdb directly i get the below...

Geonames

😎

TomThomson (9/11/2014)

---

Although the first two chunks indicate clearly that NULL is ordered low by ORDER BY, they don't indicate anything else.

The "spanners"...

Eugene Elutin (9/11/2014)

---

Eirikur Eiriksson (9/11/2014)

---

F. van Ruyven (9/11/2014)

---

Eirikur Eiriksson (9/9/2014)

---

Alan.B (9/9/2014)

---

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very...

mario17 (9/11/2014)

---

Hi, Eirikur

This is one way Xactional Replication, I suspect that was done in bulk, I don't really know answer about article, most likely it default (so could be Table...

F. van Ruyven (9/11/2014)

---

Eirikur Eiriksson (9/9/2014)

---

Alan.B (9/9/2014)

---

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very interesting :laugh:

Edit: sql code...

Quick code to get you passed the hurdle

😎

USE tempdb;

GO

IF OBJECT_ID('dbo.staff_attendance') IS NOT NULL

DROP TABLE dbo.staff_attendance;

create table dbo.staff_attendance

(

attendance_id int

...

mario17 (9/10/2014)

---

Hi, all

That what we got, we had very nice tuned MView defined on Server01 against tables in dbA and dbB (on same Server01).

OK it's time to...

More for fun, here is a quick alternative solution

😎

USE tempdb;

GO

DECLARE @NOW DATE = GETDATE();

;WITH CV_WORKEXP(CVID,StartDate,EndDate) AS

(

SELECT CVID,StartDate,EndDate FROM

(VALUES

(28387 ,'2008-01-01','2012-09-01' )

...

Eugene Elutin (9/10/2014)

---

Eirikur Eiriksson (9/9/2014)

---

Alan.B (9/9/2014)

---

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very interesting :laugh:

Edit: sql code tag...

TomThomson (9/10/2014)

---

Stefan Krzywicki (9/10/2014)

---

TomThomson (9/10/2014)

---

It's probably the...

GilaMonster (9/10/2014)

---

Well, months have no more than...

Alan.B (9/9/2014)

---

IF @user > '' --This checks for not null and not empty

Cool. I never knew you could do that, very interesting :laugh:

Edit: sql code tag messed up my "greater...

The code is missing the FROM clause in addition to few minor syntax errors, here is a quick correction

😎

Declare @Sem varchar (12) = Null

DECLARE @Decision varchar(1) =...

GilaMonster (9/9/2014)

---

In short, if you don't have explicit transactions (BEGIN TRANSACTION ...), there's no reason to have xact abort on. Xact abort defines whether an explicit or implicit transaction rolls...