It's actually possible to do this without dynamic SQL and still have it be general enough that it will automatically handle changes to the table definitions.

This hasn't been completely optimized,...

I finally had a chance to test this on a table with 18K records. Here are the results for producing a grand total:

WITH ROLLUP

Table 'Worktable'. Scan count 0, logical...

sayedkhalid99 (9/22/2010)

---

one thing more is it possible to add total also at the bottom for each months and quarters , i tried to use union didn't work , do...

That's very interesting, but, realistically, how often do people use nondeterministic functions like NEWID() in the comparison expression...

What situations do you find unclear? I...

No. You can only update one table per UPDATE statement. You can simulate this using an INSTEAD OF trigger, but it's probably easier to just do this in...

That's a rather broad topic and probably beyond the scope of this forum unless you have a more specific question. You're better off searching for T-SQL tutorials.

I will say...

Well it's not pretty, but you can get the LOG10() of the numbers, sum them and then raise 10 to that power.

Drew

And also the desired results. For example, if you want a single field with a delimited list of the parameters, you might want to use a subquery with a...

The system view INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS will tell you which unique constraint is referenced by each foreign key constraint. The system view INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE will tell you which columns are used in...

I don't find it at all...

Derrick Smith (9/16/2010)

---

r.rozeboom (9/16/2010)

---

all good guys. you all mean well.

But can i do this with t-sql?

i think i forgot to say it has to be done on demand. not so...

He only said that the database was running...

Why would you use DTS when you have SSIS available?

Reporting Services may actually be the best...

That's because you have your TOP clause in the middle of...