mayurkb (6/25/2013)

---

That's what I was thinking. I do have a prototype ready with this kind of approach. The design is stored proc getting called from .net application hosted in windows...

mayurkb (6/25/2013)

---

Thanks for the reply Sean.

1. The other applications won't be using that data, since it is old data. So it does not impact them.

2. There won't be millions of...

You have been around here long enough to know...

mayurkb (6/25/2013)

---

I'm designing an application which will be run everyday at a scheduled time and it will clean up old data from the database based on its age. I wanted...

Take a look at this thread. http://dbaspot.com/sqlserver-server/457646-stats_ver_current.html

sql2k8 (6/25/2013)

---

Hi ,

Even without making changes like the one you have mentioned above the Job is running successfully.

If i assume Test_Code column is a culprit in the table Table_Test1 how...

Like this?

select id, 'gr'

from sometable

Thanks for the correction Tom. :blush:

sql2k8 (6/25/2013)

---

There are other steps in the Job. The job is failing when it is running the stored procedure which i had mentioned.

I don't see any issues with other steps...

techmarimuthu (6/25/2013)

---

create table members

(

id int identity,

firstname varchar(30),

lastname varchar(40),

dob int

)

insert into members(firstname,lastname,dob) values ('Michel','David',19890630)

insert into members(firstname,lastname,dob) values ('Raja','Kumar',19900625)

insert into members(firstname,lastname,dob) values ('Rahul','Sundar',19910501)

insert into members(firstname,lastname,dob) values ('Arun','Edward',19901219)

i wanna...

Why are all your datatypes varchar? You have dates as varchar, numerics as varchar, State as varchar(40), gender varchar(10), zip varchar(40), phone varchar(20).

Your datatypes need some serious review and normalization...

gurjer48 (6/24/2013)

---

I WORK SSRS report developer projects are very small duration 4 to 5days.

how much duration a ssrs report project takes in big projects ?

can any one help? its...

Hi and welcome to the forums. You are going to have to...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1466933-1632-1.aspx

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1466933-1632-1.aspx