If you're writing this in MSAccess' version of SQL - you may need multiple queries (I don't recall it allowing for sub-queries).

Totals: select count(*) Grandtotal from motivo

SELECT Motivo.motivo, Count(Motivo.motivo) AS...

As far as I know - all you need are two references (that can be set to "copy local" during your project setup):

Microsoft.SQLserver.DTSRuntimeWrapper

Microsoft.SQLServer.ManagedDTS

Assuming those are there I don't think you...

davidthegray (5/6/2008)

---

Hi Steve. Thanks, but this does not really answer my question.

Triggers are supposed to run just once if a single SQL instruction updates several rows in one time. Let's...

You can add references to the "DTS Runtime libraries" and get to the packages from there (it's the SSIS runtime as well, just under the "old" name).

How did...

Rem (5/6/2008)

---

What I meant was if I add a Primary Key Constraint, the data will be sort according my key and will not be a heap table anymore.

In...

wdillon (5/6/2008)

---

Hi Jeff, I got the Tally table thing worked out from finding on another post of yours. WOW!!!! The data looks great!! Do you ever...

nagarajanmm (5/6/2008)

---

Hi,

I need to convert rows into columns for the following table values.

Attribute_ID Attr_Value

1 ...

Hey - I think this is a DUMB question, and the author should get smacked around. I mean - sheesh....

Oh wait - never mind...:D

(thanks for the feedback guys!)

I'm not quite sure what you mean...

Karthik - you're looking at implementing something like in Jeff's article on running aggregates.

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/%5B/url%5D

onlybemine (5/6/2008)

---

Since movign to stored proc is another big investment because of size of work.. which i couldn't do this stage....

Also

How to stop SQL Injection via webforms i am...

If you're hell-bound on using this in a pivot, you might care to check out one of the SQL 2005 alternatives Jeff didn't include in the article: a user-defined aggregate...

well - you're here already - so you're most of the way there already:). Actually - there's a ton of stuff on here about set-based vs. cursors. Just...

There were definitely some interesting usage patterns (people...

Jeff Moden (5/6/2008)

---

GSquared (5/6/2008)

---

Dateadd lists of datetimes. For example, if you need a second-by-second list of all times in a month, or a quarter. (10,000 seconds is a...