Hey everyone thanks for your help. I got the green light to use partitioning on the production database. Basically we have a database where we keep 31 days of logs...

I will post requested scripts as soon as I get a free moment.

Skull Killer, I think your sample code will create an infinite loop - but I get the point.

Steve/Jeff thank your for your replies.

Jeff, I would be interested in learning more about the "chunk" routines.

Also, alternatively do you think this would be a good time to try out...

shirmanov (12/11/2008)

---

Why don't you use backups of prod_db and restoring them to the archive server? or you mean that you actually compare and copy only the new data from ServerA.prod_db...

Well I am allowed some margin of error with the time range, so this turns out to be the best solution I came up with:

First aggregate the data:

declare @time_divisor float

select...

bang.prashant (9/30/2008)

---

I have data in column1 having datatype -varchar (4)) with 2 values - Yes or No

I want to insert this data into other tables column2 having datatype -bit.

how to...

I figured out how they did it. The sp that is called for the main dataset has several parameters that by default are null, but if something is passed into...

perry.pierce (9/23/2008)

---

I have a table with a nvarchar field named Violation number that contains data in the following format 5.1.3(38), or 5.1.3.(39) etc etc.

When I query this table with...

Activescript is used for Adobe Flash my friend. 🙂

On the other hand, ActiveX scripting is very a large arena, and not something one can teach you in one forum post....

ramaanujamr (9/23/2008)

---

Hi,

I have an issue, i just want to find school days between S and E for the students. I added school days column but it didnot work. in...

You can do this in a job-

Set first step to type ActiveX Script and create code (using the Scripting.FileSystemObject) throw an error # of files are not there.

Second step...

timothy.j.little (9/23/2008)

---

When i Parse this query it goes through , but when i execute it i get an error , don't know what is causing it any help would...

You can join the table with itself like so:

select t1.student_id, t1.date_time startdate, t2.date_time enddate, datediff(dd,t1.date_time,t2.datetime) attendance_days

from attendance t1 join attendance t2 on t1.student_id = t2.student_id

and t1.type = 'S' and t2.type...

How do you know what row is a start date, and what row is an end date? Is there a field, or are you making assumptions based on which date...

I think I can make something happen with that.... Thanks!