Here is a quick solution, should help get you passed this hurdle. It demonstrates that you can use INNER JOIN and retain the full details of the set by using...

Hi and welcome to the forum.

Could you post the DDL (create table script) and possibly some sample data, makes it easier to provide an accurate answer, for more information,...

Good stuff and congrats;-)

😎

Quick thoughts, there is quite some room for improvements such as using a single variable instead of the getdate function, a case statement can be replaced by simple arithmetic "12...

Quick thought, there is no need for a self-join as this is an elementary set problem which is easily solved using the window functions in SQL Server 2005 or later.

USE...

It depends on what exactly you want to do, you can...

Here is a quick solution, should...

SQLRNNR (9/12/2014)

---

Ed Wagner (9/12/2014)

---

Without objection, it is so...

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

...