rocky_498 (12/24/2013)

---

I am 100% agree what you are saying, however its really hard for us to fix this problem, due to lot of restrictions or human entries...

Any Code advise...

pietlinden (12/23/2013)

---

Your field sizes and some of the types are a bit over the top.

DOB NVARCHAR(50)? Makes doing date math really hard.

ID NVARCHAR(50)? Can't you use...

And saying that it is "hard to stop" in the front end is simply not true. Try running the following:

CREATE TABLE #Table1

(

ID NVARCHAR(50),

FName NVARCHAR(50),

LName NVARCHAR(50),

DOB NVARCHAR(50),

Active bit,

PRIMARY KEY (FName,...

One of the main points of an application...

I'm afraid your response still leaves a lot of open questions, so I guess I'm just going to need to give you a general answer.

When you do the first UPDATE...

That took more than a minute to sink in but...

Merry Christmas to all!

And may your New Years be filled with new learning opportunities, lasting relationships, new friends, good health and prosperous ventures.

What if there are overlaps in your groups?

How will you maintain the group number in the event your underlying data changes?

I tend to shy away from self-joins on tables because I've found when they have many rows performance can be problematic.

You might want to try this instead:

SELECT EmployeeId, LocationId, ActualStartDate,...

rocky_498 (12/23/2013)

---

--Insert Table1

Insert into Table1 (ID,FNAME,LName,DOB)

VALUES ('1','Smith','Tom','12/12/2011')

Insert into Table1 (ID,FNAME,LName,DOB)

VALUES ('2','Smith','Tom','12/12/2011')

--Insert Table2

Insert into Table2 (ID,PID,PHONE,Address)

VALUES ('1','101','5178896566','Test Ave')

-- Insert Table3

Insert Into Tbale3

VALUES ('101','Active Order')

-- Here is my question....

I am Creating a...

They say at Christmas it is better to give than to receive.

So I will give you back your sample data in a manner that is consumable and thereby the helpers...

Looks to me like if you want to get your months as columns, you'll probably need to use a Cross tab query.

Perhaps the clue that you seek is in one...

Here's a link to get you started on Gaps and Islands.

The SQL of Gaps and Islands in Sequences [/url]

It's a pretty advanced topic though so some of the links provided...

Certainly no need to use a WHILE loop here. This should do it for you:

WITH SampleData (MyStr) AS

(

SELECT '12345678'

UNION ALL SELECT...

Brilliant Jeff, simply brilliant!