Why is the trigger considered part of the transaction?

To me, the transaction would just consist of deleting the record out of the table...Then once that transaction is complete, the trigger...

Yeah what do you think the first thing I did was...GOOGLE duh!

But we have tried those fixes..

Alot of those fixes is talking about the .mdf file when attaching/detaching the database...problem...

Ok nevermind again...I was counting the wrong account number from a different table...I have it now and it is correct...Thank you for your input, it is greatly appreciated!

Nevermind...Worked like a charm with the example I provided,

however when I applied to my original query, I am getting back more results than I was before...Like before the way I...

Thank you sir...That seemed to have worked!

Here is example

First query to get resultcode and put in temp table:

SELECT DISTINCT rc.ResultCode

FROM dbo.ResultCodes rc

RESULTS:

ResultCode

CC

CO

E/O

IP

LM

NA

NP

NR

PX

SS

WN

THEN here is the query I am trying to run:

SELECT rc.ResultCode,

COUNT(a.AccountNumber)

FROM dbo.ResultCodes rc

LEFT OUTER JOIN...

Phil Parkin (2/26/2013)

---

Sounds perfectly do-able to me, though I have some questions:

1) Does the proc always output recordsets with the same meta data?

2) What do you want your output to...

Sorry guys...

I found the issue...Pretty elementary!

I checked the server side and it only allowed Windows authentication logins...

I apologize, I did not state my need clearly...

I know that you can do a datediff on the years to get the birthdate...But that is not entirely accurate

Case in point:

If...

Dummy me...i didnt see that! Sorry about that

Michael Valentine Jones (9/20/2012)

---

This code will work for any date within a quarter to find the end of month for the three months in the prior querter.

select

CurrDateTime,

PriorQtrMonth1 = dateadd(mm,(datediff(QQ,0,CurrDateTime)*3)-2,-1),

PriorQtrMonth2 =...

Here is what I meant:

We are going to be running a report at the end of a current quarter...And for my procedure I need to know what the last day...

So here is what I want the finished result set to look like:

invoice_id rank subscriberid create date ...

I was wrong...That does not work for me...

Try this code:

CREATE TABLE [dbo].[tst_Invoices](

[invoice_id] [int] NULL,

[grouo_id] [int] NULL,

[subscriber_id] [int] NULL,

[createdate] [datetime] NULL,

[duedate] [datetime] NULL

) ON [PRIMARY]

INSERT INTO dbo.tst_Invoices

...

Yes that looks to be what I need...I am going to try it out on my original query...

Never used the DENSE function...Need to look that one up

Thank you so much!