ksrikanth77 (7/3/2014)

---

Thanks all you for your responses, however When I print or Exec the result is Command Completed Successfully.

My request is

I have a company table with the Name Column...

That really isn't too bad. You should see the PeopleSoft ERP systems for Finance and HR, around 50,000 tables in each.

Doesn't include views, or other database objects.

Eugene Elutin (7/3/2014)

---

Yep,...

Looking at the code you provided I am wondering why you want to eliminate the cursor. You are looping through a set of tables to import the data from...

I agree. With 3,250,325 rows in the main table mine ran in about 3 seconds.

[/quote]

what spec hardware you running Lynn.....?[/quote]

Dell M4600 laptop, dual CORE i7 with...

I was asked a similar question in an interview. The problem I used was a time out issue on our Finance system after upgrading from SQL Server 2000 to...

J Livingston SQL (7/3/2014)

---

Arno Ho (7/3/2014)

---

Hi,

Thank you for all your answers and proposed solutions

I applied that Lynn

With my method it takes 15 minutes and 12 minutes with the Lynn...

Yea, our databases would perform so much better without them! :w00t:

Also, the initial means of attacking this depend on how many rows of data make up the past 30 days. Once you have done the initial archive (which may...

Another quick question, are we talking a running total?

One thing everyone seems to leave out, listen to your users. Yes, tuning a stored procedure to shave .05 that only takes 0.2 seconds to complete and is called...

Again, based on the existing sample data, what are the expected results.

Took a queue from J Livingston SQL's code and rewrote mine. I think it is comparable to his, but compared to mine, about 4 times faster, and reads down...

J Livingston SQL (7/1/2014)

---

Lynn Pettis (6/29/2014)

---

How about giving this a shot. You may also be able to run this against all ID_Resource entities at once instead of one at...

First, are you using SQL Server 2012 or SQL Server 2005? You have double posted in two different forums.

Second, please don't double post, it fragments answers you may get.

Third,...