You desperately need to do some reading about database design and normalization. This table is a mess and appear to be lacking any attempt at normalization.

As to the question...

For anybody else not wanting to download the text file here is the contents.

CREATE TABLE [dbo].[Name](

[ID] [varchar](10) NOT NULL,

[ORG_CODE] [varchar](5) NOT NULL,

[MEMBER_TYPE] [varchar](5) NOT NULL,

[CATEGORY] [varchar](5) NOT NULL,

[STATUS] [varchar](5) NOT...

Steve Jones - SSC Editor (1/8/2016)

---

Sean Lange (1/8/2016)

---

With that I am off to my son's school. He is in the spelling bee again this year. I think he is the...

With that I am off to my son's school. He is in the spelling bee again this year. I think he is the only student in his grade to make...

simon-hulse (1/8/2016)

---

I'm new to posting on this site although I have worked with SQL for over 20 years I tend not to post as 9/10 times you end up in...

Zohaib Anwar (1/7/2016)

---

Hi,

I am trying to build attached query that is mentioned in the word document. I am struck on one point that is point number 3 in the document....

Maybe you should take a peek at this article about fragmentation. http://www.sqlservercentral.com/articles/Stairway+Series/72443/%5B/url%5D

There is a whole series on indexing in the Stairways section on the left side in the links.

Ed Wagner (1/7/2016)

---

Brandie Tarvin (1/7/2016)

---

BL0B_EATER (1/7/2016)

---

Jack Corbett (1/7/2016)

---

Ed Wagner (1/7/2016)

---

Thanks for the tip, Sean. I've not yet worked at a company that has an IM - I...

Agreed that rolling your own is very poor decision, especially for somebody new to sql server. You will make far too many mistakes. The one from Ola is a good...

Tallboy (1/7/2016)

---

Hi Hugo,

Your right, but every row from the source table could and will have different dates , therefor I need to use a cursor to iterate over them! ...

Tallboy (1/6/2016)

---

Hi, Yes in this case Frequency is 1 which means a date for every date between the two dates and the number of new rows inserted into TblAppointment should...

Agreed I would be...

Phil Parkin (1/6/2016)

---

Michael L John (1/6/2016)

---

Ed Wagner (1/6/2016)

---

Sean Lange (1/6/2016)

---

Ed Wagner (1/6/2016)

---

Brandie Tarvin (1/6/2016)

---

Sean Lange (1/6/2016)

---

Wow. I rarely have to deal with user issues but I was just on a...

Here is a pretty generic example of how you might do this.

if OBJECT_ID('tempdb..#Users') is not null

drop table #Users

create table #Users

(

Name varchar(50)

)

insert #Users(Name)

values

('Francisco'),

('Ashley'),

('Samuel'),

('Georgia'),

('Bernice'),

('Thomas'),

('Janice'),

('James'),

('Martha'),

('Marvin');

with NumberedValues as

(

select Name, ROW_NUMBER() over(order by Name) as...

KGJ-Dev (1/6/2016)

---

Hi,

I have a table called Users and have column called Name. The table has 50000 rows and i want to update the name column as 'Sample'+sequence number like below

Sample1

Sample2

Sample3.....

Any...