What error are you getting?

Edit: Why not just exec the proc? There's no point to a temp table in the code you posted.

Michael Valentine Jones (1/2/2008)

---

I prefer to write date queries in the form of greater than or equal to a start date time, and less than an end date time....

Pleasure

Cool. Didn't notice that. Thanks

For the beginning and end of the day, week, month, quarter, year...

http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/%5B/url%5D

I've done the end of the intervals at 3ms before the beginning of the next (ie, end of today...

Kenneth Fisher (1/2/2008)

---

Ok probably one of the more interesting discussions on NULL and comparison operators but I have a question. I feel like I missed the 1st half of...

Good point. Thanks.

Use the sys.object view, rather than sysobjects. sys.objects has both a type and a type_description column, so you can see exactly what's what.

CTEs are nice for generating smallish amounts of data, but the max number of rows a recursive CTE can return (without using cross joins, union or while loop) is 32767....

MarkusB (1/2/2008)

---

sys.dm_db_index_operational_stats contains a column "leaf_allocation_count "

which according to BOL means "Cumulative count of leaf-level page allocations in the index or heap. For an index, a page allocation corresponds to...

Thanks Markus. Will check that out.

Chirag: I'm not looking for the umber of pages in the index. That's easy. What I'm trying to get an idea of is how often...

You can read the contents of the system tables if you connect using the DAC. They're not that interesting and are quite hard to understand, since there's no documentation anywhere....

Joins done in the from are easier to read and reduce the chances of getting an unwanted cross join.

In addition, the old-style outer join syntax (Table1.Col1 *= Table2.Col1) is...

Add a column of type int (that's 1.4 million records you have. Int goes up to 2.1 billion) and set identity on.

Edit: And if you do expect more than 2.1...

Check my tran log backups, make sure they are running....