Can't you look at the Snapshot Agent job? There should be Duration column.

SQL# CLR library has procedure called String_SplitIntoFields.

There other functions as well. Check it out, maybe it will help.

http://www.sqlsharp.com/

Could it be ..

- Maintenance plan;

- External job scheduled in windows;

If I'm not mistaken, job history usually deleted by this procedure: sp_purge_jobhistory. Try to trace who is...

Check agent properties. There should be a chechbox to auto remove job history.

What is the desired output? I thought it's Account# and Quarter value next to it, No?

You can also UNIONize quarters and then select from that union using quarter number as filter in a WHERE clause.

SELECT *

FROM (

SELECT Account, QTR1 AS QuarterValue, 1...

I don't think I understand this. Can you expand?

Recurs1on (9/21/2012)

---

Query Design ...

9.Do not prefix search arguments in a LIKE clause...

Check this:

http://www.jasonstrate.com/2010/05/doing-something-about-auto-generated-names/%5B/url%5D

I answered "Non of the above". I thought DiskIO in sp_Who2 means reads and writes combined, not just reads as question asks. Am I wrong?

So, you need to compare TableA and TableB and only if match is found insert into TableC ? Match on what? Old and Old? New and New? Both?

How do you...

Your SQL is full of errors. Please fix and post correct statements.

OK, I don't have time right now but here is the setup that you should have provided in your first post. Hopefully someone will help. If not, i'll take stab...

Your desired output doesn’t match the test data. Should we assume that, for example, “Arizona Alabama 788” is also in the original table?

I’m also not clear about 50 tables. Do...

demonfox (8/25/2012)

---

what kind of relationship , do you have in the tables ?

select customer , count(cust)from CustTable a

left join OrderTable

on customer=Cust

group by customer

this may have been the proper code;

why is...

cljolly (8/25/2012)

---

Is it possible that even though I dropped a field in between two fields that are in a group, it didn't become part of the group? How can...