Jayanth_Kurup (8/2/2015)

---

seems fairly simple , i would personally use partitioning since it handles the whole process with far less stress on the DB but it would be just as easy...

I wish that I could get some example code to perform this.

I'm Swamped at the moment.

Thanks.:-)

Jeff,

That was I thought. Thank you for responding and have a great day.

We do transaction log backups every 5 minutes and I had this new women zap a table on...

homebrew01 (9/9/2011)

---

Ivan, "Archive" is a simple word with many possible complexities.

it might help if you could explain your goals. What is the current environment ? What do the users...

Yeah really I'm shooting blanks when it comes to recall what I did.:blush:

Jayanth_Kurup (8/2/2015)

---

seems fairly simple , i would personally use partitioning since it handles the whole process with far less stress on the DB but it would be just as easy...

I would prefer not to go with partitioning.

About ten years ago I created at table that captured the start and end date. The number of records Committed etc.

I wrote code...

Does anyone have a script to archive data?

Yes Sir.

Hi Lynn,

A Business Analyst gave me a requirement to create a new table when in fact there already is one.

I commented the sub query replaced it with a CASE Statement.

This...

How do I filter the sub query to return one record from my Credit Lookup Table?

I found out that I need to get the ID not the Description and as a subquery must JOIN with this code:

create table #tmpContractorCreditReports

(

AutoID int identity (1,1),

Contr_ID int,

CRRPT_ID_NB int,

CRRPT_RUN_DT datetime,

reporttype...

Thank you! 🙂

Basically what I'm trying to do is to populate the ActionRating Column in the #ImportExperianDataTest Table based on the Min_Score Column in the ActionRatingDuns Table.

I need to return as part of the SELECT Statement the Experian Score that is derived by comparing the score in the #ImportExperianDataTest Table it to a range in...