Probably not without some convoluted dynamic sql since it looks like you want to exec the query stored in the table as part of selecting data from the table.

How big are some of the tables? If you are doing a full scan, it could take awhile on fairly large tables.

Sounds like an audit table is needed to capture this info for future analysis. What you are looking for you can find in Books Online, the SQL Servr Help...

mpv (7/7/2009)

---

mjarsaniya,

I don't see what you did, other than adding code to create the tables with data. I assume you are implying that I need to do this whenever I...

ramdas.narayanan (7/7/2009)

---

Here is the query,

In the result Ram has one class in feb as per the data...

SELECT teacher,

Jan=SUM(CASE WHEN DATEPART(m,Date)=1 THEN 1 ELSE 0 END),

Feb=SUM(CASE WHEN DATEPART(m,Date)=2 THEN 1 ELSE...

I agree with Wayne on both points. I have the same article referenced below in my signature block as well. It is the first one regarding asking for assistance.

First question I'd ask is what is the error message? Can't diagnosis a problem from this "returned an error message".

One possiblity, highly fragmented disk and the SQL Server couldn't...

How many tables in the database? I have a database with over 50,000 tables and the update stats takes awhile even though many of the tables are empty.

I missed too! I knew the correct answer, if I had noticed it was using table variables. Missed that, choose the wrong answer.

Perfect, just what I wanted to see. thank you for posting your final code as well for others to view.

Upper case reminds me too much of COBOL, plus I don't like having to hold the shift key while typing or using the caps lock.

Natural Keys vs Surrogate Keys

Here's a battle. I like the idea of using Natural Keys, but sometimes thoses are the best choice as they can change which affects historical...

sqlguru (7/7/2009)

---

Actually, it's not.

The DB automatically creates the foreign keys between the two tables BUT it is not seen by the...

I like it because you get in and get out as quickly as possible.

Okay, but what edition?