adrian.facio (5/3/2012)

---

Ok i read your comment now, then the firts version i wrote is ok, i just allows up steps. I just accepts Single, Married, (Divorced or Widowed). i does...

adrian.facio (5/3/2012)

---

The idea is to order the status changes of a employee chronologically. Now, every status has the "Step Value", if two consetive items are different by 1, then...

Similar to the above:

CREATE TABLE dbo.Entries

(

entriesID INT IDENTITY(1,1) NOT NULL

,name VARCHAR(20) NOT NULL

,packageLevel TINYINT NOT NULL

);

INSERT INTO dbo.Entries (name,packageLevel) VALUES ('aa',0);

INSERT INTO dbo.Entries (name,packageLevel) VALUES ('bb',1);

INSERT INTO dbo.Entries (name,packageLevel) VALUES...

adrian.facio (5/3/2012)

---

I make the following.

;WITH CivilStatus (StatusSequenceNumber,[Marital_Status])

AS

(

SELECT 1,'SINGLE' UNION

SELECT 2,'MARRIED' UNION

SELECT 3,'DIVORCED' UNION

SELECT 3,'WIDOWED'

),

PersonCivilStatus

AS

(

SELECT d.empno,d.marital_status,d.status_change_date,

Sequence = row_number() over (partition by empno order by status_change_date),

StatusSequenceNumber

FROM #temp_delete_duplicate d

INNER JOIN...

ColdCoffee (5/3/2012)

---

Schema binding has its own advantages and disadvantages.. But whn u create a view, how ofter do u alter it? You wouldnt right? then i think, schema binding can...

komal145 (5/3/2012)

---

I would say..it should satisfy the other thread too and also when I was looking at the different strings , they are not satisfying the rules

1) needed the name...

SSC is at 1,499,895 and counting!

Actually, in my code above, just insert your source table for the derived table in the from clause of the cte I marked for replacement.

You may have to make some...

Here is my solution:

DECLARE @StartDate DATETIME;

SET @StartDate = '20111208'; -- Sample start date

WITH

e1(n) AS (SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL SELECT 1 UNION ALL...

Tony Farrell-305085 (5/3/2012)

---

Hi Lynn,

I am sorry....

The user will select one day from the interface screen.

The stored proc will take that date and gather only the logins for that date.

Breaking the...

Now, a question. Do we need to satisfy both the requirements here and the other thread? You had one string in the other thread that you wanted the...

For future reference, you really should have continued using that thread and expanded on...

Just to be sure, my problem is that I'm not sure where to start to help you solve this problem and I need your help to do it. The...

Grant Fritchey (5/3/2012)

---

Sean Lange (5/3/2012)

---

Just an observation and a friendly reminder.

/soapbox on

We are starting to lean too far to the arrogant side with many of our replies (and yes I...

SQL Kiwi (5/3/2012)

---

Lynn Pettis (5/3/2012)

---

Not trying to...