This is the piece of code I use in my triggers:

DECLARE @SQLBuffer nvarchar(4000)

DECLARE @buffer TABLE (

EventType nvarchar(30),

Parameters int,

EventInfo nvarchar(4000)

)

INSERT @buffer

EXEC sp_executesql N'DBCC INPUTBUFFER(@@spid) WITH NO_INFOMSGS'

SELECT @SQLBuffer = EventInfo

FROM @buffer

DBCC INPUTBUFFER(@@SPID) is the only way I have found so far to do this.

All queries involving DMVs did return the trigger code or the calling stored procedure code. I...

No, no other ideas without table scripts, sample data and desired output. It's a shot in the dark this way.

Please see the article in my signature.

Once you provided more info,...

You may find a technique to achieve this in Jeff Moden's article on running totals:

http://www.sqlservercentral.com/articles/T-SQL/68467/

Hope this helps

I don't think you will get any useful replies this way. Many things are missing.

You're not saying which tables are involved and what they look like, and, first of all,...

Try using LEFT join instead of INNER JOIN, assigning a predetermined value to NULL answers (-1 in my example):

SELECT dbo.tbl_Results.User_ID,

dbo.tbl_Questions.Answer AS...

It's impossibile to answer this question without seeing the code.

Please post table scripts and the stored procedure code.

If your tables have triggers defined, post their code too.

It would be very helpful to see what your tables look like.

Anyway, without any other information, all I can tell you is something like this:

SELECT answer, COUNT(*) AS answer_count

FROM answers

WHERE...

Sorry, I removed my reply, since I misunderstood your question.

Have you ever been to Italy, Gift? If so, I...

GilaMonster (3/29/2010)

So...

jcrawf02 (3/26/2010)

So...

It couldn't...

BTW, I received my copy of SQL Server MVP Deep Dives two weeks ago, but I ordered it 3 weeks earlier from Amazon.com, even if I chose the Expedited International...

BTW, I received my copy of SQL Server MVP Deep Dives two weeks ago, but I ordered it 3 weeks earlier from Amazon.com, even if I chose the Expedited International...